Log in

View Full Version : Spreadsheet entry


V34
Feb 2, 2010, 07:57 AM
Filling in spreadsheets: the word true always enters as TRUE although it is entered in lower case. This does not happen with any other word.

cmeeks
Feb 2, 2010, 02:57 PM
It appears in all caps in Excel and OpenOffice.org
Because "TRUE" is a Boolean operators and spreadsheets use Boolean operators the case is always set to upper case because the Boolean Operator needs to be upper case. The same applies to "FALSE"