Insert, Delete or Clear Cells in OpenOffice Calc

Delete Contents empties selected content without removing the grid position. Delete Cells removes cells and closes the gap by shifting other cells or deleting entire rows or columns. Confusing the two can detach an item name from its amount even when the worksheet still looks tidy.

Scope and safe starting point

This exercise follows the Apache OpenOffice 4.1 Calc Guide, supplemented by the official AOO416 tag (OpenOffice 4.1.6) English Help source for the cell dialogs. Documentation was checked on 23 October 2026. No native build or operating system was tested for this example; the expected arithmetic and record movements are independent checks, not screenshots or application test results. Windows/Linux English menus are used, without assuming Excel or LibreOffice keyboard behavior.

Start a new, unshared, unprotected practice spreadsheet with only its working sheet selected. Enter:

Cell	Content
A1	Item
B1	Units
A2	Paper
B2	5
A3	Toner
B3	3
A4	Folders
B4	2
D1	Total
E1	=SUM(B2:B4)

E1 should show 10. Make B3 bold so you can distinguish content from formatting. Save structure-baseline.ods, then immediately save a working copy as structure-practice.ods. Keep the baseline unchanged. Whole-row operations affect every column on that row, not merely the visible table.

Clear a value without moving a record

1. Select B3 alone, not the row heading. Choose Edit → Delete Contents.
2. In the dialog, clear Delete all, select Numbers, and clear the other categories, particularly Formats and Formulas. Confirm only after checking the selection.
3. B3 should be empty, A3 should still say Toner, and Folders should remain on row 4. E1 should be 7, because the remaining quantities are 5 and 2.
4. Type 3 back into B3. Check that its bold formatting remains and the total returns to 10.

The AOO 4.1 guide documents Backspace as removing content while preserving formatting, and Delete as opening the contents dialog. The menu route above makes the operation explicit and avoids relying on a remapped key. If editing text inside a cell, first finish or cancel that edit; removing characters within the input line is not the same operation as clearing a selected cell.

Selecting Formats instead removes format attributes while keeping cell content. Selecting Formulas can erase a calculated cell rather than its inputs. Do not choose Delete all merely to reset a quantity: it also removes formatting. See cell formatting and styles for formatting-only work.

Insert a complete record row and inspect the formula

Select row 3 by its numbered heading, then choose Insert → Rows. The new row goes above the selected row. Enter Labels in A3 and 4 in B3.

Check the full record sequence: Paper/5 at row 2, Labels/4 at row 3, Toner/3 at row 4, and Folders/2 at row 5. The total cell remains E1. Inspect its input line: the intended range now covers B2:B5, and the expected total is 14.

The official input-settings documentation says that inserting inside a reference area expands that area. This exercise inserts in its middle deliberately. Inserting adjacent to an endpoint is different: Expand references when new columns/rows are inserted affects that case, with additional range-size conditions. Do not change this application option for the exercise, and do not generalize the middle-insertion result into “every appended row enters every formula.” Inspect the actual boundaries before trusting a total.

The guide also describes inherited formatting on inserted rows. Still inspect your new cells deliberately: useful styling is not proof that the correct records or formulas moved.

Delete that row rather than leave a blank record

Right-click row heading 3, verify it is the Labels row, and choose Delete Rows. The expected sequence returns to Paper/5, Toner/3 and Folders/2 on rows 2–4. Inspect E1 and its range again; the total should return to 10 over B2:B4.

Clearing A3:B3 instead would leave an empty row in place, with Toner and Folders below it. Both actions can produce the same numeric total, so a total alone cannot tell you whether the structure is correct. Inspect labels, row positions and formula text together.

For multiple whole rows, select the required row headings before using the command. Columns follow the same structural distinction: Insert → Columns inserts to the left of the selected column, while the column-heading Delete Columns command removes whole columns. Use a separate disposable copy for column experiments, because every row in those columns is affected.

Why shifting individual cells can break a table

After restoring the original three records, put Red, Blue, Green in H2:H4 and 10, 20, 30 in I2:I4. These are paired labels and quantities; leave H5:I6 empty.

1. Select H3 only and choose Insert → Cells. Choose Shift cells down, not Entire row.
2. Inspect H2:H5: Red, an empty cell, Blue, Green. I2:I4 should still be 10, 20, 30. Blue now sits beside 30 rather than its original 20. You inserted one column’s cell, not a complete record.
3. Select the newly empty H3 and choose Edit → Delete Cells. Explicitly choose Shift cells up. The Help says this dialog remembers the previous deletion choice, so do not confirm an unchecked default.
4. Verify the original pairs Red/10, Blue/20, Green/30 are restored in H2:I4 and H5 is empty.

For horizontal movement the corresponding choices are Shift cells right when inserting and Shift cells left when deleting. These options change only the affected portion of the grid; they are not a safe substitute for whole-record edits when adjacent columns belong together.

Do not use Delete Contents on H3 in step 3: it is already empty and clearing it does not pull Blue upward. If you mistakenly delete an occupied cell, inserting a blank cell afterward cannot recover its former value.

Save, recover and diagnose

Save the working ODS, close and reopen it. Check A2:B4, total 10, its exact formula range, and the three original H:I pairs. These are reader checks still awaiting native validation. CSV cannot preserve the formulas, formatting and workbook state of this exercise.

If an edit shifts the wrong area, undo immediately in the same session and compare with the baseline. If the history is uncertain or the file has been reopened, recover from the unchanged baseline into a new working filename. Do not try repeated insert/delete operations hoping the values will line up again.

If a command is unavailable, check whether you are still editing a cell, whether the document is protected, or whether it is shared. Do not remove protection on an unfamiliar workbook or alter a real shared report to force this practice exercise through. Start a new disposable document instead. When clearing ranges, also confirm only the intended sheet is selected: the Help warns that clearing applies to every selected sheet.

A changed result is not always an error. Clearing an input legitimately changes the total. A stable total is not always success, either: a shifted label/quantity pairing may be wrong while the sum stays the same. Record identity, cell addresses and formula boundaries are the three checks to keep together.

First-party references

Full official sources retrieved on 2026-10-23:

• AOO 4.1 Calc Guide: Inserting Columns and Rows, Deleting Columns and Rows, and Removing Data from a Cell.
• AOO 4.1 Calc Guide: Input Settings Section, including middle versus adjacent insertion.
• Versioned AOO 4.1.6 Help source: Insert Cells, Delete Cells, and Deleting Contents. These are documentation files, not native execution evidence.