Product Updates - July 18, 2020

New features

  • :heavy_plus_sign: Add rows widget : A new widget has been added to the bottom of worksheets allowing you to easily append new rows, up to 100 at a time.

    image

  • :warning: Formula error messages: When a cell with a formula has an errors, Spreadsheet.com now shows a red dog-ear icon and more information about the error when you hover over the cell.

    image

Fixes

  • 001805: Changing a Related row column to a Related row lookup column now behaves as expected.

  • 001949: Auto-filling formulas by dragging formula cell handles now correctly takes worksheet sorting and filtering into account when determining relative cell and column references. Similarly, copying and pasting formulas now takes worksheet sorting and filtering into account as well when determining relative cell and column references.

  • 001928: Cell and range references in formulas are now adjusted properly when a multi-row insertion is immediately followed by a multi-row delete or undo.

  • 001931: Row insertions immediately followed by formula updates now function as expected.

1 Like