Feature Catalog

PicoXLSX covers currently the following features of Excel:

Feature	Notes / Limitations
Multiple, named worksheets
Support of cell addresses and coordinates	Address: e.g. "F22"; Coordinate: e.g. 5,21 (zero-based for F and 22)
Cells as values	All native datatypes of Excel: Numeric, Text, Boolean, Date
Cells as formulas	The "frontend" notation like FLOOR is not supported. Supported is only the "backend" notation (in this case ROUNDDOWN instead of FLOOR)
Most important formulas as functions	Average, Ceil, Floor, Max, Min, Median, Round, Sum, VLookup
Support of ranges	Defined struct; Values and formulas can be inserted as lists as well
Support of address types	Types: RC, $RC, R$C, $R$C
Locking of cells
Hiding of rows
Hiding of columns
Definition of column width	Range from 0 to 255 units
Definition of row height	Range from 0 to 409.5 units
Protection of worksheets	Full support of all possible protection states (e.g. only prevent formatting of cells)
Password protection of worksheets
Protection of workbooks	Protection of window and structure
Password protection of workbook	Note: The encryption of workbooks is not supported yet
Auto-filters on columns
Support of cell merging
Support of cell selection	The cursor will be on the selected cells when opening the file
Attaching of styles to cells	See styling support
Extensive styling support	All defined parts by Excel: Border, CellXf, Fill, Font, NumberFormat
Most important styles as functions	Bold, Italic, BoldItalic, Underline, DoubleUnderline, Strike, RoundFormat, BorderFrame, BorderFrameHeader, MergeCellStyle, DateFormat
Support of Meta-data	E.g. Author, CreationDate or Organization

Important utility functions are:

Feature	Notes / Limitations
Automatic jump to the next row or colum after inserting a value or formula	Default is column-to-column
Save workbook as file or stream
Save and SaveAs function
Save workbook asynchronous	Available for file and stream
Automatic organization of Styles	Internal handling
Appending of style components
Automatic data type detection	When adding a value to a cell
Automatic application of the necessary style	E.g. for DateTime values or merged cells
Sanitizing of worksheet names