Unplanned
Last Updated: 04 Nov 2022 08:04 by Ian
Created by: Ian
Comments: 1
Category: SpreadProcessing
Type: Feature Request
4
Provide a stock method for users to easily set the background color over a specific cell selection.
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: 01 Nov 2022 12:25 by Dennis
Inserting new rows above rows containing hyperlinks breaks the hyperlinks.
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: 21 Feb 2023 14:27 by Ivan
Release R1 2023 SP1
InvalidCastException on import when a drawing in a document contains the "ext" tag 
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.
Completed
Last Updated: 15 May 2023 07:03 by ADMIN
Release R1 2023
Wrong color scheme colors leads to wrong cell coloring on export.
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: 06 Sep 2022 07:12 by ADMIN
Release R3 2022
Exception when the comments are imported before the fallback notes.
Unplanned
Last Updated: 24 Aug 2022 10:50 by Christopher
Created by: Christopher
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1

Currently, the following text filters are not supported in the model:

  • begins with
  • does not begin with
  • ends with
  • does not end with
  • contains
  • does not contain
Unplanned
Last Updated: 18 Aug 2022 14:10 by Daniel
 A long formula is wrongly parsed when importing a particular file.
Unplanned
Last Updated: 18 Aug 2022 14:08 by Daniel
Created by: Daniel
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
Add support for the  CELL formula.
Unplanned
Last Updated: 18 Aug 2022 12:45 by Daniel
SpreadProcessing: XlsFormatProvider. Exception when importing a specific document - bad function index (188)
Unplanned
Last Updated: 11 Aug 2022 10:20 by Owen
In Excel, this is done by setting this option on the format cells dialog, the protection tab. It allows you to hide the formula when the sheet is protected. 
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: 02 Aug 2022 09:12 by Henrik
Created by: Henrik
Comments: 0
Category: SpreadProcessing
Type: Feature Request
2
When inserting many values and formulas in a worksheet, it would be useful for the users to have the ability to delay the recalculation for better performance.
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.