online icon indicating copy to clipboard operation
online copied to clipboard

issue a warning if a delete cell or page operation causes a reference error

Open ferdiga opened this issue 3 years ago • 14 comments

Is your feature request related to a problem? Please describe. Deleting a referenced cell (row/column/page) causes an error in the referencing cell. or Division by zero

in big spreadsheets this error may remain undetected until the cell is visited.

it happens usually if another person is modifying the sheet or even the original creator does not remember that the deleted cell is referenced.

Describe the solution you'd like raise an error instead of quietly allow the error to happen

Describe alternatives you've considered no chance except to visually inspect all cells very cumbersome to reconstruct a destroyed sheet, sometimes not really possible

Additional context Add any other context or screenshots about the feature request here.

ferdiga avatar Jul 14 '21 07:07 ferdiga