|
[text/plain 1.2k]
On Tue Jul 18 06:49:57 2006, brayst[...]uk.ibm.com wrote:
>
> Dear Kawai Takanori,
>
> I'm using Microsoft Excel 2000 SR-1 on Windows 2000 SP4.
>
> I've got some cells where the value is not interpreted correctly.
> Here are two examples, showing what is in the spreadsheet and then
> what Spreadsheet-ParseExcel puts in the cell attributes:
>
> 1. Value: 09/06/2006
> Format: Custom, dd/mm/yyyy
>
> $cell->Value: 09/MM/2006
> $cell->{Val}: 38877
> $cell->{Type}: Numeric
>
>
> 2. Value: 30.62
> Format: Custom, #,##0.00[$%-809]
>
> $cell->Value: 3,062.00[$%0809]
> $cell->{Val}: 30.62
> $cell->{Type}: Numeric
>
> 3. One more thing. The documentation for Spreadsheet::ParseExcel says:
>
> Cell class has these properties:
> Value
> Val
> Type
>
> It doesn't explain that you have to put curly brackets around the
> Val and Type properties.
>
> Thanks very much.
> Steven Bray.
>
Hi Steven,
do you happen to have a small example Excel file and the relevant
script that would trigger this problem? If yes, please send them to
me so I can add them to the regression tests of the module.
thanks
Gabor Szabo <szabgab[...]gmail.com>
|
