Approved
Last Updated: 17 Jan 2020 14:10 by ADMIN
Created by: Martin
Comments: 0
Category: SpreadProcessing
Type: Bug Report
0
Wrong measured column width when exporting to PDF after binaries version 2019.2.624.
Approved
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
Approved
Last Updated: 03 Dec 2019 11:18 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. 
Approved
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).
Approved
Last Updated: 22 Nov 2019 11:13 by ADMIN
Expose an easy way to create .xlsx documents from DataTable objects.
Approved
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.
Approved
Last Updated: 11 Nov 2019 14:41 by ADMIN
ADMIN
Created by: Deyan
Comments: 6
Category: SpreadProcessing
Type: Feature Request
15
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.
Approved
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.

Approved
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.
Approved
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.
Approved
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.
Approved
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.
Approved
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.
Approved
Last Updated: 28 Jun 2019 11:06 by ADMIN
Currently, the chart lines support only solid fill for their outlines.
Approved
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.
Approved
Last Updated: 18 Jun 2019 08:40 by ADMIN
Created by: olivier legaignoux
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
The COUNTIFS function returns the count of cells that meet one or more criteria.
Completed
Last Updated: 11 Jun 2019 12:46 by ADMIN
Release R2 2019 SP1
The data validation rule should have values for formula1 and formula2 elements, which define the start and end values for a range to validate between. When such values are missing, a NullReferenceException is thrown on import and the document cannot be imported.

Details:

System.NullReferenceException: Object reference not set to an instance of an object.
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Model.Elements.Worksheets.DataValidationElement.CopyPropertiesToSingleArgumentContext(SingleArgumentDataValidationRuleContext context)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Model.Elements.Worksheets.DataValidationElement.CopyPropertiesToDataValidationRuleContext(DataValidationRuleContextBase context)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Model.Elements.Worksheets.DataValidationElement.ListRuleFactory(IXlsxWorksheetImportContext context)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Model.Elements.Worksheets.DataValidationElement.OnAfterRead(IXlsxWorksheetImportContext context)
...
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.WorkbookFormatProviderBase.Import(Stream input)
1 2 3 4 5 6