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

Hi John,
To answer your questions:

I was trying to format the last col, but trying to format a previous col 
doesn't work any better.

I had no better luck experimenting with other formats (date, ...).

I had the same results when I experimented with a brand-new table.

Curiously, in the Format Number dialog box, the three icons following 
the Format Code line (green check, yellow quotation balloon, red x) are 
shaded out. That seems to be the case for all of the categories. Is this 
supposed to be?

Eric Beversluis
www.ericbeversluis.com
3x Honorable Mention--Writer's Digest Contest

On 10/19/25 1:08 PM, John Kaufmann wrote:
> 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