In Development
Last Updated: 24 Jun 2022 13:59 by ADMIN
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>

In Development
Last Updated: 24 Jun 2022 13:58 by ADMIN

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);
}

In Development
Last Updated: 16 Jun 2022 11:19 by ADMIN
When an xls file with a large, but still valid column width is imported, an ArgumentException is thrown: "The maximum column width for an individual cell is 255 characters." 
Unplanned
Last Updated: 15 Jun 2022 14:02 by Leigh
Invoking AutoFitWidth/AutoFitHeight in Blazor WASM takes too long time even for small documents.
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:

Completed
Last Updated: 13 Jun 2022 08:48 by ADMIN
Release R2 2022 SP1
When a file is imported that has an unsupported theme color type, the resulting ThemableColor is null. This results in a NullReferenceException on export.
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 10:00 by Mandip Kaila
Opening a file where there is a format string with modificator [Color11] causes an ArgumentException "Invalid modificator" This prevents the file from opening.
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:

Unplanned
Last Updated: 06 Jun 2022 09:31 by Patrick

For example:
Renaming a sheet named "Sheet1" to "Sheet 1", should update formulas references to it to 'Sheet 1!' (notice single quotes), which it does not. The formula =SUM(Sheet1!A2:C2) changes to the invalid expression =SUM(Sheet 1!A2:C2). This breaks formulas referencing that sheet.

Workaround:
Iterate all cells with formulas in the workbook and add single quotes to the beginning and end of sheet name reference. The attached project changes the name of Sheet1 and then fixes all formula references to it by enclosing its name in single quotes.

Unplanned
Last Updated: 03 Jun 2022 19:38 by ADMIN
If a cell has a style set (e.g. Bad) and no fill set on the same cell, after import and export, the no fill setting will be lost and the cell will be shown with its cell style instead.

In Development
Last Updated: 31 May 2022 08:33 by ADMIN
ADMIN
Created by: Deyan
Comments: 16
Category: SpreadProcessing
Type: Feature Request
45
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.
Completed
Last Updated: 26 May 2022 13:15 by ADMIN
Release R2 2022 SP1

SpreadProcessing: Upon export, sheet reference in formulas such as VLOOKUP is lost when using whole row/column references.
For example the formula
=VLOOKUP("test",Sheet1!A:C,1,0) is exported as

=VLOOKUP("test",A:C,1,0)

Unplanned
Last Updated: 26 May 2022 10:00 by ADMIN
ADMIN
Created by: Deyan
Comments: 9
Category: SpreadProcessing
Type: Feature Request
16
At this point, the formatting can be applied only to the whole cell content.
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: 19 May 2022 12:32 by Rik

The values applied to the row/column should be explicitly set on each used cell as well. Otherwise, if they are applied on row/column only, the used cells don't use the desired values when opening the document.

To reproduce:

  1. Set some content on cell A1
  2. Create a row selection and apply a fill color to it (or any other property)
  3. Export the document and open it in an application

Observed: All cells except A1 have the specified color.

Workaround: Use cell selection, e.g.:

sheet.Cells[0,10].SetFill(PatternFill.CreateSolidFill(Colors.Red));

Unplanned
Last Updated: 06 May 2022 04:25 by IGK
Add API that allows one to manipulate the macros inside a Workbook.
Unplanned
Last Updated: 04 May 2022 08:38 by Dimitar
Chart not visible when file has OneCellAnchor xaml element.
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.
1 2 3 4 5 6