I’m trying to type “1.0” in a cell for a table of contents I’m making and every time it keeps making it “1”.
Your question is “Why?” So answer should be “Standard” formatting was programmed to avoid decimals, if not needed. Also it is an advantage, if you can use integer as type instead of floating-point math with limited precision.
Two ways around this: If you think you use a text editor for tables, by accident named Calc you could change formatting of cells to “Text”, before you input digits, or prepend an apostrophe libe '1.0 Tjen your characters are not read as numbers.
.
The (usually) better way is to change formatting of a cell to show a fixed number of decimals.
.
You may find “format cells” in the context menu of a selection.
.
Details in help:
https://help.libreoffice.org/latest/en-US/text/shared/01/05020300.html?&DbPAR=SHARED&System=UNIX
2 Likes
I changed it to “text” in cell format, now it lets me put “1.0”, “2.0”, etc. in the cells.
Thanks!