Mark Baker

> Edit: it appears that `Worksheet::MERGE_CELL_CONTENT_HIDE` is most similar the previous behavior which is no longer the default? Incorrect: For MS Excel, the behaviour is always to remove the values...

It calculates the value if that cell contains a formula, but also formats the result as a string. That's unnecessary overhead for the default, it only matters if the mode...

Correct... none of the Readers support dynamic tables like pivot tables. That is something we are currently investigating

I just started work on the absolute basics of Pivot Tables for the Xlsx Reader/Writer two weeks ago... at the moment, I have some very simplistic code that just allows...

c.f. [PR #2671](https://github.com/PHPOffice/PhpSpreadsheet/pull/2671) merged for release in version 1.23.0

Sorry that it's taken me so long to get round to assessing this PR, but providing that support for pivot tables is an incredibly useful feature. Thank you for working...

Note that PHPExcel also never implemented the `CELL{}` function

This isn't random: the source of the data is different for these methods. `getHighestColumn()` and `getHighestRow()` return cached values that are read from the file when the worksheet is loaded,...

It's also worth noting that the `getHighestColumn()` and `getHighestRow()` methods support an optional `row` or `column` argument. If they are called with that argument, then they call `getHighestDataColumn()` and `getHighestDataRow()`...

There's already a [PR](https://github.com/PHPOffice/PhpSpreadsheet/pull/2143) in the pipeline to change the behaviour of the calculation engine for passing empty values. However, there is also a known issue with empty arguments in...