v0.710.0

What's Changed

Bug Fixes

• fix: refuse inserts that push cells off the sheet; grow headerless tables (#773, #774) (#776) @jafin
• fix: grow a table once when rows are inserted at a table row (#775) @jafin
• fix: apply SaveOptions.CompressionLevel when a loaded workbook is saved (#764) @jafin
• fix: extended charts follow SaveOptions.CompressionLevel (#763) @jafin
• fix: copy a table with no header row as it is (#761) @jafin
• fix: save a workbook XLibur can reload after an r:id-less sheet or a Strict package (#759) @jafin
• fix: keep grouping pivot cache fields through a save (#758) @jafin
• fix: write above/below-average conditional formats on save (#757) @jafin
• fix: keep a loaded totals-row formula and its cached value (#754) @jafin
• fix: load a table without a header row without writing to its cells (#753) @jafin
• fix: write in-cell images as Excel reads them (#747) @jafin
• fix: keep reading sheet data past a long whitespace run (#751) @jafin
• fix: write cell numbers and date serials so a load reads back the same value (#748) @jafin
• fix: write a totals-row cell from its own value, and keep it at load (#746) @jafin

Performance

• perf: lift the fast-path exclusions for pivot tables, totals rows, cell images and cm (#721) (#736) @jafin
• perf: keep an unchanged sheet with formulas on save (#720) (#735) @jafin
• perf: keep more Excel-written sheets whole on save (#722) (#734) @jafin
• perf: keep an unchanged sheet's part on save when it is larger than 16 MB (#723) (#737) @jafin
• perf: write back loaded shared formulas on save (#692) (#733) @jafin
• perf: keep an unchanged sheet's part on a later save, not only the first (#732) @jafin

Documentation

• docs: changelog for #756 (#762) @jafin
• docs: changelog for #743, and load its files in LoadingTests (#760) @jafin
• docs: changelog for the table loading fixes (#753, #754) (#755) @jafin
• docs: changelog for the batch-738 bug fixes (#746-#751) (#752) @jafin
• docs: changelog for the fast-path follow-ups (#732-#737) (#745) @jafin

Dependencies

• Bump TUnit from 1.73.19 to 1.75.0 (#771) @dependabot[bot]
• Bump System.Security.Cryptography.Pkcs from 8.0.2 to 10.0.13 (#770) @dependabot[bot]
• Bump Scriban from 7.5.0 to 7.5.1 (#769) @dependabot[bot]
• Bump roslynmcp.server from 0.9.0 to 0.10.0 (#768) @dependabot[bot]
• Bump Polyfill from 11.4.3 to 11.4.5 (#767) @dependabot[bot]
• Bump Microsoft.SourceLink.GitHub from 10.0.401 to 10.0.402 (#766) @dependabot[bot]
• Bump cyclonedx from 6.2.0 to 6.3.1 (#765) @dependabot[bot]
• Bump Microsoft.Testing.Extensions.CodeCoverage and TUnit (#731) @dependabot[bot]
• Bump roslynmcp.server from 0.6.7 to 0.9.0 (#730) @dependabot[bot]
• build(deps): bump release-drafter/release-drafter from 7.7.0 to 7.10.0 (#726) @dependabot[bot]
• build(deps): bump release-drafter/release-drafter/autolabeler from 7.7.0 to 7.10.0 (#727) @dependabot[bot]
• Bump Polyfill from 11.4.1 to 11.4.3 (#729) @dependabot[bot]

Other Changes

• chore: remove a committed Excel lock file (#779) @jafin
• style: apply dotnet format (#778) @jafin
• ci: exclude binary test resources from Sonar analysis (#777) @jafin
• build: pin patched System.Security.Cryptography.Pkcs in XLibur.Tests (#744) @jafin
• build(deps): bump release-drafter/release-drafter from 7.7.0 to 7.10.0 (#726) @dependabot[bot]
• build(deps): bump release-drafter/release-drafter/autolabeler from 7.7.0 to 7.10.0 (#727) @dependabot[bot]

Thanks to @jafin for contributing to this release.