Recently Updated
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 Apr 2022 09:38
by Monique
Created by:
Monique
Comments:
0
Category:
SpreadProcessing
Type:
Feature Request
Introduce support for the WEEKDAY function.
Unplanned
Last Updated:
05 Apr 2022 07:08
by ADMIN
Created by:
Divya
Comments:
2
Category:
SpreadProcessing
Type:
Feature Request
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.
Completed
Last Updated:
04 Apr 2022 07:41
by ADMIN
Release LIB 2022.1.411 (11 Apr 2022)
ADMIN
Created by:
Deyan
Comments:
9
Category:
SpreadProcessing
Type:
Feature Request
Implement support for cell references to columns and rows, e.g. $1:$2, A:D, etc. Currently, CellSelection.SetValue throws ParseException, and CellSelection.SetValueAsFormula throws InvalidOperationException.
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:
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:
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:
14 Mar 2022 16:08
by ADMIN
Release R2 2022
Created by:
Grace
Comments:
1
Category:
SpreadProcessing
Type:
Bug Report
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.
Unplanned
Last Updated:
28 Feb 2022 12:53
by ADMIN
Created by:
Robert
Comments:
2
Category:
SpreadProcessing
Type:
Bug Report
The formula when adding a number to date is not calculated correctly.
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:
16 Feb 2022 12:55
by ADMIN
Release R1 2022 SP1
Created by:
Joseph
Comments:
0
Category:
SpreadProcessing
Type:
Bug Report
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.
Completed
Last Updated:
09 Feb 2022 14:20
by ADMIN
Release R1 2022 SP1
Created by:
alex
Comments:
0
Category:
SpreadProcessing
Type:
Bug Report
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:
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:
08 Feb 2022 12:47
by ADMIN
Created by:
Ruben
Comments:
0
Category:
SpreadProcessing
Type:
Bug Report
Indirect function cannot get named range by name as string or cell value.
Unplanned
Last Updated:
07 Feb 2022 15:55
by Divya
Created by:
Divya
Comments:
0
Category:
SpreadProcessing
Type:
Feature Request
The Spilled range operator (#) is responsible for selecting the whole range of values used after a cell reference.
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.
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.
Completed
Last Updated:
20 Jan 2022 08:18
by ADMIN
Release R1 2022
Created by:
Martin
Comments:
0
Category:
SpreadProcessing
Type:
Feature Request
From the OOXML Specification: A comment is a rich-text note that is attached to and associated with a cell, separate from other cell content.
In Office 365 there are two types of comments:
- Comments/Notes
- Threaded Comments
This item applies to Comments/Notes only.
For Threaded Comments, please follow: SpreadProcessing: Comments (Threaded Comments)
Completed
Last Updated:
20 Jan 2022 08:18
by ADMIN
Release R1 2022
ADMIN
Created by:
Deyan
Comments:
6
Category:
SpreadProcessing
Type:
Feature Request
Add support for conditional formatting of cells - allow applying of rules used during visualization of cells to automatically apply formatting depending on their values.
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.