Important
To ensure the long-term sustainability of this project, a monthly maintenance fee has been introduced. This fee is required to be paid by all organizations or users of any library from this project who generate revenue. You can pay the fee via GitHub Sponsors.
To enact this, an EULA on binary releases is added to the repo and nuget packages that requires payment of the maintenance fee.
For more information on who must pay the fee and other frequently asked questions, please see the Open Source Maintenance Fee organisation page.
What's Changed
- Add LargeExcelFileBenchmarkXSSFReaderLoad method by @tonyqus in #1701
- Remove NSax to avoid potential licensing issues by @antony-liu in #1702
- Add new CreateFieldRun overload method to help ease the use of creating field run by @tonyqus in #1704
- Fix unable to set mutiple print area in HSSF by @Copilot in #1706
- Some patches from poi by @antony-liu in #1703
- Fix HSSFSheet.ShiftRows: PhysicalNumberOfRows not decreasing when shifting rows up by @Copilot in #1707
- Fix phone number format: escaped dashes misidentified as grouping chars; decimal cast in special format classes by @Copilot in #1710
- [Experimental] Add ToDataTable and ToDataSet feature by @tonyqus in #1705
- Remove duplicate ST_OnOff definition in Math.cs by @tonyqus in #1713
- Add maxRows parameter to ISheet.AutoSizeColumn method. by @tonyqus in #1716
- Remove [Platform("Win")] from TestVBAMacroReader; fix AutoSizeColumn on Linux by @Copilot in #1715
- Replace SixLabors.Fonts with SkiaSharp for text measurement by @Copilot in #1717
- Replace SixLabors.ImageSharp with SkiaSharp by @Copilot in #1718
- Upgrade SkiaSharp to 3.119.2 by @Copilot in #1719
- Fix CSE array formula evaluation: count booleans in arithmetic operators by @ken-swyfft in #1720
- POI Bug 66187 - MS document is error by XWPFDocument to write when XWPFRun call method getTextHightlightColor() or getEmphasisMark by @tonyqus in #1723
- POI Bug 69583 - when copying cells with dates - prefer using the numeric data directly by @tonyqus in #1724
- POI Bug 64986 - Match function cannot evaluate formulas with extra comma before missing optional parameter by @tonyqus in #1725
- POI Bug 58468 - Implement Days function by @tonyqus in #1727
- Lazy-load SharedStringsTable with streaming parser, dirty tracking, and allocation reduction by @Copilot in #1728
- Add support for XDDF by @antony-liu in #1521
- Add LargeSSTBenchmark by @tonyqus in #1729
- Add LargeStylesBenchmark with deterministic HugeStyles.xlsx generator by @Copilot in #1730
- Implement lazy loading for xl/styles.xml in XSSFWorkbook by @Copilot in #1731
- Integrate XDDFChart into XSSFDrawing by @tonyqus in #1733
- Some patches from poi by @antony-liu in #1711
- Add unit test for bug 1712 by @tonyqus in #1739
- Sheet Lazy Loading Implementation by @tonyqus in #1741
- Add UseXmlReader Switch to ShardStringTable by @tonyqus in #1740
- Fix Windows CI: stop TestTempFile from deleting shared temp directory by @ken-swyfft in #1746
- Cache XSSFSheet.MergedRegions to eliminate repeated XML parsing by @ken-swyfft in #1744
- Implement the larger I/O buffers optimization for SXSSF by @tonyqus in #1749
- Perf: use Stream.CopyTo and zero-copy MemoryPackagePart reads by @ken-swyfft in #1743
- Fix volatile correctness in lazy load and add roundtrip test by @ken-swyfft in #1747
- Replace SortedDictionary with Dictionary in HSSFRow, XSSFRow and SXSSFRow by @tonyqus in #1753
- Cache XSSFRow.FirstCellNum/LastCellNum to avoid O(n) LINQ scans by @ken-swyfft in #1745
- Bump NuGetizer from 1.1.0 to 1.4.7 by @ken-swyfft in #1757
- Restore sorted cell iteration order with lazy cache by @ken-swyfft in #1759
- XWPFChart implementation - Phrase I by @tonyqus in #1735
- Fix Rounding issue in Add, Divide and Substract by @tonyqus in #1760
- Add OpenCode Agent by @tonyqus in #1761
- Add AGENTS.md for AI agent and contributor orientation by @ken-swyfft in #1756
- Added .NET 10 to 9 project files, pushed branch, PR creation automated. by @opencode-agent[bot] in #1763
- Replace Hashtable/ArrayList with generic collections in formula eval hot path by @ken-swyfft in #1742
- XLookup Function Code Sync from POI by @tonyqus in #1767
- Upgrade NUnit to 4.5.1 by @tonyqus in #1768
- Change CreateColumnVector to CreateRowVector by @tonyqus in #1769
- Enhanced AGENTS.md with style & verification guidelines by @opencode-agent[bot] in #1764
- POI Bug 63842 FractionFormat casts whole part of the value into 'int' by @tonyqus in #1726
- Apply Open Source Maintainence Fee EULA to NPOI Binary release by @tonyqus in #1770
- Add caching to XSSFCell numeric and rich string value access by @tonyqus in #1754
- Remove Nugetizer since it always ignore PrivateAssets setting for SkiaSharp by @tonyqus in #1771
- Update Github workflow by @tonyqus in #1772
- Implement Area Chart based on XDDF by @tonyqus in #1773
- AutoSizeRow fix for WrapText by @opencode-agent[bot] in #1774
- Developer Friendly Api Implementation I by @tonyqus in #1776
- POI Bug 51037 - apply default column style if no style set by @opencode-agent[bot] in #1781
Full Changelog: 2.7.6-rc1...2.8.0-rc2