online
online copied to clipboard
issue a warning if a delete cell or page operation causes a reference error
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.