The following instructions explain how to bypass the automatic capitalization ‘feature’ included in OpenOffice Calc.
When inputting text into a cell, if you do not want the first letter to be capitalized, start the text entry with a single quotation mark (‘).
For example, entering hello!
will result in the cell contents:
Hello!
To avoid this, enter:'hello!
resulting in cell contents:hello!