search

prabudt / php-excel-reader

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

Special format for integer, wrong value I got... #112

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
Please see my file.
Column 11 (K), string 8.

Format of the cell is setted to "###\ ###\ ##0,00".
In this cell I see value "103,67", but value I got with php-excel-reader is 
"104 104 104".

my code:
<?
require_once "../ExcelParser/excel_reader2.php";

$data = new Spreadsheet_Excel_Reader($fullfilename,true,"UTF-8");
$val = trim($data->val(8, 11, 1));
?>

It's so sad...
And I have no ideas how to fix this bug by myself....

Original issue reported on code.google.com by mail4...@gmail.com on 6 Apr 2011 at 7:01

Attachments:

GoogleCodeExporter commented 8 years ago 
hi there, i'm having a similar problem. Did you ever resolve the problem?

Original comment by danielas...@gmail.com on 22 Apr 2011 at 6:06

GoogleCodeExporter commented 8 years ago 
Sorry. I have not fix this bug yet. But i didn't try hard. I'll try later, when 
i'll have more spare time. 
Please notify me if you can fix it.

Original comment by mail4...@gmail.com on 22 Apr 2011 at 5:40

GoogleCodeExporter commented 8 years ago 
try using the 'raw' method instead of 'val'. 

$val = $data->raw(8, 11, 0);

Original comment by johh...@gmail.com on 20 May 2011 at 2:27

GoogleCodeExporter commented 8 years ago 
mail4bvn, change the format of those cells to format #5 or # ##0,00 to be 
exact. It produces the same result as that long unrecognizable format you 
supplied.

Original comment by endar...@gmail.com on 26 Aug 2011 at 7:38

GoogleCodeExporter commented 8 years ago 
Oh! It's really work!
I just changed 'val' to 'raw' in case of "bad" cell.

Original comment by mail4...@gmail.com on 13 Dec 2011 at 7:02