excel_community

Added

• New Standard Chart Types:
  • BubbleChart (<c:bubbleChart>): 3-dimensional data comparison plotting X, Y, and Bubble Size with configurable bubbleScale and showNegativeBubbles.
  • StockChart (<c:stockChart>): Financial stock price fluctuations (High-Low-Close, Open-High-Low-Close) with showHighLowLines and showUpDownBars.
  • OfPieChart (<c:ofPieChart>): Pie-of-Pie and Bar-of-Pie secondary breakdown charts with configurable ofPieType (pie/bar), splitType (position/value/percent), and secondPieSize.
• Chart Grouping & Subtypes (ChartGrouping):
  • Added grouping parameter (clustered, stacked, percentStacked) to ColumnChart, BarChart, AreaChart, and LineChart.
  • Added showMarkers and smooth (spline curves) to LineChart.
  • Added showLines, showMarkers, and smooth (spline curves) to ScatterChart.
• Chart Data Labels (ChartDataLabels): Every chart type now accepts an optional dataLabels parameter that renders labels on each data point. Supported components: value, categoryName, seriesName, and percentage (pie / doughnut). Custom separator and labelPosition are also supported. The XML round-trip is preserved (labels written to <c:dLbls> are re-read via ChartXmlWriter.parseDataLabelsFromXml).
• Chart Color & Style Customization (ChartSeriesStyle, ChartFillType): Per-series visual customization for all chart types via ChartSeries.style.
  • Fills: Support for solid fills (ChartFillType.solid), customizable transparency with fillAlpha (ChartFillType.transparent), and border-only no-fill (ChartFillType.none).
  • Borders: Customizable borderColor, borderAlpha, and borderWidth in EMUs.
• Flutter Example & Documentation:
  • Added interactive sections in excel_flutter_example for Bubble, Stock & Stacked Charts, Chart Data Labels, and Chart Color Customization.
  • Updated README.md with complete documentation, parameter tables, and worked examples for all 11 chart types.

Fixed

• Merge Cells: Fix merge cells parsing and saving.

Added

• Conditional Formatting (<conditionalFormatting>): Native OpenXML/SpreadsheetML support for Conditional Formatting rules and Differential Styles (<dxfs>).
  • Support for numeric ranges (cellIs), text matching (containsText, notContains, beginsWith, endsWith), custom formula expressions (expression), and duplicate/unique values (duplicateValues, uniqueValues).
  • Multi-sheet support with worksheet-wide unique rule priority sequencing.
  • Round-trip preservation when reading, saving, and editing .xlsx files.
• Example & Flutter App Integration: Added standalone CLI example (example/excel_conditional_formatting.dart), documentation snippet, and a new interactive section in the Flutter demo app (excel_flutter_example).

Added

• Cell Comments: Added support and usage instructions for Cell Comments.
• Flutter example app: New Cell Comments section displaying a sheet with formatted comments and hover preview tooltips.

Added

• Pivot Table Add Official support and usage instructions for Pivot Tables.

Added

• Show Icon show excel community logo.
• Chage Tags update tags to excel_community.

Fixed

• SST parsing: Fixed the SST parsing logic to correctly read the shared strings from the SST stream.

Added

• Legacy XLS File Support: Added read-only support for parsing legacy .xls (Excel 97-2003) workbooks using a custom, clean-room OLE2 and BIFF8 parser implemented from scratch in pure Dart. It decodes sheet names, row/column dimensions, and cell values (TextCellValue, IntCellValue, DoubleCellValue), with transparent fallback inside Excel.decodeBytes and Excel.decodeBuffer using signature magic bytes detection.

• Improve documentation

Added

• Hidden Columns & Rows: New Sheet.setColumnHidden(index, hidden), Sheet.isColumnHidden(index), Sheet.setRowHidden(index, hidden), and Sheet.isRowHidden(index) methods to toggle and query visibility of columns/rows. Full serialization to OOXML <col hidden="1"> and <row hidden="1"> on save, and parsing from XLSX on decode.
• Flutter example app: New Hidden Columns & Rows sidebar demo displaying a multi-sheet spreadsheet where some sheets contain hidden elements and others are fully visible.

Fixed

• Cleaned Template: Removed stale empty drawing (xl/drawings/drawing1.xml) and its worksheet relationship from the base sheet template base64 string inside constants.dart. This ensures newly created worksheets (such as Sheet2) that have charts do not bleed/render their charts onto the first sheet (Sheet1) of the workbook, whilst preserving pre-existing charts when editing loaded files.

Fixed

• Multi-Sheet Freeze Panes: Added hidden columns to the Staff Salaries and Executive Perks sheets, with corresponding data removed. Now only the Public Directory sheet is visible, while the other two remain hidden (but fully functional) in the generated XLSX file.

• Multi-Sheet Charts: Fixed chart issue in multi-sheet workbooks.

Added

• Freeze Panes: New Sheet.frozenRows and Sheet.frozenColumns setters/getters (nullable int?). Each sheet in a workbook can carry its own independent freeze combination (rows+cols, rows only, cols only, or none). Values are serialized as OOXML-compliant <pane> elements on save and fully restored on decode.
• Examples: example/excel_freeze_panes.dart (single-sheet samples) and example/excel_freeze_panes_multisheet.dart (multi-sheet workbook with per-sheet freezes and round-trip assertions).
• Flutter example app: New Freeze Panes and Multi-Sheet Freeze Panes sidebar sections, with matching helpers and code snippets.
• Tests: Re-enabled test/freeze_panes_test.dart covering the four freeze configurations (4/4 passing).
• Documentation: README "Features" and "Usage" sections now document the freeze-pane API.

Fixed

• <sheetView> writer: Only the first sheet in the workbook carries tabSelected="1" (Excel requires exactly one active tab). <selection> entries and activePane are now chosen dynamically based on the actual split configuration, so Excel no longer shows the "Reparaciones / Recover as much as we can" dialog on multi-sheet workbooks.

Added

• Sheet Protection: Added full programmatic support for worksheet protection, including password hashing (legacy 16-bit XOR algorithm) and custom protection settings (objects, scenarios, format cells, select locked/unlocked cells, etc.).
• Cell Style Locking: Exposed locked and hidden boolean properties on CellStyle to control cell editability/visibility under sheet protection.
• Worksheet Protection Parsing & Serialization: Added parser and serializer rules to correctly process and serialize worksheet protection states and cell locking XML elements, fully compatible with Microsoft Excel and Google Sheets.

Fixed

• Wasm: Fix save excel file.
• Lint issues: Fix lint issues.
• XML parsing pipeline: Refactored to use a streaming-based approach with iterative DOM building instead of full recursive parsing.
• Performance: Optimized cell coordinate parsing and XML value extraction for better performance.
• Memory usage: Reduced memory usage during XML parsing by avoiding full recursive parsing.

Fixed

• Cell Style: Fix underline and strikethrough preservation bug in CellStyle constructor and parsing logic.
• Cell Style: Add strikethrough text style support.
• Cell Style: Add comprehensive tests for underline and strikethrough preservation.
• Cell Style: Update Flutter example with underline and strikethrough demos.

Improved

• XML parsing pipeline: Refactored to use a streaming-based approach with iterative DOM building instead of full recursive parsing.
• Performance: Optimized cell coordinate parsing and XML value extraction for better performance.
• Memory usage: Reduced memory usage during XML parsing by avoiding full recursive parsing.

Fixed

• XML parsing: NullPointerException: Fixed NullPointerException in _XfCache._readXfs method when processing shared strings with rich text formatting.

Fixed

• Wasm: Fix save excel file.
• Lint issues: Fix lint issues.

Fixed

• Chart XML — series name (c:tx): The series name inside <c:tx> was incorrectly wrapped in <c:strLit>, which is not a valid child according to the OOXML CT_SerTx schema (§21.2.2.174). It now correctly uses <c:v> directly, fixing broken/missing series names when opening generated files in Microsoft Excel.
• Chart XML — element order in CT_Chart: <c:autoTitleDeleted> was emitted before <c:title>, violating the required sequence defined in OOXML §21.2.2.29. The order is now <c:title> → <c:autoTitleDeleted>, fixing chart validation errors in strict Excel readers.
• standard_21 format code: Was 'h:mm:dd' (invalid), corrected to 'h:mm:ss' per ECMA-376 §18.8.30.
• standard_40 format code: Was '#,##0.00;[Red](#,#)' (truncated), corrected to '#,##0.00;[Red](#,##0.00)'.

Added

• Complete OOXML standard number format table (ECMA-376 §18.8.30): added previously missing built-in format IDs:
  • Currency formats standard_5–standard_8 ($#,##0, $#,##0.00 with normal/red negative variants).
  • Reserved/fallback formats standard_23–standard_26 (mapped to General).
  • CJK locale date/time formats standard_27–standard_36.
  • Accounting with fill-character formats standard_41–standard_44 (_(* …) / _($* …) patterns).
• Parser refactor: split monolithic parse.dart into styles_parser.dart (style/XF resolution) and worksheet_parser.dart (row/cell parsing) for improved maintainability.

Added

• Image embedding support: embed PNG, JPEG, GIF, BMP, TIFF, WMF, EMF, SVG, WebP, and ICO images into worksheets.
• ExcelImage model class with fromFile factory for automatic type detection from file extension.
• ExcelImageType enum with fromExtension factory covering 10 image formats.
• ImageAnchor class with fromPixels factory (96 DPI) and direct EMU constructor.
• SheetImages extension on Sheet exposing addImage() and images getter.
• _ImageManager save-pipeline component that writes OOXML drawing, relationship, and media files.
• New example example/excel_images.dart demonstrating PNG and SVG embedding.
• README "Images" section with full usage examples and supported-formats table.

• Fix Excel Community logo.

• Added logo for the package in the README.md.

• Add Excel Community logo to pub.dev.

• Update logo to open source version.
• Improve package README.md and add a preview image.
• Update package metadata for pub.dev.
• Fix chart x-axis labels for scatter charts.

• Fix Losing Cell styling when setting a new value to a cell.

• Fix rich-text bold/italic/underline parsing per ECMA-376

• add funding text

• Fix underline preservation bug in CellStyle constructor and parsing logic.
• Add strikethrough text style support.
• Add comprehensive tests for underline and strikethrough preservation.
• Update Flutter example with underline and strikethrough demos.

• Fix color accessibility.

• Apply clean code fix minors bugs.

• Apply Clean Architecture in Save class.
• Refactor Sheet class.
• Refactor Color class.
• Refactor Border class.
• Refactor Formula class.
• Refactor NumberFormat class.

• Renamed main example to example/main.dart for better visibility on pub.dev.
• Significantly increased documentation coverage (>28%) across the public API.
• Added detailed documentation for all chart types and cell value classes.

• Reorganized tests: moved manual debug scripts to test/manual/.
• Fixed static analysis errors in parse.dart and save_file.dart.
• Improved package metadata for pub.dev.

• Initial Release of the community fork.
• Forked from excel
• Updated minimum Dart SDK to 3.6.0
• Migrate from dart:html to package:web
• Update packages to latest versions
• Added support for charts