https://bugs.documentfoundation.org/show_bug.cgi?id=165245
Bug ID: 165245
Summary: MAILMERGE: Custom format lost in merge document
Product: LibreOffice
Version: 25.2.0.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
Created attachment 199195
--> https://bugs.documentfoundation.org/attachment.cgi?id=199195&action=edit
In the ZIP file, two files: Calc spreadsheet as the source and Writer documents
use for the MailMerge
I am using a spreadsheet as a source database in a mailmerge document.
In the spreadsheet, I have a column "Phone_Number". The phone_number column in
the spreadsheet uses the following user-define format “(000") "000"-"0000” so
that the 10-digit phone number 2015555252 in the cell is displayed as (201)
555-5252.
In the spreadsheet, the user-define format works correctly and display the
phone number correctly, i.e. with the surrounding brackets for the area code,
followed by a space, and it includes the hyphen before the last 4 digits.
I also have a column "Price" formatted as currency in the spreadsheet $1 000
000 in the source spreadsheet.
In the merge document, I use both field. The "Price" is formatted correctly,
but the phone number format seems to be lost, since it is shown as ten straight
number 2015555252 and not (201) 555-5252.
I have attached a simple Calc and Writer document to replicate the bug.
Hope you can help.
JF
By the way, if I apply a custom format directly to the variable in the Writer
document, it works. Also, I think I use to be able to define a format by
right-clicking the field in the Database browser while editing the Writer
document. Is it normal that this feature does not seam to be available anymore?
--
You are receiving this mail because:
You are the assignee for the bug.
