How to edit or modify data in OpenOffice Spreadsheet?
There are two options to edit the data in a cell.
Option 1: Double click on the desired cell that contains the data which you
want to edit.
Option 2: You can also edit the data in the Formula Bar. To do this, first click on the cell and edit the data in the formula
bar. Press the Enter key after you edit the data.