Recently Updated
Completed
Last Updated:
13 Jun 2022 08:48
by ADMIN
Release R2 2022 SP1
ADMIN
Created by:
Anna
Comments:
0
Category:
SpreadProcessing
Type:
Bug Report
When a file is imported that has an unsupported theme color type, the resulting ThemableColor is null. This results in a NullReferenceException on export.
Unplanned
Last Updated:
13 Jun 2022 08:01
by IGK
Created by:
IGK
Comments:
0
Category:
SpreadProcessing
Type:
Feature Request
For cell values like 0001 stored as text, excel will show the error checking options as a green ribbon in the top left corner of the cell. If we click on Ignore Error, the green color ribbon on Top-Left side of the cell will go away. Add support for this to be preserved in the document.
Unplanned
Last Updated:
10 Jun 2022 10:00
by Mandip Kaila
Created by:
Mandip Kaila
Comments:
0
Category:
SpreadProcessing
Type:
Bug Report
Opening a file where there is a format string with modificator [Color11] causes an ArgumentException "Invalid modificator" This prevents the file from opening.
Unplanned
Last Updated:
10 Jun 2022 06:02
by IGK
Created by:
IGK
Comments:
0
Category:
SpreadProcessing
Type:
Feature Request
With the current implementation, the Notes support only a rectangular shape.
Examples:
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.
Unplanned
Last Updated:
03 Jun 2022 19:38
by ADMIN
ADMIN
Created by:
Anna
Comments:
0
Category:
SpreadProcessing
Type:
Bug Report
If a cell has a style set (e.g. Bad) and no fill set on the same cell, after import and export, the no fill setting will be lost and the cell will be shown with its cell style instead.
Completed
Last Updated:
26 May 2022 13:15
by ADMIN
Release R2 2022 SP1
Created by:
Patrick
Comments:
1
Category:
SpreadProcessing
Type:
Bug Report
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)
Unplanned
Last Updated:
23 May 2022 13:16
by Tino
Created by:
Tino
Comments:
0
Category:
SpreadProcessing
Type:
Feature Request
Implement NewLine property in the CsvSettings class.
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 May 2022 04:25
by IGK
Created by:
IGK
Comments:
0
Category:
SpreadProcessing
Type:
Bug Report
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
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.
<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.
Completed
Last Updated:
18 Apr 2022 14:08
by ADMIN
Release R2 2022
Created by:
Terry
Comments:
1
Category:
SpreadProcessing
Type:
Feature Request
DataTableFormatProvider: One should be able to set the AllowDBNull property of each column.
Completed
Last Updated:
18 Apr 2022 09:05
by ADMIN
Release R2 2022
ADMIN
Created by:
Anna
Comments:
1
Category:
SpreadProcessing
Type:
Bug Report
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:
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.'
