Version 5.0

released on September 26, 2017

New Features

• extended export to Excel:
  • export/import of named ranges
  • export of particular sheets
• loading CSV data
• Sheet selection dialog during export to Excel
• getSheetData API to access data and ranges on all sheets

Updates

• onSheetAdd event
• confirmation dialog when several non empty cells are merged
• load multiple sheets as array

Fixes

• using column wrap on columns with formulas
• using tab with liveEditor
• regression in column size saving
• isColumnVisible and isRowHidden API
• hideHeaders and hideGridlines hide related entity when called
• math parsing tests
• parsing math for columns
• saving sizes of hidden columns
• restoring scroll state after column|row operations
• string usage in conditional format
• regression in hotkeys handling
• regression in export to Excel
• copy-paste empty cells

Back to top