Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
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;
  • 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 (Vicar) 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

      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.

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 scrutinizing the Monastery: (4)
As of 2020-10-31 04:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favourite web site is:












    Results (286 votes). Check out past polls.

    Notices?