Re: Looking for assistance for proper fix for Spreadsheet::XLSX bug(?)

by swl (Vicar)

on May 28, 2020 at 22:10 UTC ( #11117439=note: print w/replies, xml )

Need Help??

The first thing is to report this as a bug, but there appear to have been no responses to rt bugs since the last release.

If it's just local patching then you could try superclassing Spreadsheet::XLSX. For example (untested and incomplete):

package Spreadsheet::XLSX::Fourecks;

use parent qw /Spreadsheet::XLSX/;

sub __load_styles {
...
}

1;
[download]

Comment on Re: Looking for assistance for proper fix for Spreadsheet::XLSX bug(?) Download Code

Replies are listed 'Best First'.
Re^2: Looking for assistance for proper fix for Spreadsheet::XLSX bug(?) by nysus (Parson) on May 28, 2020 at 22:19 UTC
Thanks. But how is the parsing software supposed to handle those custom format codes? I’m not sure how it is supposed to work. I don’t want to have to add a new format each time something similar pops up. $PM = "Perl Monk's"; $MCF = "Most Clueless ~~Friar~~ ~~Abbot~~ ~~Bishop~~ ~~Pontiff~~ ~~Deacon~~ ~~Curate~~ ~~Priest~~ Vicar"; $nysus = $PM . ' ' . $MCF; Click here if you love Perl Monks	[reply]
Re^3: Looking for assistance for proper fix for Spreadsheet::XLSX bug(?) by swl (Vicar) on May 28, 2020 at 23:02 UTC
Good point. My suggestion only patches in your own method/s. It does not generalise the parsing. I know nothing about excel custom format codes, so unfortunately cannot help on that front.	[reply]

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://11117439]
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others examining the Monastery: (2)

As of 2022-06-27 05:25 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

Notices^?