-
Notifications
You must be signed in to change notification settings - Fork 15
Feature Catalog
Raphael Stoeckli edited this page Oct 12, 2018
·
3 revisions
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 |