Issue 35053 - Mail merge with spreadsheet documents loses non-default date formats
Summary: Mail merge with spreadsheet documents loses non-default date formats
Status: CONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.2
Hardware: All Windows 2000
: P3 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-10-06 15:11 UTC by tuharsky
Modified: 2017-05-20 11:26 UTC (History)
7 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
The data source (5.20 KB, application/vnd.sun.xml.calc)
2004-10-06 15:12 UTC, tuharsky
no flags Details
The text doc with corresponding field inserted (5.18 KB, application/vnd.sun.xml.writer)
2004-10-06 15:13 UTC, tuharsky
no flags Details
1st Output of Mail Merge (5.18 KB, application/vnd.sun.xml.writer)
2004-10-06 15:14 UTC, tuharsky
no flags Details
2nd output of MailMerge (5.17 KB, application/vnd.sun.xml.writer)
2004-10-06 15:14 UTC, tuharsky
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description tuharsky 2004-10-06 15:11:50 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.
Comment 1 tuharsky 2004-10-06 15:12:38 UTC
Created attachment 18162 [details]
The data source
Comment 2 tuharsky 2004-10-06 15:13:50 UTC
Created attachment 18163 [details]
The text doc with corresponding field inserted
Comment 3 tuharsky 2004-10-06 15:14:16 UTC
Created attachment 18164 [details]
1st Output of Mail Merge
Comment 4 tuharsky 2004-10-06 15:14:38 UTC
Created attachment 18165 [details]
2nd output of MailMerge
Comment 5 michael.ruess 2004-10-06 15:53:39 UTC
reassigned to HI.
Comment 6 h.ilter 2005-08-15 13:37:02 UTC
It's not a mailmerge issue and it is not defect.
The import of an calc database will not support user formats in current.
Comment 7 Frank Schönheit 2005-08-16 06:52:33 UTC
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.
Comment 8 Frank Schönheit 2005-08-16 06:58:27 UTC
"default", not "standard"
Comment 9 constencate 2010-11-11 03:32:09 UTC
Created attachment 74145
Comment 10 Marcus 2017-05-20 11:25:00 UTC
Reset assigne to the default "issues@openoffice.apache.org".
Comment 11 Marcus 2017-05-20 11:26:09 UTC
Reset assigne to the default "issues@openoffice.apache.org".