| Summary: | Entering the word true in a spreadsheet cell | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | kofitettey |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | ||
| Priority: | medium | ||
| Version: | unspecified | ||
| Hardware: | x86 (IA32) | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
|
Description
kofitettey
2013-11-03 22:14:57 UTC
That is intended behavior. That isn't acceptable if it is the intended behavior! If I were entering a formula then I would accept it if "true" is changed to "TRUE". In this case I am only making a list of words in cells as follows: the to true truth However, what I end up with is: the to TRUE truth That should not be intended behavior!! It *is* intended behavior, as in most cases by inserting the word 'true' (without quotation marks) in Calc the user would expect it to be related / interpreted as a boolean value. To insert a simple text, you could set the cell as text (ctrl+1 > numbers -> text category -> OK) and then insert the word in the specific cell. Or, use a single quotation mark, as in "'true" (without the double quotation marks). Regards, Ady. Thanks for the clarification Ady. I only just noticed that the MS Excel behaves the same way! |