Unplanned
Last Updated: 11 Aug 2022 10:20 by Owen
In Excel, this is done by setting this option on the format cells dialog, the protection tab. It allows you to hide the formula when the sheet is protected. 
Unplanned
Last Updated: 02 Aug 2022 09:12 by Henrik
Created by: Henrik
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
When inserting many values and formulas in a worksheet, it would be useful for the users to have the ability to delay the recalculation for better performance.
Unplanned
Last Updated: 01 Aug 2022 12:40 by Chris
ADMIN
Created by: Deyan
Comments: 10
Category: SpreadProcessing
Type: Feature Request
16
At this point, the formatting can be applied only to the whole cell content.
Completed
Last Updated: 08 Jul 2022 13:16 by ADMIN
Release R3 2022
Include the view property in the model in order to not be lost during import and export. The possible values for this property are normal, pageBreakPreview, and pageLayout.
Example:
<sheetViews>
    <sheetView tabSelected="1" view="pageBreakPreview" zoomScaleNormal="100" zoomScaleSheetLayoutView="100" workbookViewId="0">
        <selection activeCell="J5" sqref="J5"/>
    </sheetView>
</sheetViews>

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: 05 Jul 2022 06:15 by ADMIN
Release R2 2022
ADMIN
Created by: Deyan
Comments: 20
Category: SpreadProcessing
Type: Feature Request
32
Provide ability for working with comments in a spreadsheet document.

In Office 365 there are two types of comments:

  1. Comments/Notes
  2. Threaded Comments 

This item applies to Threaded Comments only.

For Notes, please follow: SpreadProcessing: Provide API for Insert / Delete Comments (Notes)

Unplanned
Last Updated: 14 Jun 2022 19:29 by Luca

When a chart is created with RadSpreadProcessing, by default it is exported with legend showing category list. If an xlsx file with a chart with legend showing only series is imported and exported, it will be changed to category list as well. API to switch between the two should be added.

Legend showing category list:

Legend showing series:

Unplanned
Last Updated: 13 Jun 2022 08:01 by IGK
Created by: IGK
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
For cell values like 0001 stored as text, excel will show the error checking options as a green ribbon in the top left corner of the cell. If we click on Ignore Error, the green color ribbon on Top-Left side of the cell will go away. Add support for this to be preserved in the document.
Unplanned
Last Updated: 10 Jun 2022 06:02 by IGK
Created by: IGK
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0

With the current implementation, the Notes support only a rectangular shape.

Examples:

In Development
Last Updated: 31 May 2022 08:33 by ADMIN
ADMIN
Created by: Deyan
Comments: 16
Category: SpreadProcessing
Type: Feature Request
46
If a worksheet spans more than one page, you can print row and column headings or labels (also called print titles) on every page to ensure that the data is properly labeled.
Unplanned
Last Updated: 26 May 2022 08:50 by ADMIN
ADMIN
Created by: Deyan
Comments: 10
Category: SpreadProcessing
Type: Feature Request
19
Allow to password-protect a workbook, so that it cannot be shown (read) without the password.
Unplanned
Last Updated: 23 May 2022 13:16 by Tino
Implement NewLine property in the CsvSettings class.
Unplanned
Last Updated: 03 May 2022 11:44 by ADMIN
ADMIN
Created by: Tanya
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
Currently, indexed colors are imported only regarding the default color palette. Instead, when the entire palette is predefined using a construct like: 

  <colors>
    <indexedColors>
      <rgbColor rgb="00000000"/>
      ...

in styles.xml part, the indexed should be changed with the provided ones. As this feature is not implemented, such colors are changed during the import.
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.
Unplanned
Last Updated: 05 Apr 2022 09:38 by Monique
Created by: Monique
Comments: 0
Category: SpreadProcessing
Type: Feature Request
2
Introduce support for the WEEKDAY function.
Unplanned
Last Updated: 05 Apr 2022 07:08 by ADMIN
Created by: Divya
Comments: 2
Category: SpreadProcessing
Type: Feature Request
0
A feature in Excel allows adding ActiveX controls in the Worksheets. You can insert the ActiveX controls from the Developer ribbon tab from the insert button. As it is a missing feature it is not imported and thus removed from the document on export.
Completed
Last Updated: 04 Apr 2022 07:41 by ADMIN
Release LIB 2022.1.411 (11 Apr 2022)
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. 
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: 17 Feb 2022 15:22 by ADMIN
Release R1 2022 SP1
Provide API for converting cell range name to CellRange.
1 2 3 4 5 6