v4.0 [Feb 4, 2017]
- Pivot tables (XLS and XLSX files).
- Import web pages.
- Import JSON streams.
- PDF Encryption.
- Chart anti-aliasing.
- More beautiful charts (for instance, rounded up scales).
- Effects API (blur, glow, shadow, reflection, soft edges, material, camera).
- Save as XLSB files. Use XLSB files as templates and preserve anything in them including objects not currently supported by xlsgen.
- Excel 2016 charts.
- Excel 2016 compatibility and support for the 5 new functions.
- Security update : libPNG updated to close 3 vulnerabilities.
- Ability to decrypt password-protected XLS files whether they are encrypted with XOR or RC4.
- Improved style management.
- Gradient fill in cells (XLS read-only, XLSX, XLSB).
- Support for trigonometric functions in the calculation engine.
- Fuzzy string matching.
- Form controls.
- VBA macro association for pictures, text boxes, vector shapes and charts.