SpreadsheetView class

A spreadsheet grid built lazily (only the cells on screen exist), with the sheet's own column widths and row heights, hidden rows/columns left out, its frozen panes pinned along with the header row and row-number column, merged cells, and its text formatting. Also: a −/+ zoom pill, search highlights, row/column selection with Count/Sum/Avg and Copy, a cell's full value (with its formula, note and link) on tap. Cell borders, conditional formatting (fills, colours, data bars) and a note marker come from the file. Scrolls through the controller's verticalController/horizontalController. Serves Excel and CSV alike.

Inheritance

Constructors

SpreadsheetView({Key? key, required SpreadsheetController controller, String? emptyMessage})
Shows controller's sheet on screen.
const

Properties

controller → SpreadsheetController
The workbook to show.
final
emptyMessage → String?
Shown instead of the grid for a sheet with no cells. Defaults to DocumentViewerStrings.emptySheet.
final
hashCode → int
The hash code for this object.
no setterinherited
key → Key?
Controls how one widget replaces another widget in the tree.
finalinherited
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited

Methods

createElement() → StatefulElement
Creates a StatefulElement to manage this widget's location in the tree.
inherited
createState() → State<SpreadsheetView>
Creates the mutable state for this widget at a given location in the tree.
override
debugDescribeChildren() → List<DiagnosticsNode>
Returns a list of DiagnosticsNode objects describing this node's children.
inherited
debugFillProperties(DiagnosticPropertiesBuilder properties) → void
Add additional properties associated with the node.
inherited
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
toDiagnosticsNode({String? name, DiagnosticsTreeStyle? style}) → DiagnosticsNode
Returns a debug representation of the object that is used by debugging tools and by DiagnosticsNode.toStringDeep.
inherited
toString({DiagnosticLevel minLevel = DiagnosticLevel.info}) → String
A string representation of this object.
inherited
toStringDeep({String prefixLineOne = '', String? prefixOtherLines, DiagnosticLevel minLevel = DiagnosticLevel.debug, int wrapWidth = 65}) → String
Returns a string representation of this node and its descendants.
inherited
toStringShallow({String joiner = ', ', DiagnosticLevel minLevel = DiagnosticLevel.debug}) → String
Returns a one-line detailed description of the object.
inherited
toStringShort() → String
A short, textual description of this widget.
inherited

Operators

operator ==(Object other) → bool
The equality operator.
inherited