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

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






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