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.