Published August 19, 2019
| Version v190820
Software
Open
SchildCode/EpXL v190820
Authors/Creators
Description
Changes in this release
Solved 3 issues that were reported, together with other improvements:
- Issue #1: EpXL can now store huge matrices (Matrix:TwoDimension object) containing more elements than the maximum number of columns in Excel (16384). Instead of storing each matrix element in separate spreadsheet cell, each spreadsheet cell now stores a whole matrix row as a string of semicolon-separated values in row-major order. Thus a 1010 matrix is stored in 10 spreadsheet cells, and EpXL can hypothetically store matrices up to a maximum of 16384 rows 16384 columns (assuming single digit elements, as a spreadsheet cell can store string of maximum 32768 characters).
- Issue #2: More robust epJSON export for objects with extended groups.
- Issue with slow epJSON export: Is now much faster, and memory overhead is reduced.
- Smarter algorithm that automatically corrects for incorrect choices, such as 'Autosize' vs 'Autocalculate'
- More robust import of dates: Date strings are now stored unchanged as a string in the input spreadsheet, not converted to Excel dates.
- Minor improvements to epJSON schema import.
- To download just the EpXL spreadsheet file (not the readme etc.), go to the main GitHub page for EpXL (https://github.com/SchildCode/EpXL), click on the file EpXL_vXXXXX.xlsb, and click download.
Files
SchildCode/EpXL-v190820.zip
Files
(1.5 MB)
| Name | Size | Download all |
|---|---|---|
|
md5:02fbdb15bff672fc0e05de3386987358
|
1.5 MB | Preview Download |
Additional details
Related works
- Is supplement to
- https://github.com/SchildCode/EpXL/tree/v190820 (URL)