Ods Reader wrong cell value

[dangherve]

I have some wrong cell value when i get getCell or getCalculatedValue.

Can it be that the library have some problem when i have merge cell ?

[oleibman]

More information is required. Can you upload the spreadsheet and/or code which is failing for you?

[dangherve]

Extract from my spreadsheet

To read data:
for ($i=1;$i<5;$i++) echo "AS".$i." ".$sheetData->getCell("AS".$i)->getValue()."\n";

Give me this:

AS1 Test AS2 AS3 Total AS4

Should have:

AS1 Test AS2 AS3 A AS4 9

[oleibman]

Thank you for the code and the image. It is still kind of difficult for me to figure out what exactly is going on. Is it possible for you to upload the spreadsheet?

[dangherve]

Sure i upload it here

[oleibman]

I agree that there seems to be a problem. But first things first. The ods workbook that you uploaded doesn't match your diagram above. Here's what I see:

Running your code, I see:

AS1 Atterissage
AS2
AS3 Total
AS4

But I would expect to see:

AS1 Atterissage
AS2
AS3 jour
AS4 =SUM(Y3:INDIRECT(CONCATENATE("Y",$C$3)))

[dangherve]

got the same first image was the same but with different value

[oleibman]

I am going to say that this is related to issue #2507. We are expecting table-row to not descend from another tag. In 2507, table-row descends from table-row-group (which isn't even mentioned in the source code); in this case, it descends from table-header-rows, and, while that is mentioned in the source code, well, you'll see ...

                        case 'table-header-rows':
                            /// TODO :: Figure this out. This is only a partial implementation I guess.
                            //          ($rowData it's not used at all and I'm not sure that PHPExcel
                            //          has an API for this)

//                            foreach ($rowData as $keyRowData => $cellData) {
//                                $rowData = $cellData;
//                                break;
//                            }

It will take me a while to figure out what, if anything, we can do to support this.

[dangherve]

ok thanks just want to know if it was an unknown bug thanks for the answer

[oleibman]

There is a problem with ODS Reader. I hope to submit a PR fixing that within the next few days.

There is a secondary problem with the Calculation Engine (see issue #4530). The calculated value of AS4 should be 32, but PhpSpreadsheet (after PR) will calculate it as 46. The PR will affect only ODS Reader; the calculation problem will remain.

[oleibman]

BTW, I intend to use your spreadsheet in a formal test for the PR. Please let me know if you would rather I not do so.