Backlog

V2.x

Mandatory

• Bug fixes
• Backports to PicoXLSX and NanoXLSX4j
• Definition of plugin structure (preparation of modularization)

Optional

• Migration from Sandcastle to Doxygen or similar, to enable GitHub Actions for documentation generation (solved by a GitHub Action)
• Automatization of release process by GitHub Actions
  • Compilation and deployment of release
  • Deployment of NuGet package

V3.x

Mandatory

Core / Shared

• Data validation (on cells)

Modules

Formulas

• Remove BasicFormulas from monolith*, and...
• Introduction of a formula extension (essentials package) adapted to the AddFormula function with all known Excel formulas → Should solve: https://github.com/rabanti-github/NanoXLSX/issues/27

Formatting & Data

• Cell inline formatting
• Data validation
• Conditional formatting
• Introduction of a format builder extension, that covers all possible formatting values (e.g. Asian date/time formats or currencies)

Styles

• Replacement of number and string values in style components to enums according to specs
• Relocate basic styles from monolith* to styling module (essentials package)
• Introduce Theming (reference to color theme f.e.) → should probably use an injection function to add XML documents by a module (injection from plug-in module to XlsxWriter in Core package)

Misc

• Support for Workbook streaming (large files) → https://github.com/rabanti-github/NanoXLSX/issues/38 (PoC by mla-alm)

Optional / Requests

• Cell.Range(startColumn, startRow, endColumn, endRow))
• Workbooks.Add("name") which return a new workbook
• Worksheets.Exists(string WorksheetName)
• Convenience function for freezing the first row/column/both
• Flag to disable or enable setting the current cell address when using AddCell() --> Currently AddCell() triggers the "cursor" to the next cell in the active cell direction
• Cell comments
• Cell auto-fit function (for column width and row height)
• Worksheet Tab color
• RichText parser for cell text input

Legend

* The current v2.x library is meant as 'Monolith'