Unplanned
Last Updated: 20 Feb 2020 11:53 by ADMIN
SpreadProcessing: The colors of the chart are not imported correctly.
Unplanned
Last Updated: 20 Feb 2020 11:40 by ADMIN
The columns of the sheet are split when exporting to PDF.
Declined
Last Updated: 05 Feb 2020 15:30 by ADMIN
Created by: Martin
Comments: 2
Category: SpreadProcessing
Type: Bug Report
0
Wrong measured column width when exporting to PDF after binaries version 2019.2.624.
Unplanned
Last Updated: 31 Jan 2020 14:17 by ADMIN
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. 
Unplanned
Last Updated: 27 Dec 2019 06:38 by ADMIN
Created by: Dimitar
Comments: 2
Category: SpreadProcessing
Type: Feature Request
0
One should be able to set the axis titles in the code. The attached images show an example of the exported document opened in Excel. 
Completed
Last Updated: 13 Dec 2019 10:55 by ADMIN
Release R1 2020
ADMIN
Created by: Deyan
Comments: 1
Category: SpreadProcessing
Type: Feature Request
2
Add support for MID function. MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.

MID(text, start_num, num_chars)

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: 26 Nov 2019 11:30 by ADMIN
Created by: Dimitar
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
Add support for the Data Labels in the chart (see attached).
Unplanned
Last Updated: 22 Nov 2019 11:13 by ADMIN
Expose an easy way to create .xlsx documents from DataTable objects.
Unplanned
Last Updated: 22 Nov 2019 09:30 by ADMIN
When a csv is exported the entire range which has values is exported. When export is done in Excel, the cells of this range which are empty are marked by an additional field, separated by a comma. This comma is present in SpreadProcessing only in places where it is obligatory for example in the middle of the row. Obligatory comma in this context means that without it the file will not be read correctly by Excel or SpreadProcessing. In places where it is not obligatory, like in an empty row or in the end of the row, it is skipped. These non-obligatory commas do not influence how the file will be interpreted by Excel, however, according to the most-popular csv spec, they should be present, which means that there could be parsers which are unable to parse the resulting file. (2.4 Each line should contain the same number of fields throughout the file.) 

Example:
Exported by Excel:
---------------------------------------
Product,Unit Price,Units in Stock,Discontinued
Chai,$18.00 ,39,
Chang,,17,
Chef Anton's Cajun Seasoning,$22.00 ,53,No
,,,
Chef Anton's Gumbo Mix,$21.35 ,0,No
---------------------------------------
Exported by SpreadProcessing:
---------------------------------------
Product,Unit Price,Units in Stock,Discontinued
Chai,$18.00 ,39
Chang,,17
Chef Anton's Cajun Seasoning,$22.00 ,53,No

Chef Anton's Gumbo Mix,$21.35 ,0,No
---------------------------------------
Note the extra commas in the empty row and in the end of the first two rows in the SpreadProcessing sample.
Unplanned
Last Updated: 11 Nov 2019 14:41 by ADMIN
ADMIN
Created by: Deyan
Comments: 6
Category: SpreadProcessing
Type: Feature Request
16
Add support for conditional formatting of cells - allow applying of rules used during visualization of cells to automatically apply formatting depending on their values.
Completed
Last Updated: 05 Nov 2019 14:58 by ADMIN
Release LIB 2019.3.1111 (11/11/2019)
The exception is thrown when importing a document that contains a not supported BuiltInNumberFormat.
Completed
Last Updated: 16 Oct 2019 12:50 by ADMIN
Release R3 2019 SP1
While importing the arguments of the data validation rule, the formula is treated as text and its separators are replaced with the list separator defined in the current culture. This leads to an invalid formula treated as a list of strings.
Unplanned
Last Updated: 02 Oct 2019 12:37 by ADMIN
Created by: shashidhar
Comments: 0
Category: SpreadProcessing
Type: Bug Report
1

Filter Selection dialog appears on the screen. 

Workaround: Open the file with Excel and save it as a new document.

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: 10 Sep 2019 08:08 by ADMIN
Created by: Julian Turner
Comments: 1
Category: SpreadProcessing
Type: Feature Request
1
RadSpreadsheetProcessing does not support chart color customization apart from selecting the color of the outline (set by Series.Outline.Fill). You cannot set the color of the fill of column charts etc.
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: 12 Aug 2019 12:06 by ADMIN
ADMIN
Created by: Deyan
Comments: 6
Category: SpreadProcessing
Type: Feature Request
10
Allow to password-protect a workbook, so that it cannot be shown (read) without the password.
Unplanned
Last Updated: 06 Aug 2019 12:51 by ADMIN
Created by: Brittany
Comments: 0
Category: SpreadProcessing
Type: Bug Report
3
It takes ~42 seconds to remove each 100th row from a document with 50000 rows and 100 columns.
Unplanned
Last Updated: 28 Jun 2019 11:06 by ADMIN
Currently, the chart lines support only solid fill for their outlines.
Unplanned
Last Updated: 28 Jun 2019 10:07 by ADMIN
The API should be able to provide a way to move the X-axis away from the 0 value on the Y-axis or to the bottom of the chart when there are negative Y-axis values.

In Excel this can be achieved by right click on the axis, then from the context menu select "Format Axis".  Go to the "Labels" group and then in the "Label position" field select the desired value.
1 2 3 4 5 6