Completed
Last Updated: 19 Jan 2023 14:56 by ADMIN
Release R1 2023
When creating a SpreadPatternFill instance with SpreadPatternType 'Solid', the PatternColor and BackgroundColor properties have swapped values. The cells with the applied fill have a background with the color of the BackgorundColor property instead of the color of PatternColor.

Workaround: Swap values when setting the properties.
Unplanned
Last Updated: 10 Jan 2023 11:51 by ADMIN
Files exported with SpreadStreamProcessing cannot be read by OleDB consumers
Completed
Last Updated: 30 Mar 2017 14:21 by ADMIN
When a cell value contains commas or new lines, they are not escaped on export to CSV and single value is exported as multiple values.

Workaround: Escape the value manually. For example, use the following extension method to set string cell values:
internal static class CellExporterExtensions
{
    public static void SetValue(this ICellExporter cell, string value, SpreadDocumentFormat format)
    {
        if (format == SpreadDocumentFormat.Csv)
        {
            if (value.Contains(","))
            {
                // escape all quotes with double quotes
                value = value.Replace("\"", "\"\"");

            }

            // enclose all values within quotes
            value = string.Format("\"{0}\"", value);
        }

        cell.SetValue(value);
    }
}

Available in LIB version: 2017.1.403
Completed
Last Updated: 13 Dec 2018 15:23 by ADMIN
ArgumentException with clarification similar to  "'\u001f', hexadecimal value 0x1F, is an invalid character." is thrown when trying to export document containing characters which are not supported in XML document - such as some control characters like 0x00, 0x1F, 0x1B, etc. Such characters are described in the XML specification here: https://www.w3.org/TR/xml/#charsets.
Although the escaped strings are not supported (see related 181318), the library could prevent the exception and export the document successfully by skipping such characters.
Workaround: remove such characters before the export. Check the following StackOverflow answer for some ideas on code for replacing the characters: http://stackoverflow.com/a/14323524/259206


Unplanned
Last Updated: 03 Jun 2021 12:27 by ADMIN
Expose API that allows you to get the styles colors from the current theme
Completed
Last Updated: 01 Nov 2021 07:46 by ADMIN
Release R3 2021 SP1
Created by: Joon-Sae
Comments: 1
Category: SpreadStreamProcessing
Type: Bug Report
1
Exception when color does have a complete value.
Completed
Last Updated: 19 Jan 2023 14:56 by ADMIN
Release R3 2022 SP1
When importing a document containing more than one Number Formats (numFmts) with the same format code (formatCode) an exception is thrown: System.InvalidOperationException: 'Same item with different index exists.'

Completed
Last Updated: 19 Jan 2023 14:56 by ADMIN
Release R1 2023
While reading the content, the ReadCellValue method throws NotSupportedException: "The RichText value type is not supported". Although the rich text in the cells is not supported, the library could parse the text content and avoid throwing errors.
Unplanned
Last Updated: 08 Aug 2023 06:50 by Stefan
KeyNotFoundException: 'The given key was not present in the dictionary.' when reading a document,
due to incorrect "fontId" in "cellStyleXfs".
Unplanned
Last Updated: 05 Oct 2016 11:08 by ADMIN
If you want to export a document with modified Normal style, you have to modify it and then set it to at least one cell in order to be exported. This maybe is caused by the fact that if the style is not used it is not exported.

Workaround: Export single cell in the row with this style applied to it:

using (ICellExporter cell = row.CreateCellExporter())
{
    cell.SetFormat(new SpreadCellFormat()
    {
          CellStyle = normalStyle
     });
}
Unplanned
Last Updated: 04 Oct 2016 10:04 by ADMIN
When exporting double values no value type is set to the cell. When a string value is exported the cell value type is set to Text. After setting string value the valueType is set to Text and when setting again value to double the type remains the same.

When exporting double values no value type is set to the cell. When a string value is exported the cell value type is set to Text. After setting string value the valueType is set to Text and when setting again value to double the type remains the same.

Workaround: Just set the value once and do not change it.
Unplanned
Last Updated: 26 Apr 2018 15:29 by ADMIN
When setting a date in a cell using SetValue(DateTime), the value should be converted to its numerical representation before adding it to the XML. However, it is currently written as a string. This causes issues when opening the generated file with Google Sheets - the dates are not visible in the file.

A customer also reported that this is causing issues when the file is opened with MS Excel in specific cultures, but we were unable to reproduce that locally.

Workaround: Convert the DateTime value to a number before setting it to the cell:
cell.SetValue(DateTime.Now.Date.ToOADate());
Declined
Last Updated: 12 Dec 2018 09:21 by ADMIN

ArgumentException with clarification similar to "'\u001f', hexadecimal value 0x1F, is an invalid character." is thrown when trying to export document containing characters which are not supported in XML document - such as some control characters like 0x00, 0x1F, 0x1B, etc.

Such characters are described in the XML specification here: https://www.w3.org/TR/xml/#charsets.


Code to reproduce 
using (var stream = File.OpenWrite("sample.xlsx"))
using (var workbook = SpreadExporter.CreateWorkbookExporter(SpreadDocumentFormat.Xlsx, stream))
using (var worksheet = workbook.CreateWorksheetExporter("My sheet"))
using (var row = worksheet.CreateRowExporter())
using (var cell = row.CreateCellExporter())
{
      cell.SetValue(string.Format("Error Value: {0} ", Encoding.ASCII.GetString(new byte[] { 8 })));
}

Unplanned
Last Updated: 09 Oct 2020 09:27 by ADMIN
Number formats like this: #,##0.0,,;(#.##0.0..) can not be applied, because the trailing commas in the first part of the format "#,##0.0,," are not supported.
Completed
Last Updated: 17 Mar 2021 09:11 by ADMIN
Release R2 2021

When calling SpreadExporter.CreateWorkbookExporter method and referencing Trial assemblies an exception is thrown: System.ArgumentException: 'An item with the same key has already been added.'

This behavior is observed both with the NuGet packages and DLLs.

It is not observed with Trial DLLs version 2020.3.1019

Completed
Last Updated: 26 Jul 2021 07:24 by ADMIN
Release R3 2021
When using the API for measuring the cell content size the results are not correct.
Unplanned
Last Updated: 03 Aug 2021 14:02 by ADMIN

Setting up a paper size to A1 and exporting the document actually sets the paperSize to 1. 

This leads to inappropriate values when entering the Page Setup options later in Excel.

Completed
Last Updated: 10 Nov 2022 06:29 by ADMIN
Release R3 2021 SP1
Exception when exporting a conational formatting rule with no formatting 
Completed
Last Updated: 27 Feb 2023 11:24 by ADMIN
Release R1 2023 SP1
Rows import stops after reading a formula cell.
Unplanned
Last Updated: 22 Aug 2023 12:31 by Arifullah
KeyNotFoundException: 'The given key was not present in the dictionary.' when reading a document,
due to incorrect "borderId" in "bordersList".
1 2