v1.10.0

Features

• Reduced memory allocations for writing the resulting XLSX file. This should improve performance for spreadsheets containing styles, data validations, cell merges, or multiple worksheets.
• Added option SpreadCheetahOptions.WriteCellReferenceAttributes which enables writing the explicit cell reference on each cell. This is not required when the spreadsheet is being opened in Excel, but it is required for doing a comparison with Microsoft's Spreadsheet Compare tool. The option defaults to false.
• Added utility method SpreadsheetUtility.TryGetColumnNameUtf8. Similarly to SpreadsheetUtility.GetColumnName it converts a column number (e.g. 1) into a column name (e.g. A). SpreadsheetUtility.TryGetColumnNameUtf8 will write the result into a Span<byte>.
• Other minor performance improvements.

Bug fixes

• Font names can no longer exceed 31 characters, due to it being the limit in Excel. Attempting to use a longer font name will now cause an exception to be thrown.
• Cell references can no longer refer to row number 0. E.g. A0 is no longer allowed and will cause an exception to be thrown.
• Fixed an issue that could occur when writing multiple cells with values longer than the buffer size.