To verify that Delete Contents works properly - delete formula.

Expected results

New a spreadsheet.

New spreadsheet is created.

Input contents (including normal text, numbers, date, time, formula, etc.) into some cells.

Contents should be input properly.

Create cell comments for some of the cells mentioned above.

Cell comments should be created properly.

Change text and cell properties for some of the cells mentioned above.

Properties should be changed properly.

Insert some objects (drawing object, graphic, chart, etc.) into the sheet.

Objects should be inserted.

Select a range that covers some input data and some of inserted objects.

e.g.

Delete contents of selected cells.

1. via main menu (Edit -) Delete Contents...).

2. or via context menu (right-click -) Delete Contents...).

Delete Contents dialog opens.

Select 'Formula' and deselect other options, then click OK button.

Only formulas in selected range are deleted, others should be kept. Contents and objects out of selected range should not be impacted.

Undo then redo.

Undo and redo should perform properly.