All notable changes to this project will be documented in this file.
The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.
- Fixed Bug that Merge Cells were not parsed
- Fix Archive version
- Modified Readme.md
- Modified Readme.md
CellIndex.indexByColumnRow()
now requires non-null integers of row index and column index
- Renamed
Formula
toFormulaCellValue
- Cells value now represented by the sealed class
CellValue
instead ofdynamic
. Subtypes areTextCellValue
FormulaCellValue
,IntCellValue
,DoubleCellValue
,DateCellValue
,TextCellValue
,BoolCellValue
,TimeCellValue
,DateTimeCellValue
and they allow for exhaustive switch (see Dart Docs (sealed class modifier)).
- Added support for date, time and date-time values
- Added support for custom number formats
- Strict typing for cell values (that allow for exhaustive switch statements)
- Issue where seamingly random values are converted to a date iso8601 string, caused by incorrect interpretation of numFmtId=164
- Fixed corrupt excel file when writing large datasets with improvements in shared_strings
- Renamed
getColAutoFits()
togetColumnAutoFits()
, and changed return type toMap<int, bool>
inSheet
- Renamed
getColWidths()
togetColumnWidths()
, and changed return type toMap<int, double>
inSheet
- Renamed
getColAutoFit()
togetColumnAutoFit()
inSheet
- Renamed
getColWidth()
togetColumnWidth()
inSheet
- Renamed
setColAutoFit()
tosetColumnAutoFit()
inSheet
- Renamed
setColWidth()
tosetColumnWidth()
inSheet
- Add setMergedCellStyle() to Sheet, allowing to set style for merged cells
- Add setDefaultRowHeight(), setDefaultColumnWidth() to Sheet
- Add defaultRowHeight and defaultColumnWidth properties to Sheet
- Add getRowHeights(), getRowHeight() and setRowHeight to Sheet
- Add pub topics
- Support sharedStrings absolute path
- Loosen up dependency constraints
- Clean up markdown files
- Clean up code
- Fixed many instances of missing/wrong data by comparing strings instead of hashes
- Ignore shared text in 'rPh' element
- Fix findAndReplace() not doing anything
- Add border functionality
- Fix Header and Footer with special characters
- Fix sheet.merge()
- Automated Publishing.
- Readme updated.
- Fix bug on header and footer.
- Fix saving XLXS bug on archive 3.2.0
- Forcefully initializing the variables on re-creation
- Fix of sharedStringTarget fail to initialize issue
- Fix of value not updating in cell
- Null-safety
- Fixes
- Improvement in speed of apeending the rows
- Improvement in speed of apeending the rows
- Iterating Sheet's Data Object to operate on particular cells
- Health Improvement
- Bugs on deleting sheet
- Copy
- Rename
- Delete
- Link Sheets
- Un-Link Sheets
- Font Family
- Font Size
- Italic
- Underline
- Bold
- Faster Processing
- Bugs related to appendRows
- Bugs related to removal of rows
- Find and Replace
- Add row / column from Iterables
- Bugs related to Spanning
- Unwanted removal of rows and columns from spanned cells
- Analysis related changes
- Vertical Alignment Issue
- Merging of Rows and Columns
- Un-Merging of Rows and Columns
- Font Color
- Background Color
- Setting Default Sheet
- Minor Bugs
- TextWrapping and (Clip in Google Sheets) / (ShrinkToFit in Microsoft Excel)
- Horizontal and Vertical Alignment
- Update Cell by Cell-Name ("A1")
- Health Maintenance
- Minor Bug Fixes
- Initial Release