i'm having troubles when the value of a cell consist in a reference to the value of other cell in a different sheet ( = sheetX!A1). In the excelReader generated array the value for the cell is null. Somebody knows how to fix that?
thanks ...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've got a problem with references too. I pinned it down to the following:
o) references to numbers are working
o) references to strings aren't working
hy,
i'm having troubles when the value of a cell consist in a reference to the value of other cell in a different sheet ( = sheetX!A1). In the excelReader generated array the value for the cell is null. Somebody knows how to fix that?
thanks ...
Remember the array is -1 from what you think.
Sheet number one is sheet 0 in the array, so your "second" sheet would be sheet 1 :)
I've got a problem with references too. I pinned it down to the following:
o) references to numbers are working
o) references to strings aren't working
Testcase:
sheet1:
cell A1: =sheet2!A1
cell A2: =sheet2!A2
sheet2:
cell A1: 123,45
cell A2: hello
Result: The reference to the number is recognized by PHP-Excel Reader, but note the reference to the string.
I would be really happy for suggestions to solve this!
Thank you!
Kind regards,
Klemens