grid_sheet 2.2.0

A powerful Flutter DataGrid/DataTable for large datasets, offering Excel-like features and fully customizable cells — ready with minimal setup. See README for full features

Changelog

2.2.0

Breaking Changes

• Added isSelected to GridSheetRowWrapper callbacks, to expose row-level selection state based on GridSheetManager.selectedRowKeys rather than individual cell selection.
• Deprecated GridSheetConfiguration.serialNumberColumn and serialNumberColumnWidth; use GridSheet.indexColumn instead.
• Deprecated GridSheetDynamicTableGeneration.type and width; use columnBuilder and rowBuilder to customize generated columns and rows.

Bug Fixes

• Fixed built-in and custom select-all header checkboxes not updating when row selection changes through individual row taps.
• Fixed GridSheetManager.filters exposing the mutable internal filter map by returning an unmodifiable view instead.
• Fixed getSelectedRows() and getSelectedColumns() rebuilding full lookup maps on every call by reusing the existing row and column indexes.
• Fixed column reordering leaving stale context menus and filtered-row caches by resetting both after reorderColumnsByPositions(), setColumnOrderByNames(), and resetColumnOrder().
• Fixed fillCells() triggering redundant formula recalculations against partially filled data by batching formula-dependent recalculations.
• Fixed createSnapshot() sharing dropdownOptions lists with live columns by copying the lists when creating snapshots.
• Added CellAuditTrail to the package's public exports alongside the existing CellChangeRecord export.

New Features

• Added full RTL support through GridSheetDirection, including mirrored column layout, alignment, borders, scrolling, virtualization, resizing, drag operations, pagination controls, expansion indicators, sorting icons, and reading-start/reading-end pinning.
• Added configurable GridSheet.indexColumn, replacing the deprecated serialNumberColumn and serialNumberColumnWidth properties with a single GridSheetColumn? supporting title, width, pinning, alignment, and visibility configuration.
• Added GridSheetColumn.showOverflowTooltip for opt-in per-column overflow hover tooltips, reducing unnecessary text-overflow measurement costs.
• Added dynamic table customization through GridSheetDynamicTableGeneration.columnBuilder and rowBuilder, allowing generated columns and rows to override their properties while retaining generator-managed keys and indexes.
• Added undo-delete support for row and column deletions through GridSheetConfiguration.enableUndoDelete, built-in and custom undo prompts, and GridSheetUndoDeleteEvent callbacks.
• Extended GridSheetCellContext.onToggleRowExpansion and isRowExpanded to all row cells when row expansion is enabled, allowing custom cells to provide their own expansion controls.
• Added configurable pinned-column dividers through GridSheetStyleConfiguration.pinnedLeftDividerColor, pinnedRightDividerColor, and pinnedColumnsDividerWidth, rendered between panes without overlaying active cell content.

2.1.0

Breaking Changes

• Changed GridSheetRow.data to an unmodifiable view to prevent mutations that bypass change tracking and formula dependency updates; use GridSheetManager.setCellAt or updateRowByKey instead.
• Changed GridSheetRow.height to a read-only getter to prevent direct mutations from desynchronizing visual row heights from the virtualized layout; use the provided row-height manager APIs instead.
• Added the isPinnedRight parameter to GridSheetHeaderWrapper, GridSheetFilterWrapper, and GridSheetRowWrapper callbacks, requiring existing callbacks to accept the new parameter.
• Changed enableCellNavigation Left/Right arrow keys to clamp at the first/last column instead of wrapping between rows, while Tab/Shift+Tab retain row wrapping and Left/Right during text editing control the cursor instead of cell navigation.

Bug Fixes

• Fixed updateRowHeights() and updateRowHeightsByKeys() updating model heights without visually resizing the corresponding rows.
• Fixed autofillVerticalCells() and autofillHorizontalCells() ignoring supplied sourceValues by seeding source cells with the provided values before extrapolation.
• Fixed stale column widths returned by findColumnByKey(), findColumnByName(), and getColumnWidths() after auto-fit or drag-resizing by rebuilding the cached column index after width changes.
• Fixed virtualized arrow-key and Enter navigation failing for cells outside the current build window by scrolling targets into the built range before requesting focus.
• Fixed keyboard navigation selecting the destination cell when enableCellSelection is enabled; navigation now moves focus without changing selection.
• Fixed the pinned-right boundary border rendering above selected or hovered row highlights by moving it into the pane's first-column cells to share the pinned-left overlay stack.
• Fixed clearPinColumns() and similar column moves causing setState()/markNeedsBuild() errors by deferring column-virtualization range recalculation until the next frame.
• Fixed the pinned-right boundary border disappearing when horizontal overflow is absent by suppressing the trailing scrollable-column border only when overflow actually exists.

New Features

• Added GridSheet.onError, GridSheetErrorEvent, and GridSheetErrorSource for routing internally handled failures to custom error-reporting systems instead of debugPrint.
• Added Sliver-backed row virtualization to build only rows within or near the viewport, enabling smooth scrolling with 100K+ rows while keeping widget counts bounded.
• Added column virtualization for scrollable non-pinned columns, significantly improving performance for wide schemas with hundreds of columns.
• Added full row-expansion support for virtualized rows, including virtualized expand/collapse animations.
• Updated editable cells to support multiline text when row heights increase through resizing or auto-fit APIs while preserving Enter-to-next-row navigation.
• Added right-pinned columns via GridSheetColumn.pinnedRight, including manager APIs, pinned-right selection/conditional-format support, and a dedicated non-virtualized pane before the scrollbar.
• Rebuilt enableCellNavigation with dedicated Shortcuts/Actions bindings so Tab/Shift+Tab follow logical order across pinned/hidden columns, Shift+Enter moves upward, and read-only cells remain keyboard-selectable.
• Added GridSheet.noColumnsWidget to display a configurable empty state when all real columns are hidden, excluding the synthetic serial-number column from the visibility check.

2.0.4

Bug Fixes

• Fixed the cell editor border using row border styling instead of its own configuration.
• Fixed header and cell overflow tooltips not attaching correctly in some cases.
• Updated hoverColorOnRow to match selectionColor behavior when showBorderOnSelection is enabled.
• Fixed the row expansion panel width to match the grid's rendered width instead of the window width, preventing overflow and right-edge gaps.
• Fixed the row expansion panel scrollbar overlapping the last column by reserving scrollbar space.

New Features

• Added context menu appearance configuration (elevation, radius, background, and backdrop dimming).
• Added custom builders for reveal animations and cell flash effects.
• Added customizable auto-fill handle shape and border radius.
• Added a custom scrollbar builder and independent horizontal/vertical scrollbar visibility.
• Added vertical scrollbar placement options (afterLastColumn or overlay).
• Added configurable resize handle color and thickness.
• Added configurable drag feedback elevation and opacity.
• Added independent cell editor border color and width.
• Added stretchColumnsToFillWidth to expand columns and fill available width.
• Added maxStretchWidth to limit how much individual columns can stretch.
• Redesigned and improved the row expansion panel layout with responsive field wrapping that adapts continuously to the available width.

2.0.3

Bug Fixes

• Fixed serial numbers resetting on each server-side pagination page instead of continuing across pages.
• Fixed numeric input formatters clearing cells when entering decimals or negative values.
• Fixed createSnapshot()/restoreSnapshot() losing filtered rows, undo baselines, and formula state.
• Fixed insertRows(), deleteRowsAt(), and updateRowHeights() using incorrect row positions with client-side pagination.
• Fixed between and notBetween filters failing with negative values.
• Fixed corrupted pagination state causing duplicate rows after a failed infiniteScroll reload.
• Fixed incorrect serialization of conditional-format fontWeight values in getConditionalFormattingStyles().
• Fixed animationConfiguration, conditionalFormatRules, and evaluator not updating after GridSheet rebuilds.
• Fixed the context menu remaining open after row/column changes, sorting, filtering, or reloads.
• Fixed GridSheetRow.copyWith() losing the original row height, breaking resetHeight().
• Fixed findAndReplace counting matches in read-only and non-editable cells.
• Fixed parseHexColor incorrectly parsing 3-digit shorthand hex colors.
• Corrected GridSheetRow documentation to prevent corrupting the undo baseline.

2.0.2

• Added a live demo page to showcase GridSheet features and capabilities.
• Added GridSheetConditionalFormatRule.stopIfTrue to support Excel-style "Stop If True" behavior. When enabled on a matching rule, lower-priority conditional formatting rules are ignored for that cell.
• Added GridSheetManager.reorderConditionalFormatRulesByPositions to allow changing conditional formatting rule priority after rules have been added.
• Added the atIndex parameter to addConditionalFormatRule to insert a new conditional formatting rule at a specific priority position instead of adding it at the end.
• Renamed the GridSheetCellValueChangedEvent.columnName property to name for improved clarity and consistency.
• Added the title property to GridSheetCellValueChangedEvent to provide additional cell context.
• Added support for preserving conditional formatting styles when generating exports GridSheetManager.getConditionalFormattingStyles.
• Fixed duplicate column border rendering in tables when showColumnBorders is enabled with frozen and active columns.

2.0.1

Bug Fixes

• Fixed formula dependency synchronization after structural changes.
• Fixed formula undo history after row and column operations.
• Fixed autofill corruption after sorting and structural modifications.
• Fixed incorrect numeric autofill pattern detection.
• Fixed selection rendering with pinned-left and serial-number columns.
• Fixed hover synchronization across pinned and scrollable sections.
• Fixed hidden columns retaining stale selection state.
• Fixed stale selection and expanded-row state after reloads.
• Fixed duplicated rows sharing mutable data.
• Fixed stale cell listeners after column insertions and deletions.
• Fixed row disposal idempotency.
• Fixed context menu visibility logic.
• Fixed runtime type errors when assigning null to mixed-type data.
• Fixed LEFT, RIGHT, and MID throwing RangeError.
• Improved JSON import validation with descriptive errors.
• Fixed multiple rendering, pagination, caching, rebuild, documentation, and compatibility issues.
• Fixed formula-column insertion without matching defaultValues.
• Secured CSV exports against formula/DDE injection.
• Fixed stale infinite-scroll responses merging after reloads.
• Fixed exportToCSVWithFormulas(includeFormulas: true) exporting evaluated values instead of formulas.
• Fixed initial auto-fetch when using infiniteScroll without serverSidePagination.

2.0.0

Breaking Changes

• deleteRowsAt/deleteRowsByKeys now return Future<List<ValueKey<String>>> instead of Future<int>.
• Renamed GridSheetLayoutConfiguration to GridSheetConfiguration (deprecated alias provided).
• Renamed GridSheetgridManagerHelpers to GridSheetManagerHelpers.
• Deprecated GridSheetConfiguration.rowHeight; use GridSheetRow.height for per-row heights.

New Features

• Added configurable staggered slide-in animation via GridSheetAnimationConfiguration (GridSheet.animationConfiguration).
• Slide-in animation now automatically replays after pagination changes.
• Added animateRowsOnSortOrFilter to animate row slide-in after sorting and filtering.
• Row slide-in animation now supports server-side pagination and infinite scroll when enabled.
• Added configurable cellChangeFlashEnabled animation for edited or recalculated cells.
• Added columnVisibilityFadeEnabled for smooth column show/hide width and opacity transitions.
• Added insertRows and insertColumns APIs with configurable insertion positions.
• Added defaultValues support for insertRows and insertRowsAt.
• Added refreshAllFormulas; CSV exports now refresh formulas automatically before exporting.
• Added selectionIncludesPinnedLeftCells and conditionalFormatIncludesPinnedLeftCells.
• Added showOnlyEditableColumns to row expansion configuration.
• Added pinColumnsToLeft, clearPinColumns, pinnedLeftColumns, and activeColumns.
• rowStateColorBuilder, rowStateIconBuilder, and sortIconBuilder can now return null.
• Added GridSheetRow.resetHeight to restore a row's original height.
• Added GridSheetManager.getCellFormula to retrieve a cell's raw formula.
• Added onlyCurrentPageRows to exportToCSV.

Performance Improvements

• Optimized formula recalculation to update only dependent formulas.
• Improved formula initialization by avoiding unnecessary dependency graph copies.
• Replaced recursive circular-reference detection with an iterative implementation.
• Optimized bulk row deletion with a single-pass algorithm.
• Eliminated unnecessary full-grid rebuilds during column resizing.
• Reduced selection border rendering overhead.
• Optimized overflow tooltip detection using cached text measurements.

Improvements

• Formula dependency graphs now stay synchronized after structural changes.
• GridSheetConfiguration now updates automatically on parent rebuilds.
• Improved server-side pagination by ignoring stale overlapping requests.
• Added graceful handling for failed server-side page requests.
• Improved built-in row expansion and row selection interaction.
• selectColumnAcrossAllPages now correctly affects selected-column APIs.
• resetAllRowHeights now restores each row's original height.

API Changes

• Added APIs for programmatic pinned-column management.
• Renamed freezeColumnsUptoIndex to pinColumnsLeftUptoIndex (deprecated alias retained).
• Deprecated freezeColumnsUptoKey in favor of pinColumnsLeftUptoIndex.
• Renamed GridSheetColumn.pinnedLeft to pinnedLeft (deprecated alias retained).
• Renamed GridSheetColumnContextInfo.isFrozen to isPinnedLeft (deprecated alias retained).
• Renamed GridSheet.onCellValueChange to onCellValueChanged (deprecated alias retained).
• Fixed exportToCSV.onlyCurrentpageRows typo (onlyCurrentPageRows is now canonical).
• Deprecated GridSheetConfiguration.rowHeight in favor of GridSheetRow.height.
• Renamed GridSheetgridManagerHelpers to GridSheetManagerHelpers.
• Renamed Token/TokenType to GridSheetFormulaToken/GridSheetFormulaTokenType (deprecated aliases retained).
• Restored deprecated compatibility shims for enableReorder and reorderColumnsByOrder.

Default Changes

• Changed default rowsPerPage from 50 to 30.
• Changed default grid border radius from 4px rounded to square.

1.3.1

• Added row expansion feature support — to expand an inline sub-panel (a child table, a form, extra fields).
• Added new property description in GridSheetColumn — useful for abbreviated column names descriptions.
• Added manual and scheduled auto-reload with reload callbacks and runtime controls.
• Added rowsLoader for refreshing client-side data without rebuilding.
• Added updateConfiguration for updating non-structural layout settings at runtime.
• Added cell tooltip on overflow — when cell text is truncated, show a tooltip on hover with the full value.
• Fixed reload lifecycle, auto-reload scheduling, and error handling.
• Fixed rows-per-page sync and infinite-scroll reload rollback.
• Fixed missing fields in GridSheetLayoutConfiguration (copyWith, equality, hashCode, and toString).
• Fixed evaluateFormula return type.
• Fixed fillCells(increment: true) correctly incrementing numeric values.

1.3.0

• Added server-side (lazy pagination), infinity-scroll paginations feature support
• Added row-reordering feature support
• Added cell type GridSheetColumnType.dropdown — built-in dropdown/select cells feature support
• Renamed enableReorder property to enableColumnReorder
• Renamed reorderColumnsByOrder method to reorderColumnsByPositions
• Fixed performance issue when switching theme.
• Fixed cell level conditional format issue when reordering columns

1.2.9

• Optimized internal code for better overall performance and stability
• Fixed minor bugs

1.2.8

• Optimized internal code for better overall performance and stability
• Added row resize functionality
• Added Unique Count aggregation
• Added support of showColumnHeaderRow option in layoutConfiguration
• Added support of ascSortIconColor, descSortIconColor options in styleConfiguration

1.2.7

• Enhanced Pagination
• Optimized code and improved performance

1.2.6

• Added support of column level aggregations
• Fixed some issues

1.2.5

• Performance Optimization
• Added support of new option filterPosition in GridSheetConfiguration
• Fixed some issues

1.2.4

• Refactor: replace expression style fields with static-based text style BREAKING CHANGE: removed textStyleExpression — use textStyle instead

1.2.3

• Refactor: replace static color/style fields with expression-based conditional formatting API BREAKING CHANGE: removed expression, backgroundColor, fontStyle — use backgroundColorExpression and textStyleExpression instead

1.2.2

• Added dynamic table generation: tables can now be generated at runtime based on columnsCount and rowsCount.
• Added renameColumns method: allows renaming of column names and optional titles.

1.2.1

• Refactored internal auto-fill logic to reduce code duplication and improve maintainability.
• Added loadingOverlayColor option in styleConfiguration

1.2.0

• Provided support of autofill(cell drag-to-copy) feature.

1.1.9

• Fixed Undo Feature issue with formula type columns

1.1.8

• Fixed issues related to formula type
• Added ISBLANK, ISNUMBER, ISTEXT formula functions

1.1.7

• Updated example to demonstrate light and dark theme support
• Provided support of formula type cell feature.

1.1.6

• Added default norowswidget

1.1.5

• Added issue_tracker link in pubspec file

1.1.4

• Updated package description within pub.dev limits

1.1.3

• Updated example with latest code

1.1.2

• Fixed select all issue

1.1.1

• updated license

1.1.0

• Added row on hover feature.
• Added headerWrapper feature.
• Added filterWrapper feature.
• Added rowWrapper feature.

1.0.5

• Added sample example.

1.0.4

• Removed prints.

1.0.3

• Removed theming classes.

1.0.2

• Removed unrequired classes.

1.0.1

• Removed unrequired passages.

1.0.0

• Initial release of GridSheet.
• Added row and column operations.
• Added sorting, filtering, pagination, and selection support.