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.
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.
My name is Stephanie Krishnan and I'm passionate about the way that open source software and its community can help small businesses and individuals with their productivity and lives. One of the biggest arguments I get from business owners, however, is lack of support options. I decided to put together my own support blog to help people be productive at various levels with one of my favourite open source alternatives: OpenOffice.org! I do this through tutorials, downloadable templates and answers to questions from readers!
