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.
Completed
Last Updated: 09 Feb 2021 08:42 by ADMIN
Release R1 2021 SP1
Created by: Joshua
Comments: 1
Category: SpreadProcessing
Type: Bug Report
0
Clearing an entire row is too slow.
Completed
Last Updated: 28 Jan 2021 12:07 by ADMIN
Release R1 2021 SP1
Importing XLS document containing defined name with spaces in the sheet name causes exception
Unplanned
Last Updated: 21 Jan 2021 10:04 by ADMIN
Created by: Dmitriy
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1

At this point, only the styling is preserved without the hyperlink itself. Implement logic to add the hyperlink to the generated PDF document.

Workaround: check the attached project.

Completed
Last Updated: 10 Dec 2020 14:37 by ADMIN
Release R1 2021
Exporting a workbook that has a data validation rule applied on a cell with hyperlink inside results in an invalid spreadsheet document. Trying to open the result in MS Excel, an error appears and letting Excel repair the content results in a missing worksheet.
Completed
Last Updated: 09 Dec 2020 15:50 by ADMIN
Release R1 2021
An InvalidOperationException is thrown when importing XLS document containing Extra Table Data record.
Unplanned
Last Updated: 03 Dec 2020 09:51 by ADMIN
Created by: Dimitar
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0

Add support for the EDATE function.

Use the attached custom function as a workaround.

Completed
Last Updated: 20 Nov 2020 12:25 by ADMIN
Release R1 2021
The exception is thrown when importing a document that contains an empty stylesheet tag in its styles.xml part.
Completed
Last Updated: 20 Nov 2020 09:37 by ADMIN
Release R1 2021
ADMIN
Created by: Deyan
Comments: 1
Category: SpreadProcessing
Type: Feature Request
13
Add API for setting custom document properties (metadata). Such are visualized by the common editors, e.g. in MS Excel in the File menu.

Example properties that can be set through the document properties are:

- Title
- Subject
- Author
- Keywords
- Comments
- Last Author
- Creation Date
- Category
- Manager
- Company
Completed
Last Updated: 10 Nov 2020 11:20 by ADMIN
Release R1 2021
Exception when importing a file with missing print settings