Completed
Last Updated: 07 Jul 2022 14:00 by ADMIN
Release R3 2022

Currently, similar conversions should be manually implemented by the users.

Sample method that could be used:

public static Color HexStringToColor(string hexColor)
{
    // Remove the # at the front.
    if (hexColor.StartsWith("#"))
    {
        hexColor = hexColor.Substring(1, hexColor.Length - 1);
    }

    byte a = 255;
    byte r = 255;
    byte g = 255;
    byte b = 255;

    int start = 0;

    // Handle ARGB strings (8 characters long).
    if (hexColor.Length == 8)
    {
        start = 2;
    }

    //Handle contracted RGB strings (3 characters long)
    if (hexColor.Length == 3)
    {
        hexColor = string.Format("{0}{0}{1}{1}{2}{2}", hexColor[0], hexColor[1], hexColor[2]);
    }
    else if (hexColor.Length < 6)
    {
        hexColor = hexColor.PadLeft(6, '0');
    }

    // Convert RGB characters to bytes.
    r = byte.Parse(hexColor.Substring(start, 2), NumberStyles.HexNumber);
    g = byte.Parse(hexColor.Substring(start + 2, 2), NumberStyles.HexNumber);
    b = byte.Parse(hexColor.Substring(start + 4, 2), NumberStyles.HexNumber);

    return Color.FromArgb(a, r, g, b);
}

Completed
Last Updated: 16 Mar 2022 13:51 by ADMIN
Release R2 2022
Created by: Nicholas
Comments: 1
Category: SpreadProcessing
Type: Feature Request
1
In newer versions of EXCEL (2019 and later) the CONCAT function is introduced as a replacement of the old CONCATENATE function. It adds the ability to specify a range of cells when generating the resulting string in addition to its previously supported input arguments.
NOTE: In EXCEL starting from version 2019, CONCATENATE can no longer be inserted in the worksheet through the UI, it can only be used if you type it directly in the cell's contents.
Completed
Last Updated: 16 Mar 2022 07:45 by ADMIN
Release R2 2022
When importing a document with an unclosed <br> element in the vmlDrawing part an exception is thrown: System.Xml.XmlException: 'The 'br' start tag on line 183 position 14 does not match the end tag of 'font'. Line 184, position 7.'

Completed
Last Updated: 18 Apr 2022 14:08 by ADMIN
Release R2 2022
DataTableFormatProvider: One should be able to set the AllowDBNull property of each column.
Completed
Last Updated: 17 Feb 2022 15:22 by ADMIN
Release R1 2022 SP1
Provide API for converting cell range name to CellRange.
Completed
Last Updated: 22 Nov 2021 15:36 by ADMIN
Release R1 2022
An exception is thrown when importing a document containing custom number formats with date or time part and empty sections.
Completed
Last Updated: 20 Jan 2022 08:18 by ADMIN
Release R1 2022
Created by: Martin
Comments: 0
Category: SpreadProcessing
Type: Feature Request
3

From the OOXML Specification: A comment is a rich-text note that is attached to and associated with a cell, separate from other cell content.

In Office 365 there are two types of comments:

This item applies to Comments/Notes only.

For Threaded Comments, please follow: SpreadProcessing: Comments (Threaded Comments)

Completed
Last Updated: 20 Jul 2021 15:00 by ADMIN
Release LIB 2021.2.712 (12 Jul 2021)
Created by: Robby
Comments: 3
Category: SpreadProcessing
Type: Feature Request
0
Make it possible to change the series fill color.
Completed
Last Updated: 24 Jun 2021 10:08 by ADMIN
Release R3 2021
Created by: Christophe
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
Add support for exporting Markup-Enabled file format to PDF.
Completed
Last Updated: 18 Feb 2021 14:38 by ADMIN
Release R1 2021 SP1
Provide an API that can be used to change the culture used by the library. This way a culture different from the current thread culture can be used.
Completed
Last Updated: 10 Nov 2020 11:20 by ADMIN
Release R1 2021
Exception when importing a file with missing print settings
Completed
Last Updated: 03 Jul 2020 09:55 by ADMIN
Release R3 2020
Created by: Luke
Comments: 1
Category: SpreadProcessing
Type: Feature Request
0
When importing a spreadsheet document whose cells use a style that is not defined in the document stylesheet, a KeyNotFoundException is thrown. The style can be just skipped so that the document can be imported without errors.
Completed
Last Updated: 05 Jul 2023 09:00 by ADMIN
Release R2 2023
Created by: Marcos Mataloni
Comments: 17
Category: SpreadProcessing
Type: Feature Request
19

Hello,

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

Marcos

Completed
Last Updated: 10 Jun 2020 12:41 by ADMIN
Release R2 2020 SP1
Implement text orientation for cell content import/export from/to XLSX format
Completed
Last Updated: 01 Sep 2021 12:14 by ADMIN
Release R2 2021
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.
Completed
Last Updated: 29 Aug 2017 08:32 by ADMIN
ADMIN
Created by: Tanya
Comments: 0
Category: SpreadProcessing
Type: Feature Request
3
The MATCH function searches for a specified item in a range of cells and returns the relative position of the item found in this range.

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/CustomFunctions

Available in R3 2017 Official Release Version
Completed
Last Updated: 18 Apr 2017 10:42 by ADMIN
ADMIN
Created by: Tanya
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
Add support for CHOOSE function. CHOOSE uses the number parameter to return a value from the list of value arguments. 

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/CustomFunctions

Available in R2 2017 Official Release.
Completed
Last Updated: 18 Apr 2017 10:33 by ADMIN
ADMIN
Created by: Tanya
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
Add support for TRIM function. TRIM removes all spaces from text except for single spaces between words.

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/CustomFunctions

Available in R2 2017 Official Release.
Completed
Last Updated: 24 Jun 2021 14:53 by Vili
Release R3 2021
ADMIN
Created by: Nikolay Demirev
Comments: 16
Category: SpreadProcessing
Type: Feature Request
22
Add support for preserving and exporting the macros in a macro-enabled workbook.

Macros are pieces of code written in Visual Basic for Applications (VBA) which are used to automate repetitive tasks in excel. The macros are part of the excel file. When a file contains a macro its extension becomes xlsm.

SpreadProcessing should be able to import and export xlsm files and edit the macros in them.
Completed
Last Updated: 17 Aug 2018 06:27 by Tim
ADMIN
Created by: Tanya
Comments: 7
Category: SpreadProcessing
Type: Feature Request
20
This will enable printing with the following printing options: 

- Fit Sheet on One Page

- Fit All Columns on One Page

- Fit All Rows on One Page

- Custom automatic scaling


A possible implementation of a similar behavior is to use the PageSize property of WorksheetPageSetup and subtract the corresponding margin values (from the Margins property) from the width to calculate how many columns are fitting in some particular page size with 100% scale factor. 

Available in R2 2018 Official Release version.
1 2