How OpenOffice.org Calc Treats Your Input
OpenOffice.org Calc uses an elaborate set of rules to determine how to classify and display the information you store inside a worksheet. Most of those rules are fairly straightforward, and as long as you properly set the operating system’s local settings for date and money formatting, whatever you type or paste ought to be interpreted in the right way.
The following sections explain how OpenOffice.org Calc treats each type of data. Read them if you want to understand why your input is being interpreted, displayed, and printed the way it is. You will also pick up tips on forcing OpenOffice.org Calc to interpret your input in the way you think is correct.
Text
Entering text into a cell is as straightforward ...
Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
