Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
GoogleCodeExporter opened this issue Jul 24, 2015 · 0 comments
Open

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

GoogleCodeExporter opened this issue Jul 24, 2015 · 0 comments

Comments

@GoogleCodeExporter
Copy link

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 [email protected] on 27 Apr 2012 at 2:33

Attachments:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant