Unplanned
Last Updated: 10 Jun 2022 06:02 by IGK
Created by: IGK
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0

With the current implementation, the Notes support only a rectangular shape.

Examples:

Unplanned
Last Updated: 13 Jun 2022 08:01 by IGK
Created by: IGK
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
For cell values like 0001 stored as text, excel will show the error checking options as a green ribbon in the top left corner of the cell. If we click on Ignore Error, the green color ribbon on Top-Left side of the cell will go away. Add support for this to be preserved in the document.
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: 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: 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: 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.
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: 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: 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();
}

 

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: 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: 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:

 

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 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
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: 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: 22 Dec 2022 09:58 by Kheng Aik

LayoutHelper is not calculating Height properly in net standard.

Workaround: use SpreadFixedTextMeasurer

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: 10 Jan 2023 11:06 by Dmytro
Provide an API for changing the position of the chart axes
Completed
Last Updated: 14 Feb 2023 11:34 by ADMIN
Release R1 2023 SP1
If a conditional formatting rule with formula is set to "B1=True" and the cell B1 has value "false", the formatting will still be applied.