problem reading number in openoffice calc File

CPAN::Forum

Thread

Spreadsheet-ParseExcel [search.cpan.org] [Kobes search] [View and report bugs] [Ratings 4.7

(7) ]

[AnnoCPAN] [CPAN Tests results] [CPANTS]

Posted on Fri Aug 11 11:23:01 2006 by xgaulard

problem reading number in openoffice calc File

hi, In reading en open office calc file, ParseExcel display "GENERAL" in place at the number value. I must modifie the file with Microsoft Excel end save it and i don't have the problem with the library. Someone have a solution ? Thanks.

Direct Responses: 3002 | 5691 | Write a response

Posted on Tue Sep 12 09:23:49 2006 by hmbrand in response to 2778

Re: problem reading number in openoffice calc File

OpenOffice files are not to be opened with Spreadsheet::ParseExcel.
For OpenOffice there is Spreadsheet::ReadSXC, which also happens to happily parse OO-2.0 (ods) files.

Write a response

Posted on Fri Jul 13 08:54:56 2007 by pajamian in response to 2778

Re: problem reading number in openoffice calc File

I'm having this same problem with a file saved in .xls format from OpenOffice (note saved in ms excel format). Googling seems to show that the problem was fixed a couple years ago by the debian folks so why hasn't the fix been applied to the CPAN source yet?

Note that I found a suitable workaround to be:

my $val = $oWkC->Value eq 'GENERAL' ? $oWkC->{Val} : $oWkC->Value;

I'd much rather see the problem fixed properly in the module, though, than have to apply that workaround to all my code.

More info and patch for this problem can be found here and here.

Write a response

Service launched on 2nd of February 2005.
Comments, and other submissions on CPAN Forum are Copyright 2005-2007, their respective owners.
Site maintainer is not responsible for content. Privacy Policy

Maintained and hosted by Gabor Szabo at Perl Training Israel