http://qs321.pair.com?node_id=11117439


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