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