Unplanned
Last Updated: 26 Jan 2023 22:07 by Ivan
InvalidCastException on import when a drawing in a document contains the "ext" tag 
Completed
Last Updated: 24 Jan 2023 10:29 by ADMIN
Release R3 2022 SP1
Text is cut off in Net Standard with a specific document.
Unplanned
Last Updated: 24 Jan 2023 09:20 by ADMIN
Created by: Marcos Mataloni
Comments: 13
Category: SpreadProcessing
Type: Feature Request
16

Hello,

we would like to have the capability to create a chart in excel export using Telerik.Documents.Spreadsheet 

Marcos

Unplanned
Last Updated: 23 Jan 2023 10:13 by ADMIN
This happens only on import, that is, if the values are created through UI or through the model, it does not happen. A sheet has a formula A which depends on a cell B and this cell also has a reference to another cell C and the formula A is so placed in the sheet so that it will be imported before cell B. When cell C is updated, the value in A will not be recalculated.
Completed
Last Updated: 19 Jan 2023 14:56 by ADMIN
Release R1 2023
The relationship ID is needed to parse the hyperlink target and is mandatory by the specification. However, XlsxFormatProvider throws an exception while reading that hyperlink and cannot open the document.
Completed
Last Updated: 19 Jan 2023 14:56 by ADMIN
Release R1 2023

When a file uses shared formulas, if the cell references are not explicitly written in the cell element, the formulas will not be shown correctly. This will manifest like a file that has a succession of slightly differing formulas in Excel and in RadSpreadsheet or RadSpreadProcessing they will be a succession of the same formula instead.

Unplanned
Last Updated: 10 Jan 2023 11:06 by Dmytro
Provide an API for changing the position of the chart axes
Unplanned
Last Updated: 06 Jan 2023 14:42 by Fredrik Edström
In the styles part of the xlsx file there is a cellXfs collection which contains xf elements. Each xf element has a numFmtId attribute which has to refer to an entry in the numFmts collection. Some libraries produce files with numFmtId's which are not valid but Excel handles such situations. SpreadProcessing throws KeyNotFoundException on import.
Unplanned
Last Updated: 05 Jan 2023 13:49 by Eljay

When a worksheet contains a cell with longer text, which is right aligned and this text happens to be in the last column of the page, the worksheet is incorrectly split into pages and the last column gets transferred on the next page.

Workaround: Set explicitly the print area you would like to print.

worksheet.WorksheetPageSetup.PrintArea.SetPrintArea(new CellRange(0, 0, 38, 14));

In Development
Last Updated: 04 Jan 2023 09:45 by ADMIN
When a file with a format string of the type "\m\:0.#;\m\:0.#;\m\:0.#;\m\:\ @" is imported, argument exception is thrown.
Unplanned
Last Updated: 30 Dec 2022 10:11 by ADMIN
The named ranges need to be translated when used in a certain cell just like the data validation rules.

WORKAROUND: When you use RowSelection.Insert() method, for instance, after the row insertion you may iterate all defined names in the document. Parse their RefersTo property and if it is affected by the insertion, delete and recreate the DefinedName in the corresponding NameCollection by updating the RefersTo text value. Sample code for parsing the RefersTo property may be seen in the description of this feedback item: 

https://feedback.telerik.com/Project/184/Feedback/Details/190061-spreadprocessing-add-api-to-get-the-list-of-ranges-to-which-a-defined-name-refer
Completed
Last Updated: 29 Dec 2022 14:38 by ADMIN
Release R1 2023
If Spreadsheet's history is not enabled, merged cells cannot be unmerged. 

Workaround: Enable the History before calling Unmerge():

workbook.History.IsEnabled = true;
worksheet.Cells[0, 0, 0, 4].Unmerge();
workbook.History.IsEnabled = false;
Unplanned
Last Updated: 29 Dec 2022 07:04 by ADMIN
ADMIN
Created by: Deyan
Comments: 12
Category: SpreadProcessing
Type: Feature Request
21
Allow to password-protect a workbook, so that it cannot be shown (read) without the password.
Unplanned
Last Updated: 28 Dec 2022 14:19 by David
Images don't move with cells when a row/column is inserted.
Unplanned
Last Updated: 22 Dec 2022 09:58 by Kheng Aik

LayoutHelper is not calculating Height properly in net standard.

Workaround: use SpreadFixedTextMeasurer

Completed
Last Updated: 16 Dec 2022 12:49 by R. J.
Release R3 2020
ADMIN
Created by: Deyan
Comments: 11
Category: SpreadProcessing
Type: Feature Request
12
Implement functionality to rotate the content of a cell.
Unplanned
Last Updated: 09 Dec 2022 11:26 by Dimitar
Created by: Dimitar
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
Introduce calculation chain functionality. This will provide a better mechanism for handling dependent expressions.
Unplanned
Last Updated: 08 Dec 2022 09:53 by Joe
XlsFormatProvider: LeftoverDataException when importing a specific document. 'Initialisation of record 0x55(DefaultColWidthRecord) left 2 bytes remaining still to be read.'
Unplanned
Last Updated: 07 Dec 2022 10:50 by n/a
Memory leaks when importing large documents with formulas consecutively. So weak events still remain in the memory. 
Unplanned
Last Updated: 28 Nov 2022 06:34 by Ralf

 Provide the following options for the image:

  • Move and size with cells
  • Move but don't size with the cells
  • Don't move or size with the cells
1 2 3 4 5 6