Hello,
we would like to have the capability to create a chart in excel export using Telerik.Documents.Spreadsheet
Marcos
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.
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));
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
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;
Allow to password-protect a workbook, so that it cannot be shown (read) without the password.
LayoutHelper is not calculating Height properly in net standard.
Workaround: use SpreadFixedTextMeasurer
Implement functionality to rotate the content of a cell.
Provide the following options for the image: