Uses of Package
io.keikai.model

Packages that use io.keikai.model

Package	Description
io.keikai.api	Keikai Spreadsheet API classes.
io.keikai.api.model	Keikai Spreadsheet Model API classes.
io.keikai.api.model.impl	Keikai Spreadsheet Model API implementation classes, Internal use only
io.keikai.importer
io.keikai.model	Keikai Spreadsheet Internal Book Model classes.
io.keikai.model.chart	Keikai Spreadsheet Internal Book Model classes.
io.keikai.model.impl	Keikai Spreadsheet Internal Book Model Implementation classes.
io.keikai.model.impl.chart	Keikai Spreadsheet Internal Book Model Implementation classes.
io.keikai.model.impl.html	The exporter that convert Keikai Spreadsheet to HTML.
io.keikai.model.impl.pdf	The exporter that convert Keikai Spreadsheet to PDF.
io.keikai.model.impl.sys	Keikai Spreadsheet Internal Book Model Implementation classes.
io.keikai.model.impl.sys.formula	Keikai Spreadsheet Internal Book Model Implementation classes.
io.keikai.model.sys.format	Keikai Spreadsheet Internal Book Model Engines classes.
io.keikai.model.sys.formula	Keikai Spreadsheet Internal Book Model Engines classes.
io.keikai.model.sys.input	Keikai Spreadsheet Internal Book Model Engines classes.
io.keikai.model.util	Keikai Spreadsheet Internal Book Model Utilities classes.
io.keikai.range	Keikai Spreadsheet Internal Range API classes.
io.keikai.range.impl	Keikai Spreadsheet Internal Range API Implementation classes.
io.keikai.range.impl.autofill	Keikai Spreadsheet Internal Range API Implementation classes.
io.keikai.range.impl.imexp	Keikai Spreadsheet Internal Range API Implementation classes.
io.keikai.ui	Defines UI Component class of Keikai Spreadsheet
io.keikai.ui.event	Events of Keikai Spreadsheet UI Component.
io.keikai.ui.impl	Classes for implementing Keikai Spreadsheet UI Components (implementation only).
io.keikai.ui.impl.ua	Classes that doing system user action control on Keikai Spreadsheet UI Components.
io.keikai.ui.impl.undo	Classes that doing system undoable action control on Keikai Spreadsheet UI Components.
io.keikai.ui.sys	Classes that doing system control on Keikai Spreadsheet UI Components.
io.keikaiex.formula	Classes bridging Keikai Spreadsheet formula functions to ZK EL functions.
io.keikaiex.model.sys
io.keikaiex.ui.dialog
io.keikaiex.ui.impl
io.keikaiex.ui.impl.ua	Classes that doing system user action control on Keikai Spreadsheet UI Components.
io.keikaiex.ui.widget	Classes used to implement extended Keikai Spreadsheet UI Component(implementation only).
io.keikaiex.util	Utility classes used to handle extended Keikai Spreadsheet UI Component(implementation only).

Classes in io.keikai.model used by io.keikai.api

Class and Description
CellRegion An immutable object that represents a block of cells with 4 indexes which are first and last row index, first and last column index.
InvalidFormulaException The exception is thrown when encountering an invalid formula.
InvalidModelOpException This exception is thrown when you perform an unreasonable operation on the model.

Classes in io.keikai.model used by io.keikai.api.model

Class and Description
SBook The root of Spreadsheet's data model which contains sheets.
SDataValidation.AlertStyle
SDataValidation.OperatorType
SDataValidation.ValidationType
SSheet A sheet of a book.

Classes in io.keikai.model used by io.keikai.api.model.impl

Class and Description
SAutoFilter.FilterOp
SBook The root of Spreadsheet's data model which contains sheets.
SBorder.BorderType The border type
SCellStyle Represent style information e.g.
SCellStyle.Alignment The horizontal alignment
SCellStyle.VerticalAlignment The vertical alignment
SChart.ChartGrouping
SChart.ChartLegendPosition
SChart.ChartType
SDataValidation This class stores the restrictions on what data can or should be entered in a cell.
SFill.FillPattern The fill pattern
SFont Represents a font used in cells.
SFont.Boldweight
SFont.TypeOffset
SFont.Underline
SHyperlink.HyperlinkType
SPicture.Format
SSheet A sheet of a book.

Classes in io.keikai.model used by io.keikai.importer

Class and Description
SAutoFilter Contains autofilter's setting.
SAutoFilter.FilterOp
SBook The root of Spreadsheet's data model which contains sheets.
SBorder Border object
SBorder.BorderType The border type
SCell Represent a cell of a sheet in a Spreadsheet.
SCellStyle Represent style information e.g.
SCFValueObject Conditional Formatting value object.
SCFValueObject.CFValueObjectType
SChart Represents a chart in a sheet.
SChart.ChartGrouping
SColorFilter Color filter
SColorScale
SConditionalFormatting Conditional Formatting
SConditionalFormattingRule.RuleOperator
SConditionalFormattingRule.RuleTimePeriod
SConditionalFormattingRule.RuleType
SCustomFilters
SDataBar Condiditional Formatting of "dataBar" type.
SDataValidation.AlertStyle
SDataValidation.OperatorType
SDataValidation.ValidationType
SDynamicFilter
SExtraStyle Extra embedded style for STable and SConditonalFormatting.
SFill.FillPattern The fill pattern
SFont Represents a font used in cells.
SFont.TypeOffset
SFont.Underline
SHyperlink.HyperlinkType
SIconSet
SIconSet.IconSetType
SPrintSetup.PaperSize
SRichText A rich text can have multiple segments which have different fonts for each one in a cell.
SRow A row of a sheet.
SSheet A sheet of a book.
STable Table
STableColumn.STotalsRowFunction
STableStyle Table Style.
STableStyleElem Table style element.
STop10Filter
ViewAnchor Represent a anchor position by its left-top cell index, width, height, x and y offset within the cell, or a right-bottom anchor position by its right-bottom cell index with 0 width and height.

Classes in io.keikai.model used by io.keikai.model

Class and Description
CellRegion An immutable object that represents a block of cells with 4 indexes which are first and last row index, first and last column index.
CellStyleHolder the style holder interface
ErrorValue An error result of a evaluated formula.
FormulaContent Indicate that the object has formula content
InvalidModelOpException This exception is thrown when you perform an unreasonable operation on the model.
ModelEvent The event will be sent when there is an operation performed on a book model.
ModelEventListener A listener to handle ModelEvent.
PasteOption This class contains various paste options used for SSheet.pasteCell(SheetRegion, CellRegion, PasteOption).
PasteOption.PasteOperation
PasteOption.PasteType
SAutoFilter Contains autofilter's setting.
SAutoFilter.FilterOp
SAutoFilter.NFilterColumn A filter column contains information for filtering, e.g.
SBook The root of Spreadsheet's data model which contains sheets.
SBookSeries It contains multiple SBook objects so that formulas in them can reference to cells of another book.
SBookSeriesBuilder A utility class that build a book series that allow external book references can work.
SBorder Border object
SBorder.BorderType The border type
SBorderLine
SCell Represent a cell of a sheet in a Spreadsheet.
SCell.CellType
SCellStyle Represent style information e.g.
SCellStyle.Alignment The horizontal alignment
SCellStyle.VerticalAlignment The vertical alignment
SCFValueObject Conditional Formatting value object.
SCFValueObject.CFValueObjectType
SChart Represents a chart in a sheet.
SChart.BarDirection
SChart.ChartGrouping
SChart.ChartLegendPosition
SChart.ChartType
SChartAxis Represent an axis in SChart.
SChartAxis.SChartAxisType
SColor A color which might relate to a text or a border.
SColorFilter Color filter
SColorScale
SColumn A column of a sheet.
SColumnArray It stores first and last column index of a group of column that has same width and cell style.
SComment A comment is some texts written by a user which is separated from text of a cell.
SConditionalFormatting Conditional Formatting
SConditionalFormattingRule
SConditionalFormattingRule.RuleOperator
SConditionalFormattingRule.RuleTimePeriod
SConditionalFormattingRule.RuleType
SCustomFilter
SCustomFilters
SDataBar Condiditional Formatting of "dataBar" type.
SDataValidation This class stores the restrictions on what data can or should be entered in a cell.
SDataValidation.AlertStyle
SDataValidation.OperatorType
SDataValidation.ValidationType
SDynamicFilter
SExtraStyle Extra embedded style for STable and SConditonalFormatting.
SFill Fill pattern and colors
SFill.FillPattern The fill pattern
SFont Represents a font used in cells.
SFont.Boldweight
SFont.TypeOffset
SFont.Underline
SFooter The text in the footer.
SHeader The text in the header.
SheetRegion Indicates a immutable region of cells in a sheet.
SHyperlink A hyperlink of a cell.
SHyperlink.HyperlinkType
SIconSet
SIconSet.IconSetType
SName A named range (or defined name) which refer to a region.
SNamedStyle Cell Style referred via a name.
SPicture A picture in a sheet.
SPicture.Format
SPictureData Picture data in a picture.
SPrintSetup Store various setting for printing.
SPrintSetup.PaperSize
SRichText A rich text can have multiple segments which have different fonts for each one in a cell.
SRichText.Segment
SRow A row of a sheet.
SSheet A sheet of a book.
SSheet.SheetVisible
SSheetProtection
SSheetViewInfo Store those visual statuses of a sheet, e.g.
STable Table
STableColumn Table column
STableColumn.STotalsRowFunction
STableStyle Table Style.
STableStyleElem Table style element.
STableStyleInfo Table style info.
STop10Filter
ViewAnchor Represent a anchor position by its left-top cell index, width, height, x and y offset within the cell, or a right-bottom anchor position by its right-bottom cell index with 0 width and height.

Classes in io.keikai.model used by io.keikai.model.chart

Class and Description
FormulaContent Indicate that the object has formula content
SChart Represents a chart in a sheet.

Classes in io.keikai.model used by io.keikai.model.impl

Class and Description
CellRegion An immutable object that represents a block of cells with 4 indexes which are first and last row index, first and last column index.
CellStyleHolder the style holder interface
ErrorValue An error result of a evaluated formula.
FormulaContent Indicate that the object has formula content
ModelEvent The event will be sent when there is an operation performed on a book model.
ModelEventListener A listener to handle ModelEvent.
PasteOption This class contains various paste options used for SSheet.pasteCell(SheetRegion, CellRegion, PasteOption).
SAutoFilter Contains autofilter's setting.
SAutoFilter.FilterOp
SAutoFilter.NFilterColumn A filter column contains information for filtering, e.g.
SBook The root of Spreadsheet's data model which contains sheets.
SBookSeries It contains multiple SBook objects so that formulas in them can reference to cells of another book.
SBookSeriesBuilder A utility class that build a book series that allow external book references can work.
SBorder Border object
SBorder.BorderType The border type
SBorderLine
SCell Represent a cell of a sheet in a Spreadsheet.
SCell.CellType
SCellStyle Represent style information e.g.
SCellStyle.Alignment The horizontal alignment
SCellStyle.VerticalAlignment The vertical alignment
SCFValueObject Conditional Formatting value object.
SCFValueObject.CFValueObjectType
SChart Represents a chart in a sheet.
SChart.BarDirection
SChart.ChartGrouping
SChart.ChartLegendPosition
SChart.ChartType
SChartAxis Represent an axis in SChart.
SChartAxis.SChartAxisType
SColor A color which might relate to a text or a border.
SColorFilter Color filter
SColorScale
SColumn A column of a sheet.
SColumnArray It stores first and last column index of a group of column that has same width and cell style.
SComment A comment is some texts written by a user which is separated from text of a cell.
SConditionalFormatting Conditional Formatting
SConditionalFormattingRule
SConditionalFormattingRule.RuleOperator
SConditionalFormattingRule.RuleTimePeriod
SConditionalFormattingRule.RuleType
SConditionalStyle Extra embedded style for SConditonalFormatting.
SCustomFilter
SCustomFilters
SDataBar Condiditional Formatting of "dataBar" type.
SDataValidation This class stores the restrictions on what data can or should be entered in a cell.
SDataValidation.AlertStyle
SDataValidation.OperatorType
SDataValidation.ValidationType
SDynamicFilter
SExtraStyle Extra embedded style for STable and SConditonalFormatting.
SFill Fill pattern and colors
SFill.FillPattern The fill pattern
SFont Represents a font used in cells.
SFont.Boldweight
SFont.TypeOffset
SFont.Underline
SFooter The text in the footer.
SHeader The text in the header.
SheetRegion Indicates a immutable region of cells in a sheet.
SHyperlink A hyperlink of a cell.
SHyperlink.HyperlinkType
SIconSet
SIconSet.IconSetType
SName A named range (or defined name) which refer to a region.
SNamedStyle Cell Style referred via a name.
SPicture A picture in a sheet.
SPicture.Format
SPictureData Picture data in a picture.
SPrintSetup Store various setting for printing.
SPrintSetup.PaperSize
SRichText A rich text can have multiple segments which have different fonts for each one in a cell.
SRichText.Segment
SRow A row of a sheet.
SSheet A sheet of a book.
SSheet.SheetVisible
SSheetProtection
SSheetViewInfo Store those visual statuses of a sheet, e.g.
STable Table
STableColumn Table column
STableColumn.STotalsRowFunction
STableStyle Table Style.
STableStyleElem Table style element.
STableStyleInfo Table style info.
STop10Filter
ViewAnchor Represent a anchor position by its left-top cell index, width, height, x and y offset within the cell, or a right-bottom anchor position by its right-bottom cell index with 0 width and height.

Classes in io.keikai.model used by io.keikai.model.impl.chart

Class and Description
FormulaContent Indicate that the object has formula content
SChart Represents a chart in a sheet.

Classes in io.keikai.model used by io.keikai.model.impl.html

Class and Description
CellRegion An immutable object that represents a block of cells with 4 indexes which are first and last row index, first and last column index.
SBook The root of Spreadsheet's data model which contains sheets.
SheetRegion Indicates a immutable region of cells in a sheet.
SSheet A sheet of a book.

Classes in io.keikai.model used by io.keikai.model.impl.pdf

Class and Description
CellRegion An immutable object that represents a block of cells with 4 indexes which are first and last row index, first and last column index.
SBook The root of Spreadsheet's data model which contains sheets.
SCell Represent a cell of a sheet in a Spreadsheet.
SChart Represents a chart in a sheet.
SFont Represents a font used in cells.
SFooter The text in the footer.
SHeader The text in the header.
SheetRegion Indicates a immutable region of cells in a sheet.
SPicture A picture in a sheet.
SPrintSetup Store various setting for printing.
SSheet A sheet of a book.
ViewAnchor Represent a anchor position by its left-top cell index, width, height, x and y offset within the cell, or a right-bottom anchor position by its right-bottom cell index with 0 width and height.

Classes in io.keikai.model used by io.keikai.model.impl.sys

Class and Description
SBook The root of Spreadsheet's data model which contains sheets.
SBookSeries It contains multiple SBook objects so that formulas in them can reference to cells of another book.
SCell Represent a cell of a sheet in a Spreadsheet.
SCell.CellType
SColor A color which might relate to a text or a border.
SRichText A rich text can have multiple segments which have different fonts for each one in a cell.
STableStyle Table Style.

Classes in io.keikai.model used by io.keikai.model.impl.sys.formula

Class and Description
SBook The root of Spreadsheet's data model which contains sheets.
SheetRegion Indicates a immutable region of cells in a sheet.
SSheet A sheet of a book.
STable Table

Classes in io.keikai.model used by io.keikai.model.sys.format

Class and Description
SBook The root of Spreadsheet's data model which contains sheets.
SCell Represent a cell of a sheet in a Spreadsheet.
SColor A color which might relate to a text or a border.
SRichText A rich text can have multiple segments which have different fonts for each one in a cell.
STableStyle Table Style.

Classes in io.keikai.model used by io.keikai.model.sys.formula

Class and Description
SBook The root of Spreadsheet's data model which contains sheets.
SCell Represent a cell of a sheet in a Spreadsheet.
SheetRegion Indicates a immutable region of cells in a sheet.
SSheet A sheet of a book.
STable Table

Classes in io.keikai.model used by io.keikai.model.sys.input

Class and Description
SCell.CellType

Classes in io.keikai.model used by io.keikai.model.util

Class and Description
SBorder.BorderType The border type
SCell Represent a cell of a sheet in a Spreadsheet.
SCellStyle Represent style information e.g.
SCellStyle.Alignment The horizontal alignment
SCellStyle.VerticalAlignment The vertical alignment
SFill.FillPattern The fill pattern
SFont Represents a font used in cells.
SFont.Boldweight
SFont.TypeOffset
SFont.Underline
SRichText A rich text can have multiple segments which have different fonts for each one in a cell.

Classes in io.keikai.model used by io.keikai.range

Class and Description
CellRegion An immutable object that represents a block of cells with 4 indexes which are first and last row index, first and last column index.
SAutoFilter Contains autofilter's setting.
SAutoFilter.FilterOp
SBook The root of Spreadsheet's data model which contains sheets.
SBorder.BorderType The border type
SCellStyle Represent style information e.g.
SChart Represents a chart in a sheet.
SChart.ChartGrouping
SChart.ChartLegendPosition
SChart.ChartType
SDataValidation This class stores the restrictions on what data can or should be entered in a cell.
SDataValidation.AlertStyle
SDataValidation.OperatorType
SDataValidation.ValidationType
SFont Represents a font used in cells.
SFont.Boldweight
SFont.TypeOffset
SFont.Underline
SheetRegion Indicates a immutable region of cells in a sheet.
SHyperlink A hyperlink of a cell.
SHyperlink.HyperlinkType
SPicture A picture in a sheet.
SPicture.Format
SSheet A sheet of a book.
SSheetProtection
ViewAnchor Represent a anchor position by its left-top cell index, width, height, x and y offset within the cell, or a right-bottom anchor position by its right-bottom cell index with 0 width and height.

Classes in io.keikai.model used by io.keikai.range.impl

Class and Description
CellRegion An immutable object that represents a block of cells with 4 indexes which are first and last row index, first and last column index.
CellStyleHolder the style holder interface
PasteOption This class contains various paste options used for SSheet.pasteCell(SheetRegion, CellRegion, PasteOption).
SAutoFilter Contains autofilter's setting.
SAutoFilter.FilterOp
SBook The root of Spreadsheet's data model which contains sheets.
SBorder.BorderType The border type
SCell Represent a cell of a sheet in a Spreadsheet.
SCell.CellType
SCellStyle Represent style information e.g.
SCellStyle.Alignment The horizontal alignment
SCellStyle.VerticalAlignment The vertical alignment
SChart Represents a chart in a sheet.
SChart.ChartGrouping
SChart.ChartLegendPosition
SChart.ChartType
SConditionalFormattingRule.RuleOperator
SConditionalStyle Extra embedded style for SConditonalFormatting.
SCustomFilter
SDataValidation This class stores the restrictions on what data can or should be entered in a cell.
SDataValidation.AlertStyle
SDataValidation.OperatorType
SDataValidation.ValidationType
SFill.FillPattern The fill pattern
SFont Represents a font used in cells.
SFont.Boldweight
SFont.TypeOffset
SFont.Underline
SheetRegion Indicates a immutable region of cells in a sheet.
SHyperlink A hyperlink of a cell.
SHyperlink.HyperlinkType
SName A named range (or defined name) which refer to a region.
SPicture A picture in a sheet.
SPicture.Format
SSheet A sheet of a book.
SSheetProtection
STable Table
ViewAnchor Represent a anchor position by its left-top cell index, width, height, x and y offset within the cell, or a right-bottom anchor position by its right-bottom cell index with 0 width and height.

Classes in io.keikai.model used by io.keikai.range.impl.autofill

Class and Description
CellRegion An immutable object that represents a block of cells with 4 indexes which are first and last row index, first and last column index.
SCell Represent a cell of a sheet in a Spreadsheet.
SSheet A sheet of a book.

Classes in io.keikai.model used by io.keikai.range.impl.imexp

Class and Description
ErrorValue An error result of a evaluated formula.
SAutoFilter Contains autofilter's setting.
SAutoFilter.FilterOp
SBook The root of Spreadsheet's data model which contains sheets.
SBorder Border object
SBorder.BorderType The border type
SCell Represent a cell of a sheet in a Spreadsheet.
SCellStyle Represent style information e.g.
SCellStyle.Alignment The horizontal alignment
SCellStyle.VerticalAlignment The vertical alignment
SCFValueObject Conditional Formatting value object.
SCFValueObject.CFValueObjectType
SChart Represents a chart in a sheet.
SChart.BarDirection
SChart.ChartGrouping
SChart.ChartLegendPosition
SChart.ChartType
SColor A color which might relate to a text or a border.
SColorFilter Color filter
SColorScale
SColumnArray It stores first and last column index of a group of column that has same width and cell style.
SConditionalFormatting Conditional Formatting
SConditionalFormattingRule
SConditionalFormattingRule.RuleOperator
SConditionalFormattingRule.RuleTimePeriod
SConditionalFormattingRule.RuleType
SCustomFilters
SDataBar Condiditional Formatting of "dataBar" type.
SDataValidation.AlertStyle
SDataValidation.OperatorType
SDataValidation.ValidationType
SDynamicFilter
SExtraStyle Extra embedded style for STable and SConditonalFormatting.
SFill.FillPattern The fill pattern
SFont Represents a font used in cells.
SFont.Boldweight
SFont.TypeOffset
SFont.Underline
SheetRegion Indicates a immutable region of cells in a sheet.
SHyperlink.HyperlinkType
SIconSet
SIconSet.IconSetType
SNamedStyle Cell Style referred via a name.
SPicture.Format
SPrintSetup.PaperSize
SRichText A rich text can have multiple segments which have different fonts for each one in a cell.
SRow A row of a sheet.
SSheet A sheet of a book.
STable Table
STableStyle Table Style.
STableStyleElem Table style element.
STop10Filter
ViewAnchor Represent a anchor position by its left-top cell index, width, height, x and y offset within the cell, or a right-bottom anchor position by its right-bottom cell index with 0 width and height.

Classes in io.keikai.model used by io.keikai.ui

Class and Description
EventQueueModelEventListener A model event listener that listen model event through event queue (not from model directly).
ModelEvent The event will be sent when there is an operation performed on a book model.
ModelEventListener A listener to handle ModelEvent.
SBook The root of Spreadsheet's data model which contains sheets.
SSheet A sheet of a book.

Classes in io.keikai.model used by io.keikai.ui.event

Class and Description
SSheet A sheet of a book.

Classes in io.keikai.model used by io.keikai.ui.impl

Class and Description
SBook The root of Spreadsheet's data model which contains sheets.
SCell Represent a cell of a sheet in a Spreadsheet.
SCellStyle Represent style information e.g.
SCellStyle.Alignment The horizontal alignment
SConditionalStyle Extra embedded style for SConditonalFormatting.
SFont Represents a font used in cells.
SSheet A sheet of a book.
STable Table

Classes in io.keikai.model used by io.keikai.ui.impl.ua

Class and Description
SAutoFilter Contains autofilter's setting.

Classes in io.keikai.model used by io.keikai.ui.impl.undo

Class and Description
CellRegion An immutable object that represents a block of cells with 4 indexes which are first and last row index, first and last column index.
SCell Represent a cell of a sheet in a Spreadsheet.
SCell.CellType
SCellStyle Represent style information e.g.
SSheet A sheet of a book.

Classes in io.keikai.model used by io.keikai.ui.sys

Class and Description
SCellStyle Represent style information e.g.
SChart Represents a chart in a sheet.
SConditionalStyle Extra embedded style for SConditonalFormatting.
SPicture A picture in a sheet.
SSheet A sheet of a book.

Classes in io.keikai.model used by io.keikaiex.formula

Class and Description
SBook The root of Spreadsheet's data model which contains sheets.
SheetRegion Indicates a immutable region of cells in a sheet.
STable Table

Classes in io.keikai.model used by io.keikaiex.model.sys

Class and Description
SBook The root of Spreadsheet's data model which contains sheets.
SCell Represent a cell of a sheet in a Spreadsheet.
STableStyle Table Style.

Classes in io.keikai.model used by io.keikaiex.ui.dialog

Class and Description
SAutoFilter Contains autofilter's setting.
SAutoFilter.FilterOp
SAutoFilter.NFilterColumn A filter column contains information for filtering, e.g.

Classes in io.keikai.model used by io.keikaiex.ui.impl

Class and Description
SCellStyle Represent style information e.g.
SConditionalStyle Extra embedded style for SConditonalFormatting.
SSheet A sheet of a book.

Classes in io.keikai.model used by io.keikaiex.ui.impl.ua

Class and Description
SAutoFilter.FilterOp

Classes in io.keikai.model used by io.keikaiex.ui.widget

Class and Description
SChart Represents a chart in a sheet.
SPicture A picture in a sheet.
SSheet A sheet of a book.

Classes in io.keikai.model used by io.keikaiex.util

Class and Description
SChart Represents a chart in a sheet.