Orientation, margins, scale to fit one page, paper type, header/footer, etc.
Add support for creating Tables and applying tables styles (predefined ones, similar to MS Excel, or custom).
Add support for Data Validation.
Add support for Comments.
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 }); }
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.