In Development
Last Updated: 08 Aug 2022 14:29 by ADMIN
When a file makes use of differential formats an Index out of range error may be thrown on import.
In Development
Last Updated: 05 Aug 2022 09:53 by ADMIN
The pie chart is not rendered correctly and is not converted to pdf as expected.
Unplanned
Last Updated: 03 Aug 2022 06:36 by ADMIN
When a row or column is inserted in a worksheet that has cells referred from another worksheet, the formula should be updated so it refers to the same values as before the insertion or removal of cells.
Completed
Last Updated: 02 Aug 2022 15:26 by ADMIN
Release R3 2022
Wrong UsedCellRange when the worksheet contains a DataValidation rule.
Completed
Last Updated: 01 Aug 2022 13:53 by ADMIN
Release R3 2022
Changing the sheet name with a string that needs to be escaped results in an invalid file due to missing escaping in the RefersTo value.
Unplanned
Last Updated: 22 Jul 2022 08:44 by ADMIN
Text is cut off in Net Standard with a specific document.
Unplanned
Last Updated: 21 Jul 2022 12:11 by Guilhem
Comparing PDF documents exported by MS Excel and by SpreadProcessing shows slightly different sizes of the cells.
Unplanned
Last Updated: 20 Jul 2022 13:59 by ADMIN
Some of the leftmost borders are omitted when exported to PDF.
Unplanned
Last Updated: 15 Jul 2022 14:02 by Patrick
SpreadProcessing: Copying a cell with a LessThan conditional formatting rule throws a Null reference exception
Completed
Last Updated: 28 Jun 2022 13:16 by ADMIN
Release R3 2022
When an xls file with a large, but still valid column width is imported, an ArgumentException is thrown: "The maximum column width for an individual cell is 255 characters." 
Unplanned
Last Updated: 15 Jun 2022 14:02 by Leigh
Invoking AutoFitWidth/AutoFitHeight in Blazor WASM takes too long time even for small documents.
Completed
Last Updated: 13 Jun 2022 08:48 by ADMIN
Release R2 2022 SP1
When a file is imported that has an unsupported theme color type, the resulting ThemableColor is null. This results in a NullReferenceException on export.
Unplanned
Last Updated: 10 Jun 2022 10:00 by Mandip Kaila
Opening a file where there is a format string with modificator [Color11] causes an ArgumentException "Invalid modificator" This prevents the file from opening.
Unplanned
Last Updated: 06 Jun 2022 09:31 by Patrick

For example:
Renaming a sheet named "Sheet1" to "Sheet 1", should update formulas references to it to 'Sheet 1!' (notice single quotes), which it does not. The formula =SUM(Sheet1!A2:C2) changes to the invalid expression =SUM(Sheet 1!A2:C2). This breaks formulas referencing that sheet.

Workaround:
Iterate all cells with formulas in the workbook and add single quotes to the beginning and end of sheet name reference. The attached project changes the name of Sheet1 and then fixes all formula references to it by enclosing its name in single quotes.

Unplanned
Last Updated: 03 Jun 2022 19:38 by ADMIN
If a cell has a style set (e.g. Bad) and no fill set on the same cell, after import and export, the no fill setting will be lost and the cell will be shown with its cell style instead.

Completed
Last Updated: 26 May 2022 13:15 by ADMIN
Release R2 2022 SP1

SpreadProcessing: Upon export, sheet reference in formulas such as VLOOKUP is lost when using whole row/column references.
For example the formula
=VLOOKUP("test",Sheet1!A:C,1,0) is exported as

=VLOOKUP("test",A:C,1,0)

Unplanned
Last Updated: 19 May 2022 12:32 by Rik

The values applied to the row/column should be explicitly set on each used cell as well. Otherwise, if they are applied on row/column only, the used cells don't use the desired values when opening the document.

To reproduce:

  1. Set some content on cell A1
  2. Create a row selection and apply a fill color to it (or any other property)
  3. Export the document and open it in an application

Observed: All cells except A1 have the specified color.

Workaround: Use cell selection, e.g.:

sheet.Cells[0,10].SetFill(PatternFill.CreateSolidFill(Colors.Red));

Unplanned
Last Updated: 06 May 2022 04:25 by IGK
Add API that allows one to manipulate the macros inside a Workbook.
Unplanned
Last Updated: 04 May 2022 08:38 by Dimitar
Chart not visible when file has OneCellAnchor xaml element.
Completed
Last Updated: 18 Apr 2022 09:05 by ADMIN
Release R2 2022

The format applied to the first value of the range of the chart determines the format of the value (vertical) axis. If the format of this value is changed, the model attempts to set a new format to the axis. If the chart does not support axes, the value of its PrimaryAxes property is null, which causes NullReferenceException.

1 2 3 4 5 6