Hi Eric,
On 2025-10-19 10:57, Eric Beversluis wrote:
Using LO 25.2.6.2 (X86_64) on Fedora 42 Workstation edition.
I set up a table.
Selected a column.
Went to 'Table>Number recognition' and turned it on
This order implies you intend to turn on Number Recognition per column, so a
first clarification [which you may not need]: Number Recognition is a mode
applying to the whole table, not to cells, rows or columns. [Perhaps this
operational distinction could be made clear in the UI (in the menu
presentation?), but that is for future UX-design consideration.]
Selected 'Number format>Currency>-$1,234.00'
This formatting command *does* apply to cells, rows or columns, so if your
column selection (from the second step) is still engaged, then you *should* get
column formatting.
The top cell in the column reflected this change; none of the other cells
reflected it when I entered numbers
I tried resetting the Number format several times with no success, even after
first 'clear[ing] format'
I tried adding a new column, selecting it before entering anything, and made
the same formatting change
None of the numbers I entered received the currency setting.
How do I get the whole column to show as currency?
Your order of steps suggests that the Currency column is the last column; I'm
trying to understand if this quirky behavior is related to the column position.
[Of course column order should not be relevant.]
(1) Were you in all cases formatting the table's *last* column as Currency?
What happens if you define a table of 5 columns, and apply your Currency
formatting to an *interior* column?
(2) What happens if you try different formats, like Date, Time, Percentage? Do
any of those formats apply to the whole column?
John
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
