Unplanned
Last Updated:
13 Aug 2021 06:31
by ADMIN
Created by:
Irina
Comments:
0
Category:
SpreadProcessing
Type:
Bug Report
Wrong text position in a specific file when exporting to PDF
Unplanned
Last Updated:
23 Aug 2021 08:41
by ADMIN
Created by:
Pascal
Comments:
0
Category:
SpreadProcessing
Type:
Feature Request
Provide API to set the position of the second axis (left or right).
Completed
Last Updated:
03 Sep 2021 12:34
by ADMIN
Release R3 2021
Created by:
Robby
Comments:
0
Category:
SpreadProcessing
Type:
Bug Report
Exporting sheet properties corrupts the file and it cannot be opened in Excel.
In the latest version we export:
<sheetPr>
<pageSetUpPr fitToPage="true" />
<tabColor rgb="FF92D050" />
</sheetPr>
Excel cannot read this and tries to recover the file unsuccessfully. This works in R3 2020.
Completed
Last Updated:
20 Sep 2021 14:07
by ADMIN
Release R3 2021 SP1
Created by:
Nicola
Comments:
1
Category:
SpreadProcessing
Type:
Bug Report
When importing a document containing a destination that does not refer to a formula an exception is thrown: System.NullReferenceException: 'Object reference not set to an instance of an object.'
Unplanned
Last Updated:
05 Oct 2021 08:02
by ADMIN
Created by:
Bernard
Comments:
0
Category:
SpreadProcessing
Type:
Bug Report
When importing a document with encrypted records a NotImplementedException is thrown: System.NotImplementedException: "Implement it based on poi 4.2 in the future".
Unplanned
Last Updated:
05 Sep 2023 12:17
by ADMIN
Created by:
Pavel
Comments:
0
Category:
SpreadProcessing
Type:
Bug Report
The import process takes much time when the formatting of the cells needs to be resolved.
Unplanned
Last Updated:
08 Nov 2021 09:21
by ADMIN
Created by:
Erwin
Comments:
0
Category:
SpreadProcessing
Type:
Feature Request
The XlsFormatProvider currently doesn't support charts and skips them while importing or exporting a document.
Completed
Last Updated:
17 Dec 2021 16:24
by ADMIN
Release R1 2022
Created by:
Jin Teik
Comments:
1
Category:
SpreadProcessing
Type:
Bug Report
The full data for the images is not copied and they are missing in the target worksheet.
Unplanned
Last Updated:
03 Jan 2022 14:42
by ADMIN
Created by:
Wilfried
Comments:
0
Category:
SpreadProcessing
Type:
Feature Request
Currently, Formats such as Office 2003 XML are not supported. Introduce support for Excel 2003 XML Format.
Completed
Last Updated:
17 Feb 2022 15:22
by ADMIN
Release R1 2022 SP1
Created by:
Dan
Comments:
3
Category:
SpreadProcessing
Type:
Feature Request
Provide API for converting cell range name to CellRange.
Completed
Last Updated:
08 Feb 2022 13:22
by ADMIN
Release R1 2022 SP1
Created by:
Tom
Comments:
1
Category:
SpreadProcessing
Type:
Bug Report
NullReferenceException when importing a document that contains vml shapes with no row and column
Unplanned
Last Updated:
21 Jan 2022 15:30
by ADMIN
Created by:
Joseph
Comments:
0
Category:
SpreadProcessing
Type:
Feature Request
Currently, the notes can contain plain text only. Allow inserting and preserving formatted text inside the notes.
Unplanned
Last Updated:
01 Feb 2022 08:23
by ADMIN
Created by:
Mandip Kaila
Comments:
0
Category:
SpreadProcessing
Type:
Feature Request
Enable the users to execute the macros that are inside their files.
Completed
Last Updated:
16 Mar 2022 07:45
by ADMIN
Release R2 2022
Created by:
Robert
Comments:
1
Category:
SpreadProcessing
Type:
Feature Request
When importing a document with an unclosed <br> element in the vmlDrawing part an exception is thrown: System.Xml.XmlException: 'The 'br' start tag on line 183 position 14 does not match the end tag of 'font'. Line 184, position 7.'
Completed
Last Updated:
16 Mar 2022 13:51
by ADMIN
Release R2 2022
Created by:
Nicholas
Comments:
1
Category:
SpreadProcessing
Type:
Feature Request
In newer versions of EXCEL (2019 and later) the CONCAT function is introduced as a replacement of the old CONCATENATE function. It adds the ability to specify a range of cells when generating the resulting string in addition to its previously supported input arguments.
NOTE: In EXCEL starting from version 2019, CONCATENATE can no longer be inserted in the worksheet through the UI, it can only be used if you type it directly in the cell's contents.
NOTE: In EXCEL starting from version 2019, CONCATENATE can no longer be inserted in the worksheet through the UI, it can only be used if you type it directly in the cell's contents.
Completed
Last Updated:
25 Mar 2022 13:46
by ADMIN
Release R2 2022
Created by:
Gabriel
Comments:
1
Category:
SpreadProcessing
Type:
Bug Report
The attribute is lost when importing a document. This might lead to corrupting the macros.
Completed
Last Updated:
13 Apr 2022 14:14
by ADMIN
Release R2 2022
Created by:
Franz
Comments:
2
Category:
SpreadProcessing
Type:
Bug Report
Hello,
An exception is thrown when importing an xlsx file which has a comment that does not have an author. But the author may be null.
System.ArgumentException: 'author'
This exception was originally thrown at this call stack:
Telerik.Windows.Documents.Spreadsheet.Utilities.Guard.ThrowExceptionIfNullOrEmpty(string, string)
Telerik.Windows.Documents.Spreadsheet.Model.NoteCollection.Add(Telerik.Windows.Documents.Spreadsheet.Model.CellIndex, Telerik.Windows.Documents.Spreadsheet.Model.CellIndex, string, string)
Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Contexts.XlsxWorksheetImportContext.ApplyNoteInfo(Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Contexts.NoteBase)
Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Model.Elements.Comments.CommentElement.OnAfterRead(Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Import.IXlsxWorksheetImportContext)
Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Model.Elements.Comments.CommentsElementBase.OnAfterRead(Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Import.IXlsxWorkbookImportContext)
Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase<TImportContext, TExportContext, TPartsManager>.OnAfterRead(Telerik.Windows.Documents.FormatProviders.OpenXml.Import.IOpenXmlImportContext)
Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase.Read(Telerik.Windows.Documents.FormatProviders.OpenXml.IOpenXmlReader, Telerik.Windows.Documents.FormatProviders.OpenXml.Import.IOpenXmlImportContext)
Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase.ReadChildElements(Telerik.Windows.Documents.FormatProviders.OpenXml.IOpenXmlReader, Telerik.Windows.Documents.FormatProviders.OpenXml.Import.IOpenXmlImportContext)
Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase.Read(Telerik.Windows.Documents.FormatProviders.OpenXml.IOpenXmlReader, Telerik.Windows.Documents.FormatProviders.OpenXml.Import.IOpenXmlImportContext)
Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase.ReadChildElements(Telerik.Windows.Documents.FormatProviders.OpenXml.IOpenXmlReader, Telerik.Windows.Documents.FormatProviders.OpenXml.Import.IOpenXmlImportContext)
...
[Call Stack Truncated]This is the code that can be used to reproduce the issue, according to your documentation:
Workbook workbook;
XlsxFormatProvider formatProvider = new XlsxFormatProvider();
using (Stream input = new FileStream(_path, FileMode.Open))
{
workbook = formatProvider.Import(input);
}I have attached a document that got a comment without an author.
Unplanned
Last Updated:
05 Jun 2025 11:46
by ADMIN
Created by:
IGK
Comments:
4
Category:
SpreadProcessing
Type:
Bug Report
Add API that allows one to manipulate the macros inside a Workbook.
Unplanned
Last Updated:
19 May 2022 12:32
by Rik
Created by:
Rik
Comments:
0
Category:
SpreadProcessing
Type:
Bug Report
The values applied to the row/column should be explicitly set on each used cell as well. Otherwise, if they are applied on row/column only, the used cells don't use the desired values when opening the document.
To reproduce:
- Set some content on cell A1
- Create a row selection and apply a fill color to it (or any other property)
- Export the document and open it in an application
Observed: All cells except A1 have the specified color.
Workaround: Use cell selection, e.g.:
sheet.Cells[0,10].SetFill(PatternFill.CreateSolidFill(Colors.Red));
Unplanned
Last Updated:
06 Jun 2022 09:31
by Patrick
Created by:
Patrick
Comments:
0
Category:
SpreadProcessing
Type:
Bug Report
For example:
Renaming a sheet named "Sheet1" to "Sheet 1", should update formulas references to it to 'Sheet 1!' (notice single quotes), which it does not. The formula =SUM(Sheet1!A2:C2) changes to the invalid expression =SUM(Sheet 1!A2:C2). This breaks formulas referencing that sheet.
Workaround:
Iterate all cells with formulas in the workbook and add single quotes to the beginning and end of sheet name reference. The attached project changes the name of Sheet1 and then fixes all formula references to it by enclosing its name in single quotes.