Approved
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());
Approved
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
     });
}
Approved
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.