I’m trying to make a table in LibreOffice Writer 126.96.36.199 on Pop_OS. I want the numbers to have thousands separators. In one cell it just acts like text and I have no trouble adding commas as desired. In another cell of the table it is automatically eliminating the comma every time I try to type it. I know how to handle this in Calc. I can’t find any documentation on how this works in Writer. The closest I could find is a help page for Writer that says “Choose Tools - Options - LibreOffice Writer - Table, and select or clear the Number recognition check box.” I unchecked it but it didn’t help. The same help page also claimed that one could right-click the table’s cell to control Number Recognition but I see no such option.
Did you select one of the tables styles (Default Style, Academic, Box List x…, Elegant,…) when creating the table in Writer? If yes - which one? Background of the question: These tables do have predefined formatting of their cells - e.g. Academic style table has Text formatting for row and column headers and Number formatting for all other cells as per default, while the Default Style has Text formatting for all of its cells.
To change the format: Select one or more cells and go to
Table -> Number Format and define the format of your cells (quite similar to Calc).
Number formatting in TextTable is a mess. However, there is a way, but strangely not via the context menu of a CellRange or of single cells, but via the main menu item
You may insert this submenu item also to the mentioned context menu via
Anyway you need to know a bit about NumberFormat codes to make use of the feature.
Otherwise you can enter anything looking like a number as a text if you make sure that for your table the option
>Table>Number Recognition is disabled completely (all cells).
(By the way: The usage of the comma as a group separator for numbers is explicitly deprecated by international standards.)
thanks so much! I missed that item on the menu. Was mostly looking under the Format menu.