- Support for CSV (comma-separated values) & TSV (tab-separated values)
- Support for Office Open XML (OOXML) formats
- Create copies of existing worksheets
- Create & manipulate comments
- Set auto-filters & page breaks
- Set & calculate complex formulas
- Specify conditional formatting rules
- Set protection options introduced in Microsoft Excel XP
- Create & manipulate named ranges
- Create & render sparklines
- Add Digital Signatures
-
Create & render custom charts
-
Formula calculation engine
-
Export worksheets to SVG format
-
Read & write large spreadsheets in light-weight mode
-
Re-sample images in Excel-to-PDF conversion
-
Trace Precedents and Dependents
-
Create and manipulate Scenarios
-
Modify VBA code or Macros in the template file
-
Save ODS file in ODF 1.1 and 1.2 specifications
-
Optimize memory usage while working with large files
-
Populate spreadsheets via Smart Markers
-
Dynamically create & manipulate Pivot Tables