search

PHPOffice / PHPExcel

ARCHIVED
Other
11.47k stars 4.19k forks source link

read '00' as string #537

Open lbngoc opened 9 years ago

lbngoc commented 9 years ago

Hi, I have found 1 bugs when read data from cell. The data is '00' (string) but PHPExcel always return value 0 (float) when I call these functions: getValue(), getFormattedValue(), getCalculatedValue(). I just fixed this bug by write a condition to check this special value in function setValueExplicit() (Cell.php),but I think it's not best solution.

og3og commented 9 years ago

Hey, this is solved in version 1.8.1 or you can use the fix I implemented here http://stackoverflow.com/questions/15241733/reading-phone-number-with-leading-zero-by-phpexcel/32619268#32619268