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