released on March 3, 2021
- 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.
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.
Back to top
- 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