Unplanned
Last Updated: 18 Aug 2022 14:08 by Daniel
Created by: Daniel
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
Add support for the  CELL formula.
Unplanned
Last Updated: 18 Aug 2022 12:45 by Daniel
SpreadProcessing: XlsFormatProvider. Exception when importing a specific document - bad function index (188)
Completed
Last Updated: 16 Aug 2022 12:18 by ADMIN
Release LIB 2022.2.822 (22 Aug 2022)
The pie chart is not rendered correctly and is not converted to pdf as expected.
Completed
Last Updated: 16 Aug 2022 07:12 by ADMIN
Release R3 2022
When a file makes use of differential formats an Index out of range error may be thrown on import.
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. 
Completed
Last Updated: 02 Aug 2022 15:26 by ADMIN
Release R3 2022
Wrong UsedCellRange when the worksheet contains a DataValidation rule.
Unplanned
Last Updated: 02 Aug 2022 09:12 by Henrik
Created by: Henrik
Comments: 0
Category: SpreadProcessing
Type: Feature Request
2
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.
Completed
Last Updated: 01 Aug 2022 13:53 by ADMIN
Release R3 2022
Changing the sheet name with a string that needs to be escaped results in an invalid file due to missing escaping in the RefersTo value.
Unplanned
Last Updated: 21 Jul 2022 12:11 by Guilhem
Comparing PDF documents exported by MS Excel and by SpreadProcessing shows slightly different sizes of the cells.
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)

Completed
Last Updated: 28 Jun 2022 13:16 by ADMIN
Release R3 2022
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.
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 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: 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.

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: 23 May 2022 13:16 by Tino
Implement NewLine property in the CsvSettings class.