Apache OpenOffice (AOO) Bugzilla – Issue 35053
Mail merge with spreadsheet documents loses non-default date formats
Last modified: 2017-05-20 11:26:09 UTC
If I have cells with date in Spreadsheet that I use as Data Source, and I create a form and place the corresponding field in there, the date is always in DD.MM.YY format in Mail Merge output, although I selected "get format from source" option and in source spreadsheet there is DD.MM.YYYY format. Even if I select "Set manually" and select DD.MM.YYYY for the field, it always falls to the default DD.MM.YY after Mail Merge.
Created attachment 18162 [details] The data source
Created attachment 18163 [details] The text doc with corresponding field inserted
Created attachment 18164 [details] 1st Output of Mail Merge
Created attachment 18165 [details] 2nd output of MailMerge
reassigned to HI.
It's not a mailmerge issue and it is not defect. The import of an calc database will not support user formats in current.
changing summary from Date format falls back to default in Mail Merge to Mail merge with spreadsheet documents loses non-standard date formats fs->nn: Technically, if we want to transport formatting information from the Calc document to the Base UI layer, we probably need to support the css.sdb.ColumnSettings service (aka its properties) at the table columns returned by the driver. In the Base core implementation, we could use those settings from the driver, if it supports them, else create our own ones (as we currently do). If you do the first part in your driver, we do the second in our core :) It probably makes sense to support only those properties from the ColumnSettings service which can reasonably be filled from the spreadsheet, means "FormatKey", "Align", and "Width". Thinking more about it, we should probably also choose a formatter-independent representation of the format, namely a FormatString plus FormatLocale (or so), else we would also need to provide the NumberFormatsSupplier somewhere.
"default", not "standard"
Created attachment 74145
Reset assigne to the default "issues@openoffice.apache.org".