What's Changed
This release brings the following features and fixes:
New Features
- Adds
RightToLeftparameter inOpenXmlConfigurationto make worksheets being displayed in a right-to-left layout when opened in Excel by @michelebastione in #935 (mirrors #927) - Adds the
ExcelHiddenAttributethat, when used to decorate a property, hides the mapped column in Excel by @michelebastione in #935 (mirrors #932)
Bugfixes
- Fixes
IAsyncEnumeratornot being properly disposed inAsyncEnumerableWriteAdapter, leading to database connections not being released by @izanhzh and @michelebastione in #907 (mirrors #906) - Fixed an error that resulted in corrupted Excel files when filling a template by @A-nony-mous and @michelebastione in #926 (mirrors #917)
- Fixes empty or whitespace rows breaking the parsing of csv files by @michelebastione in #926 (mirrors #923)
- Fixes numeric value not being passed in a culturally invariant format to template cells when being fetched from a
Dictionaryor aDataTableby @michelebastione in #926 (mirrors #924) - Fixes cells in Excel templates containing strings such as
@group(like in some emails) to be mistakenly identified as template parameters by @michelebastione in #935 (mirrors #928) - Refactored column width writing logic to default to Excel's 8.43 characters (64px) and taking padding into account by @michelebastione in #935 (mirrors #930)
Full Changelog: 1.42.0...1.43.0