search

duongthanhtam2 / php-excel-reader

Automatically exported from code.google.com/p/php-excel-reader
0 stars 0 forks source link

Custom and wrong number formats not read #50

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?

1.Use a sheet with custom number formats in cell. When the syntax of the format 
is wrong, the 
lib doesn't read the value of the cell.  

What is the expected output? What do you see instead?
Instead of reading the cell's value, it outputs the actual (wrong) syntax of 
the number format.

Please provide any additional information below.
For instance i received a spreadsheet from a customer with custom number 
formats: ???, ????, ???
??. Now, for all the cells that use these formats, the class returns ???, ????, 
?????.

Anyone had the same problem? I know I could just remove all the formats, but it 
should be 
automated somehow in my project, because the files are sent by machines not by 
users. 

THANKS !

Original issue reported on code.google.com by attana...@gmail.com on 14 Oct 2009 at 1:26

GoogleCodeExporter commented 9 years ago 
Ok I'm an excel noob ... The syntax wasn't wrong. The ? is a digit placeholder. 
Quoting a excel tutorial:

"The code leaves a space for insignificant zeros but does not display them."

But still I do not understand what it means.

Sorry for the spam!

Original comment by attana...@gmail.com on 14 Oct 2009 at 2:16