Unplanned
Last Updated: 31 Jul 2024 15:10 by Christian

After Excel introduced the dynamic array support, files produced with the older Excel versions have formulas that may be displayed with @ in some contexts. For example a file that had the following:

=SUM(IF(A1:A10=1, B1:B10, 0))

Will be displayed like so:

=SUM(IF(@A1:A10=1, B1:B10, 0))

This is done in order to preserve the behavior of the files created in older versions of Excel.

The files created by SpreadProcessing are also treated by Excel as if they are created by pre-dynamic array Excel. Please, introduce support for the new behavior.

Unplanned
Last Updated: 17 Sep 2024 14:36 by Shailaja
At the moment the only data that can be passed to FloatingChartShape is a CellRange to be parsed to a chart. Some clients would like to use the IChartData implementations: NumericChartData and StringChartData. We need a FloatingChartShape constructors like this:

public FloatingChartShape(Worksheet worksheet, CellIndex cellIndex, IChartData values, IChartData categories)

And others if necessary.
2 3 4 5 6 7