| Version | Change log |
| ClosedXML 0.104.2 Jan 23, 2025 |
Automatic fixer of function names: Correct name for newer functions (post 2013) is not what is seen in the GUI (e.g. correct name for CONCAT is _xlfn.CONCAT). That is rather obscure fact not known to most developers. The formula setters (e.g. IXLCell.FormulaA1) now automatically fix function names, so it is stored correctly in the file. Sorting updates references: In many cases, the sorted area has a column with references. The formula often references another row. Pre-0.105, the references in the formulas weren't updated correctly. Reimplementation/refactoring of old function infrastructure: Basically all implemented functions should be more faithful to how Excel behaves and evaluation of functions should be faster. implemented functions should be "complete" in sense that they correctly work for various arguments (e.g. various forms of ROMAN or pattern search in SUMIFS). The functions (before refactoring) had serious problems with ranges, errors or type coercion or structured references. The original parser back then didn't even parse literal arrays ({1,2,3;4,5,6}). Parser and other things were updated, but because there was ~180 functions, original implementation was kept and functions were functions were reused through an adapter. Except the adapter never worked right and there were some other serious problems. Bugfixes: Improve VML inset parsing by @jahav in #2595 Fix evaluation of LOG10 function by @jahav in #2597 Structural change caused ParsingException on defined names (Unexpected token EofSymbolId) by @Igor-Zlatomrezhev in #2462 Don't round TimeSpan to milliseconds by @jahav in #2444 Update rich text when text of a rich run changes by @jahav in #2516 Mark IF function as a range function by @jahav in #2509 Fix whitespace preservation in a rich text by @jahav in #2512 Hyperlinks move on structural changes by @jahav in #2412 +related changes: Move hyperlink from MiscSlice to XLHyperlinks collection by @jahav in #2409 Remove unused hyperlink prop from |
| ClosedXML 0.102.3 Jul 22, 2024 | Eliminate a couple of performance killers by @Pankraty in #2363 |
| ClosedXML 0.102.1 Aug 19, 2023 | |
| ClosedXML 0.100.3 Jan 12, 2023 | |
| ClosedXML 0.100.2 Jan 11, 2023 | |
| ClosedXML 0.100.1 Jan 10, 2023 | |
| ClosedXML 0.100.0 Jan 9, 2023 | |
| ClosedXML 0.97.0 Oct 21, 2022 | |
| ClosedXML 0.96.0 Jun 30, 2022 |
