If you are looking for the feature in OpenOffice Calc that automatically fills in cell values based on previously entered values in the same column, this is something that is called AutoInput in OpenOffice Calc. In Microsoft Office Excel, this is called AutoFill.
You can see this in action here:
In the above illustration, I only type the ‘P’ and the rest of the word Pears is filled in for me. Usually the autofilling text is completed alphabetically (so Pears comes before Pineapples), however if I type in ‘i’ after ‘P’, then ‘Pineapple’ will appear.
Sometimes when working in any program we accidentally switch off features that we use, and are not sure how to turn them back on again.
If you have accidentally turned off this feature, then simply go to Tools –> Cell Contents, and ensure that there is a tick next to AutoInput.