Version 8.2

released on March 3, 2021

Breaking Change

  • the getCode, serialize, and getRanges methods of the ranges module return range with sheet name.

Check details in the Migration article to evaluate the influence on your projects and get info on the current functionality.

Updates

We updated spreadsheet math engine, which resulted in:

  • correct functioning of multi-sheet math
  • fixing bugs related to multi-sheet math
  • global named ranges

New excel functions: second, minute, hour.

Fixes

  • ignore spaces after the operand when selecting cells for formulas
  • F2 key erases original value in live editor
  • double click and Enter logic for live editor
  • Charts: refresh legend values when source data are modified
  • conditional formats are not applied to spanned cells
  • conditional formats regression due to strict comparison
Back to top