Unplanned
Last Updated: 10 Jan 2023 11:06 by Dmytro
Provide an API for changing the position of the chart axes
Unplanned
Last Updated: 05 Jan 2023 13:49 by Eljay

When a worksheet contains a cell with longer text, which is right aligned and this text happens to be in the last column of the page, the worksheet is incorrectly split into pages and the last column gets transferred on the next page.

Workaround: Set explicitly the print area you would like to print.

worksheet.WorksheetPageSetup.PrintArea.SetPrintArea(new CellRange(0, 0, 38, 14));

Unplanned
Last Updated: 22 Dec 2022 09:58 by Kheng Aik

LayoutHelper is not calculating Height properly in net standard.

Workaround: use SpreadFixedTextMeasurer

Unplanned
Last Updated: 08 Dec 2022 09:53 by Joe
XlsFormatProvider: LeftoverDataException when importing a specific document. 'Initialisation of record 0x55(DefaultColWidthRecord) left 2 bytes remaining still to be read.'
Unplanned
Last Updated: 07 Dec 2022 10:50 by n/a
Memory leaks when importing large documents with formulas consecutively. So weak events still remain in the memory. 
Unplanned
Last Updated: 28 Nov 2022 06:34 by Ralf

 Provide the following options for the image:

  • Move and size with cells
  • Move but don't size with the cells
  • Don't move or size with the cells
Completed
Last Updated: 19 Jan 2023 14:56 by ADMIN
Release R1 2023

When a file uses shared formulas, if the cell references are not explicitly written in the cell element, the formulas will not be shown correctly. This will manifest like a file that has a succession of slightly differing formulas in Excel and in RadSpreadsheet or RadSpreadProcessing they will be a succession of the same formula instead.

Unplanned
Last Updated: 28 Oct 2022 09:59 by Jan Brandenburger

When autofit is applied on a button with a filter, the button width is not taken into account and it overlaps the text.

Expected:

Actual:

 

Unplanned
Last Updated: 18 Oct 2022 06:55 by Blas
SpreadProcessing: The data validation rules are not exported correctly when importing and then exporting a XLSM file
Unplanned
Last Updated: 18 Oct 2022 06:45 by Blas

SpreadProcessing: InvalidOperationException when opening an XLS document with a named range that refers to a formula. The message is "Only applicable to named ranges". Opened correctly in Excel. 

 

Unplanned
Last Updated: 14 Oct 2022 11:53 by Carlos

Parsing a document that contains a cell with wrapped multiline text and its row doesn't define a value for height, results in wrong row height when rendering or exporting to PDF.

Workaround: Fit the height of the row when it contains wrapped cells:

 

Worksheet worksheet = workbook.ActiveWorksheet;
CellRange wrappedCells = worksheet.GetUsedCellRange(CellPropertyDefinitions.IsWrappedProperty);

for (int i = wrappedCells.FromIndex.RowIndex; i < wrappedCells.ToIndex.RowIndex; i++)
{
    worksheet.Rows[i].AutoFitHeight();
}

 

Completed
Last Updated: 19 Jan 2023 14:56 by ADMIN
Release R1 2023
The relationship ID is needed to parse the hyperlink target and is mandatory by the specification. However, XlsxFormatProvider throws an exception while reading that hyperlink and cannot open the document.
Unplanned
Last Updated: 12 Sep 2022 10:56 by Bill
Currently, the only way to set a culture for the SpreadProcessing is through the static property FormatHelper.CultureHelper. That way the value is shared between all instances of the SpreadProcessing. There has to be an API allowing to set different cultures for the different instances of the SpreadProcessing.
Completed
Last Updated: 16 Aug 2022 07:12 by ADMIN
Release R3 2022
When a file makes use of differential formats an Index out of range error may be thrown on import.
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.
Completed
Last Updated: 28 Apr 2023 13:45 by ADMIN
SpreadProcessing: Copying a cell with a LessThan conditional formatting rule throws a Null reference exception
Completed
Last Updated: 02 Aug 2022 15:26 by ADMIN
Release R3 2022
Wrong UsedCellRange when the worksheet contains a DataValidation rule.
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: 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.
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)