v1.11.0

Features

• Support for adding a note to a cell with Spreadsheet.AddNote(string cellReference, string noteText). Currently plain-text notes without styling are supported.
• Added utility method SpreadsheetUtility.TryParseColumnName. It will try to parse a column name (e.g. A) to its column number (e.g. 1).
• The Style class now has a Format property that is intended to replace the NumberFormat property. Previously there was an issue that a format could automatically use one of the locale dependent standard formats from Excel, even if the user wanted to specify a custom format. The Format property allows for explicitly specifying whether the number format should be a custom or a standard one. Thanks to @AlexVallat for the contribution!

Breaking changes

• The NumberFormat property on Style has been marked as obsolete. Existing code should migrate to use the Format property instead, either by using Format = NumberFormat.Standard(...) to use one of the standard formats from Excel, or Format = NumberFormat.Custom(...) to use a custom format.

Other changes

• The assembly is now signed with a strong name.
• The .NET Standard targets of the library are no longer marked as being trimmable. This is because those targets don't support trimming (https://learn.microsoft.com/en-us/dotnet/core/compatibility/sdk/8.0/trimming-unsupported-targetframework). .NET 6 and later targets are still marked as being trimmable.