https://bugs.documentfoundation.org/show_bug.cgi?id=173635
Bug ID: 173635
Summary: Writer DOCX: currency number format is lost from
formula cells after save and reopen
Product: LibreOffice
Version: 26.2.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
Description:
A Currency number format applied to a Writer table cell containing a formula is
lost when the document is saved as DOCX and subsequently reopened.
The formula itself is retained and continues to calculate correctly. Only the
cell's number format is lost, reverting to Decimal.
The same document saved as ODT retains the Currency formatting correctly.
LibreOffice version: 26.2.5.2
Component: Writer
File format: DOCX
OS: Windows 11
### Minimal example ###
Formula:
=SUM(<D2:D5>)
Expected display:
£1,234.56
Actual display after DOCX save/reopen:
1234.56
This appears to be a DOCX import/export issue involving the number format of
Writer table formula cells.
Steps to Reproduce:
1. Create a new Writer document.
2. Insert a table with at least 5 rows and 4 columns.
3. Enter numeric values in cells D2:D5.
4. In another table cell, enter the formula:
=SUM(<D2:D5>)
5. Select the formula cell and set its number format to Currency, using GBP
(£).
6. Confirm that the result is displayed as currency, for example:
£1,234.56
7. Save the document as DOCX.
8. Close the document.
9. Reopen the DOCX in LibreOffice Writer.
Actual Results:
The formula is still present and the calculated value is correct, but the
Currency number format has been lost.
The result is displayed as a plain decimal number, for example:
1234.56
The Writer status bar also reports the cell's format as Decimal.
Expected Results:
The Currency number format should be retained when the DOCX document is saved
and reopened, so that the formula result continues to display, for example:
£1,234.56
Reproducible: Always
User Profile Reset: No
Additional Info:
The problem does not occur when using ODT.
If the cell is formatted as Currency and the document is saved as ODT, then
closed and reopened, the Currency formatting is retained correctly.
The problem is therefore reproducible specifically with the DOCX save/reopen
cycle.
The formula itself is not the cause: while the document remains open, the
formula cell displays correctly as Currency. The formatting is lost only after
saving to DOCX and reopening.
--
You are receiving this mail because:
You are the assignee for the bug.
