Bug#298484: Looking into it...

[Gunnar Wolf]

Ok, thanks for the report. I will look into it soon, I have to dig a
bit into the module's internals... In the meanwhile, in order for you
to keep using it for your work, you might consider this: In the
Spreadsheet::ParseExcel::Cell documentation (inside
Spreadsheet::ParseExcel's man page), you have this:

       Cell class has these properties:

       Value
           Method Formatted value of that cell

       Val Original Value of that cell

So, if you do not ask for the cell value to be returned formatted (I
have to dig on what does this exactly mean), it works correctly:

$ perl -MSpreadsheet::ParseExcel -le 'print Spreadsheet::ParseExcel->new->Parse("general.xls")->{Worksheet}[0]{Cells}[0][0]{Val}' 
1210

Just for the record: I got the same result here from creating an empty
spreadsheet with any given value in the A1 cell. I got the same
'GENERAL' having a red 1210 and having a simple default 1, I got the
right value if the A1 cell had a blank space in it.

Greetings,

-- 
Gunnar Wolf - gwolf@gwolf.org - (+52-55)1451-2244 / 5554-9450
PGP key 1024D/8BB527AF 2001-10-23
Fingerprint: 0C79 D2D1 2C4E 9CE4 5973  F800 D80E F35A 8BB5 27AF