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

On 10/21/2025 6:42 PM, Luuk wrote:
> On 10/19/2025 8:57 PM, John Kaufmann wrote:
> > On 2025-10-19 14:47, Luuk wrote:
> > > On 10/19/2025 7:08 PM, John Kaufmann wrote:
> > > > > 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.
> > >
> > > Numbers directly followed by an ENTER, stopped the formatting (in my 
> > > short test...)
> >
> > Yes, I suspect there *is* a problem; just trying to define how to 
> > reproduce it.
>
>
> When unzipping my odt file, I do see the following in the `content.xml`:
>
> ...
> </table:table-row>
> <table:table-row>
>
> <table:table-celltable:style-name="Table1.A1"office:value-type="string">
> <text:ptext:style-name="P2">Two</text:p>
> </table:table-cell>
> <table:table-celltable:style-name="Table1.B1"office:value-type="currency"office:currency="USD"office:value="2">
> <text:ptext:style-name="P2">$2.00</text:p>
> </table:table-cell>
> </table:table-row>
> <table:table-row>
> <table:table-celltable:style-name="Table1.A1"office:value-type="string">
> <text:ptext:style-name="P2">Three</text:p>
> </table:table-cell>
> <table:table-celltable:style-name="Table1.B4"office:value-type="float"office:value="3">
> <text:ptext:style-name="P2">3</text:p>
> </table:table-cell>
> </table:table-row>
> <table:table-row>
> ....
>
> and the corresponding image of how that looks like in Write is: 
> https://ibb.co/C59PmTV1
>
> You can see the correctly formatted having: 
> 'office:value-type="currency"office:currency="USD"'
>
> and the incorrectly formatted having: 'office:value-type="float"'
>
> --
> Luuk
Formatting the column again, bu selecting the column and choosing the 
desired number format, seems to help solving the incorrectly formatted 
numbers.



--
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