Re: [libreoffice-users] Problem formatting table column as currency

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: users+unsubscribe@global.libreoffice.org
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