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.
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." 
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: 24 Jan 2023 10:29 by ADMIN
Release R3 2022 SP1
Text is cut off in Net Standard with a specific document.
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.
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: 18 Aug 2022 12:45 by Daniel
SpreadProcessing: XlsFormatProvider. Exception when importing a specific document - bad function index (188)
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 14:10 by Daniel
 A long formula is wrongly parsed when importing a particular file.
Unplanned
Last Updated: 24 Aug 2022 10:50 by Christopher
Created by: Christopher
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1

Currently, the following text filters are not supported in the model:

  • begins with
  • does not begin with
  • ends with
  • does not end with
  • contains
  • does not contain
Completed
Last Updated: 06 Sep 2022 07:12 by ADMIN
Release R3 2022
Exception when the comments are imported before the fallback notes.
Completed
Last Updated: 15 May 2023 07:03 by ADMIN
Release R1 2023
Wrong color scheme colors leads to wrong cell coloring on export.
Completed
Last Updated: 21 Feb 2023 14:27 by Ivan
Release R1 2023 SP1
InvalidCastException on import when a drawing in a document contains the "ext" tag 
Unplanned
Last Updated: 01 Nov 2022 12:25 by Dennis
Inserting new rows above rows containing hyperlinks breaks the hyperlinks.
Unplanned
Last Updated: 07 Nov 2022 13:15 by Fabrice
The XlsxFormatProvider could throw FormatException: 'Input string was not in a correct format.' while parsing a color definition. Suppress such errors so that the document can be imported and use default values for the colors.
Unplanned
Last Updated: 31 Oct 2023 15:52 by ADMIN
When a cell contains a lot of empty lines the last line is not rendered correctly.
Unplanned
Last Updated: 28 Dec 2022 14:19 by David
Images don't move with cells when a row/column is inserted.
Completed
Last Updated: 02 Feb 2023 08:40 by ADMIN
Release LIB 2023.1.206 (6 Feb 2023)
When a file with a format string of the type "\m\:0.#;\m\:0.#;\m\:0.#;\m\:\ @" is imported, argument exception is thrown.
Completed
Last Updated: 18 May 2023 07:54 by ADMIN
Release R2 2023
Completed
Last Updated: 04 Jul 2023 12:11 by ADMIN
Release R2 2023 SP1
If the column has a text format set and has a mixture of text and numbers, the numbers should be exported as text as well.