ughimire / php-excel-reader

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

Wrong number format is applied? 19,90 turns into 20 #147

Open GoogleCodeExporter opened 9 years ago

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

simply read and print out the data and see the problem at hand:
$data = new Spreadsheet_Excel_Reader("../../SandeliuLikuciai.xls");
$array=array('data'=>$data->sheets[0]['cells']);
unset($array['data'][1]);
print_r($array);

What is the expected output? What do you see instead?

Cell has number 19,90 (with format #.##0,00)
Reader gives me number 20, which I would get in Excel as well if I changed 
number format to #.##0;-#.##0

Please provide any additional information below.
Attached a file that is being read. Checking lines 242 in the files, which have 
cents after , sign
Problem is definitelly with numbar format, but can't seem to find how to fix 
it, Please help

Original issue reported on code.google.com by isgra...@gmail.com on 27 Apr 2012 at 2:33

Attachments: