ivan-berezhnov / php-excel-reader

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

type() don't works properly #60

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1.type() function returns empty values
2.
3.

What is the expected output? What do you see instead?
type of data in a cell

Please provide any additional information below.
I tried to aqquire the type of data in date cell, but it returns empty value.

Original issue reported on code.google.com by xgra...@gmail.com on 19 Jan 2010 at 12:10

GoogleCodeExporter commented 9 years ago
Can you repost this error on my branch of the application at:
http://code.google.com/p/php-excel-reader2/

Can you attach your Excel/PHP ?

Original comment by sirsh...@gmail.com on 19 Jan 2010 at 12:30

GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
I had the same issue with v2.22 :

The public function type() calls info() function, which is looking for a key 
named
'type' (line 354). But in function _getCellDetails, on line 1527, the type is
associated to the key "rectype" :

return array ('string' => $string, 'raw' => $raw, 'rectype' => $rectype, 
'format' =>
$format, 'formatIndex' => $formatIndex, 'fontIndex' => $fontIndex, 
'formatColor' =>
$formatColor, 'xfIndex' => $xfindex );

I changed the line 1527 by this one, and type() worked as expected :

return array ('string' => $string, 'raw' => $raw, 'type' => $rectype, 'format' 
=>
$format, 'formatIndex' => $formatIndex, 'fontIndex' => $fontIndex, 
'formatColor' =>
$formatColor, 'xfIndex' => $xfindex );

Note : be sure to not create an instance of your reader with the second 
argument to
'false' or the information about cells won't be available.

Original comment by phoenni...@gmail.com on 24 Feb 2010 at 10:52

GoogleCodeExporter commented 9 years ago
The issue was fixed!!

Thank you very much.

Original comment by xgra...@gmail.com on 24 Feb 2010 at 11:15

GoogleCodeExporter commented 9 years ago
This bug is still present in the last version (php-excel-reader-2.21.zip).

Somewhere near line #1651 find the next line:
'rectype'=>$rectype,
and change it to
'type'=>$rectype,

And all will be OKI-DOKI!

Original comment by beoti...@gmail.com on 7 Jun 2010 at 1:51