Completed
Last Updated: 09 Jun 2017 08:15 by ADMIN
ADMIN
Created by: Deyan
Comments: 3
Category: SpreadProcessing
Type: Feature Request
2

			
Unplanned
Last Updated: 05 Oct 2016 07:04 by ADMIN
If shape extent is declared, the two cell anchor points for the drawing element are ignored. For example if the TwoCellAnchorElement's from and two points declare that the image should be anchored starting from cell A1to F10 and further in the drawing declaration there is defined extents element with image size values, anchor element's points are ignored. 
Unplanned
Last Updated: 30 Apr 2018 13:59 by ADMIN
ADMIN
Created by: Tanya
Comments: 0
Category: SpreadProcessing
Type: Feature Request
2
Add support for TEXT function. The TEXT function allows changing the way a number appears by applying formatting to it using format codes.

TEXT(value, format_text)

A list of the supported functions is available at http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/functions 

This function can be implemented as a custom function. Check the following resources for more details on how to achieve that:

- http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/custom-functions 
- https://github.com/telerik/xaml-sdk/tree/master/Spreadsheet/WPF/CustomFunctions 
Unplanned
Last Updated: 05 Apr 2018 14:21 by ADMIN
The r attribute of a cell defines the reference the cell is pointing to in a style similar to A1. Setting this attribute is optional but when set to an empty string, it cannot be imported - an ArgumentException is thrown with message "cellName" by the Guard class in NameConverter.ConvertCellNameToIndex().

Here is an example of such a definition:

<row r="1" spans="1:12">
  <c r=""/>
</row>


MS Excel and Libre Office can open such documents.
Unplanned
Last Updated: 21 Aug 2018 10:56 by ADMIN
Having cell with custom format string set to "MMM" does not apply correctly. Instead of showing the date in the defined format (for instance "Aug"), what actually is displayed is "MMM".
Unplanned
Last Updated: 07 Sep 2018 14:07 by ADMIN
ADMIN
Created by: Anna
Comments: 0
Category: SpreadProcessing
Type: Feature Request
2
The OFFSET function returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. 
Unplanned
Last Updated: 30 Aug 2018 08:04 by ADMIN
When a worksheet has name that has spaces and a hyperlink to this worksheet is being inserted in Excel, quotes are used to surround the name (ex: 'Sheet 12'!A1) for a valid hyperlink. If quotes are not added, the hyperlink is invalid.
In RadSpreadsheet, it is the opposite: (Sheet 12!A1 is correct, while 'Sheet 12'!A1 is incorrect).
Thus, opening such an exported document from RadSpreadsheet in Excel loads it with incorrect hyperlinks; and importing such an Excel document in RadSpreadsheet loads it with incorrect hyperlinks.

A way to workaround this issue is to modify the hyperlinks on import/export from/to RadSpreadsheet. You can find attached a project demonstrating this approach.
Unplanned
Last Updated: 05 Sep 2018 14:44 by ADMIN
When the scale factor of a document is smaller, the borders don't seem to scale correctly when exported to PDF. They appear much thicker than they would when exported from Excel.
Unplanned
Last Updated: 21 Sep 2018 13:02 by ADMIN
When inserting cells a check is performed for data loss. This check should take into account the value property, but should not take into account properties like cell value format and data validation. 

Workaround: clear the values at the end of the worksheet before inserting cells.
worksheet.Cells[1048575, 0, 1048575, 16383].ClearDataValidationRule();
Unplanned
Last Updated: 19 Feb 2019 13:34 by ADMIN
Add support for Point Markes customization options for the Charts.
Unplanned
Last Updated: 10 Apr 2019 14:35 by ADMIN
Exporting empty workbook without any worksheet is not allowed according to the specification and such documents cannot be opened in Excel. Ensure the customers cannot create such documents using the API of SpreadProcessing.
Unplanned
Last Updated: 14 Aug 2019 08:07 by ADMIN
Currently, row/column groups cannot be collapsed/expanded through the public API. User should be able to specify row's/column's "collapsed" attribute indicating whether the outlining is in a collapsed state.
Unplanned
Last Updated: 23 Sep 2019 11:01 by ADMIN
Currently, the worksheet of the shape and the collection it belongs to should be the same. Make it possible for the ChartShape and the data source to be on different worksheets.
Unplanned
Last Updated: 31 Jul 2023 10:53 by ADMIN
Adding a formula with the SetValueAsFormula method is slow
Unplanned
Last Updated: 30 Mar 2020 07:04 by ADMIN
Created by: Rudá Cunha
Comments: 0
Category: SpreadProcessing
Type: Feature Request
2

Currently, this could be achieved by exporting the document to PDF and then by using RadPdfViewer's WPF control ThumbnailFactory class. Sample code may be seen at this forum post: http://www.telerik.com/forums/pdf-thumbnail-returns-transparent-images#jO33X-E8Cki_qLh_KsToWg Help article: WPF PdfViewer - Exporting Fixed Page to Image - Telerik UI for WPF

Note: Allow also exporting part of the sheet to an image (print area, or selected cells), allowing for crop to content of the image.

Update: As of R3 2022 RadPdfProcessing has a SkiaImageFormatProvider available only for .NET Standard, which can be used instead of ThumbnailFactory. The help article can be found here: PdfProcessing - Using SkiaImageFormatProvider - Telerik Document Processing
Unplanned
Last Updated: 03 Aug 2022 06:36 by ADMIN
When a row or column is inserted in a worksheet that has cells referred from another worksheet, the formula should be updated so it refers to the same values as before the insertion or removal of cells.
Completed
Last Updated: 22 Jun 2020 14:39 by ADMIN
Release R3 2020
Currently, the calculation of the actual ScaleFactor is based only on Worksheet`s UsedCellRange.
Unplanned
Last Updated: 13 Jul 2020 12:20 by ADMIN
According to the Open XML documentation, the possible max value for this attribute is an unsignedInt or 4294967295.
Unplanned
Last Updated: 04 Sep 2020 06:04 by ADMIN
Exporting a sheet in a workbook, results in clearly narrower column widths, this doesn't appear to be a scaling issue as letters that extend outside of a cell are occluded differently from the Excel document. Also worth noting, borders adjacent to the margin area are clipped (not an issue when exporting the same PDF from excel), text padding in the cell is not the same as the Excel document, and borders disappear unexpectedly on some text cells 
Unplanned
Last Updated: 07 Jun 2021 09:35 by ADMIN
Created by: N
Comments: 0
Category: SpreadProcessing
Type: Feature Request
2
The Open Document Format for Office Applications (ODF), also known as OpenDocument, is an open standard file format for spreadsheets, charts, presentations, and word processing documents using ZIP-compressed[6] XML files.

The most common filename extension for spreadsheets is .ods.