Unplanned
Last Updated: 18 Oct 2022 06:45 by Blas

SpreadProcessing: InvalidOperationException when opening an XLS document with a named range that refers to a formula. The message is "Only applicable to named ranges". Opened correctly in Excel. 

 

Unplanned
Last Updated: 14 Oct 2022 11:53 by Carlos

Parsing a document that contains a cell with wrapped multiline text and its row doesn't define a value for height, results in wrong row height when rendering or exporting to PDF.

Workaround: Fit the height of the row when it contains wrapped cells:

 

Worksheet worksheet = workbook.ActiveWorksheet;
CellRange wrappedCells = worksheet.GetUsedCellRange(CellPropertyDefinitions.IsWrappedProperty);

for (int i = wrappedCells.FromIndex.RowIndex; i < wrappedCells.ToIndex.RowIndex; i++)
{
    worksheet.Rows[i].AutoFitHeight();
}

 

Completed
Last Updated: 19 Jan 2023 14:56 by ADMIN
Release R1 2023
The relationship ID is needed to parse the hyperlink target and is mandatory by the specification. However, XlsxFormatProvider throws an exception while reading that hyperlink and cannot open the document.
Completed
Last Updated: 15 May 2023 07:03 by ADMIN
Release R1 2023
Wrong color scheme colors leads to wrong cell coloring on export.
Unplanned
Last Updated: 12 Sep 2022 10:56 by Bill
Currently, the only way to set a culture for the SpreadProcessing is through the static property FormatHelper.CultureHelper. That way the value is shared between all instances of the SpreadProcessing. There has to be an API allowing to set different cultures for the different instances of the SpreadProcessing.
Completed
Last Updated: 06 Sep 2022 07:12 by ADMIN
Release R3 2022
Exception when the comments are imported before the fallback notes.
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
Unplanned
Last Updated: 18 Aug 2022 14:10 by Daniel
 A long formula is wrongly parsed when importing a particular file.
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)
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: 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: 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.
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: 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.
Completed
Last Updated: 28 Apr 2023 13:45 by ADMIN
SpreadProcessing: Copying a cell with a LessThan conditional formatting rule throws a Null reference exception
Completed
Last Updated: 02 Aug 2022 15:26 by ADMIN
Release R3 2022
Wrong UsedCellRange when the worksheet contains a DataValidation rule.
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.
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: 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."