Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

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

by swl (Priest)
on May 28, 2020 at 22:10 UTC ( #11117439=note: print w/replies, xml ) Need Help??


in reply to Looking for assistance for proper fix for Spreadsheet::XLSX bug(?)

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]

      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]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://11117439]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (9)
As of 2021-04-15 15:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found
    Notices?