Unplanned
Last Updated: 23 Jun 2021 06:24 by ADMIN
Handle the case where a formula cannot be parsed and continue loading the document. Now there is an exception and the document is not loaded. 
Completed
Last Updated: 10 Jun 2021 13:32 by ADMIN
Release R2 2021 SP1
Exception when copying worksheet that contains a shape
Unplanned
Last Updated: 07 Jun 2021 09:35 by ADMIN
Created by: N
Comments: 0
Category: SpreadProcessing
Type: Feature Request
2
The Open Document Format for Office Applications (ODF), also known as OpenDocument, is an open standard file format for spreadsheets, charts, presentations, and word processing documents using ZIP-compressed[6] XML files.

The most common filename extension for spreadsheets is .ods.
Unplanned
Last Updated: 28 May 2021 07:19 by ADMIN
Created by: Sean
Comments: 2
Category: SpreadProcessing
Type: Feature Request
0
Introduce support for  data connected query
Completed
Last Updated: 17 May 2021 08:30 by ADMIN
Release R2 2021
Expose an easy way to create .xlsx documents from DataTable objects.
Unplanned
Last Updated: 30 Apr 2021 10:54 by ADMIN
Created by: Shawn
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
Add support for Microsoft Office XML formats - https://en.wikipedia.org/wiki/Microsoft_Office_XML_formats
Completed
Last Updated: 29 Mar 2021 12:09 by ADMIN
ADMIN
Created by: Nikolay Demirev
Comments: 2
Category: SpreadProcessing
Type: Feature Request
6
The cell contains the following data in OOXML:

<f>SUM(1,2,3)</f> - The formula
<v>6</v> - the calculated value

The formula value is imported, but the calculated value is skipped. The feature will be useful if Manual calculation option is supported: https://feedback.telerik.com/Project/184/Feedback/Details/191275-spreadsheet-add-support-for-different-calculation-options-automatic-or-manual
Completed
Last Updated: 29 Mar 2021 11:53 by ADMIN
Release R2 2021
Exporting documents containing two or more cell styles with the same properties, but different names cause invalid document.
Unplanned
Last Updated: 22 Mar 2021 07:26 by ADMIN
SpreadProcessing: Setting cell value to a numeric constant like double.NaN causes an error when the document is loaded in Excel
Completed
Last Updated: 18 Mar 2021 15:05 by ADMIN
Release R2 2021
Created by: Joshua
Comments: 1
Category: SpreadProcessing
Type: Bug Report
0
After copy-paste, the workbooks used in the WorksheetFragment are disposed of, but their NamesCollections are not cleared.
Completed
Last Updated: 05 Mar 2021 14:06 by ADMIN
Release R2 2021
An invalid file is generated when the freezing panes are set and the file is opened in Excel
Unplanned
Last Updated: 05 Mar 2021 08:41 by ADMIN
Specific documents are imported with a wrong column width which leads to a wrong preview of the cell content.
Unplanned
Last Updated: 26 Feb 2021 10:13 by ADMIN
When the cell content overflows the cell width the left cell border is not exported to PDF.
Unplanned
Last Updated: 26 Feb 2021 08:13 by ADMIN
Some documents containing a lot of worksheets with complex data and images cause slow importing and/or exporting.
Unplanned
Last Updated: 19 Feb 2021 10:04 by ADMIN

When the Workbook has more than one sheet a localSheetId should be exported: 

<definedName name="xlnm.Print_Titles" localSheetId="0">Sheet1!$A$1</definedName>

localSheetId (from the OOXML specification): Specifies a boolean value that indicates whether the defined name is related to an external function, command, or other executable code.

Completed
Last Updated: 18 Feb 2021 14:38 by ADMIN
Release R1 2021 SP1
Provide an API that can be used to change the culture used by the library. This way a culture different from the current thread culture can be used.
Unplanned
Last Updated: 18 Feb 2021 10:44 by ADMIN

When the spreadsheet contains empty rows and the format of some cells is set the rows are still exported to pdf or printed.  

To workaround this set the print area with the following code:

IPropertyDefinition[] propertyDefinitionsAffectiingPringing = new IPropertyDefinition[] { CellPropertyDefinitions.ValueProperty };
CellRange usedCellRange = workbook.Worksheets[0].GetUsedCellRange(propertyDefinitionsAffectiingPringing);

workbook.Worksheets[0].WorksheetPageSetup.PrintArea.SetPrintArea(usedCellRange);

 

Completed
Last Updated: 12 Feb 2021 12:54 by ADMIN
Release R1 2021 SP1
The TabColor is lost on import/export and setting in the code
Completed
Last Updated: 12 Feb 2021 11:48 by ADMIN
Release LIB 2021.1.215 (15/2/2021)
When a workbook (xlsx) contains a worksheet where some of the columns have width, bigger than the value written in the SpreadsheetDefaultValues (2000) an exception during the import is thrown.
Completed
Last Updated: 09 Feb 2021 13:50 by ADMIN
Release R1 2021 SP1
When a NonTopLeftCellInMergedRange has a value set the column width is wrongly calculated.