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)

Completed
Last Updated: 31 Aug 2022 07:22 by ADMIN
Release R3 2022
Chart not visible when file has OneCellAnchor xaml element.
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: 03 May 2022 11:44 by ADMIN
ADMIN
Created by: Tanya
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
Currently, indexed colors are imported only regarding the default color palette. Instead, when the entire palette is predefined using a construct like: 

  <colors>
    <indexedColors>
      <rgbColor rgb="00000000"/>
      ...

in styles.xml part, the indexed should be changed with the provided ones. As this feature is not implemented, such colors are changed during the import.
Unplanned
Last Updated: 05 Apr 2022 07:08 by ADMIN
Created by: Divya
Comments: 2
Category: SpreadProcessing
Type: Feature Request
0
A feature in Excel allows adding ActiveX controls in the Worksheets. You can insert the ActiveX controls from the Developer ribbon tab from the insert button. As it is a missing feature it is not imported and thus removed from the document on export.
Unplanned
Last Updated: 07 Feb 2022 15:55 by Divya
Created by: Divya
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
The Spilled range operator (#) is responsible for selecting the whole range of values used after a cell reference.
Completed
Last Updated: 09 Feb 2022 14:20 by ADMIN
Release R1 2022 SP1
The error is with a message "Index and count must refer to a location within the string (Parameter 'count')" and is thrown inside the FormatHelper.FindAllOccurrences method.
Completed
Last Updated: 18 Apr 2022 14:08 by ADMIN
Release R2 2022
DataTableFormatProvider: One should be able to set the AllowDBNull property of each column.
Completed
Last Updated: 16 Feb 2022 12:55 by ADMIN
Release R1 2022 SP1
If some notes exist below the inserted/removed cells, the notes need to be moved as well along with the rest of the cells. Currently, after insert/remove, the notes are still associated with the original cell index thus are in the wrong cells.
Unplanned
Last Updated: 22 Dec 2021 09:25 by ADMIN
Formula evaluation causes an endless loop when importing a specific file
Unplanned
Last Updated: 08 Feb 2022 12:47 by ADMIN
Indirect function cannot get named range by name as string or cell value.
Completed
Last Updated: 14 Mar 2022 16:08 by ADMIN
Release R2 2022
Applying conditional formatting to different worksheets and exporting the file to XLSX results in a file with conditional formatting on the active sheet only. The conditional formatting on the rest of the worksheets is lost. 
Completed
Last Updated: 16 Aug 2022 12:18 by ADMIN
Release LIB 2022.2.822 (22 Aug 2022)
The pie chart is not rendered correctly and is not converted to pdf as expected.
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.

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.
Unplanned
Last Updated: 03 Feb 2023 13:15 by Michael Nikolai
The firstSheet attribute of the workbookView element is missing causing Excel to not scroll the sheets in the sheet selector.
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: 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