Issue 111345 - Using csv-file in mail merge changes a single column to null
Summary: Using csv-file in mail merge changes a single column to null
Status: CLOSED FIXED
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: DEV300m82
Hardware: PC Windows 7
: P3 Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@sw
URL:
Keywords: data_loss
Depends on:
Blocks:
 
Reported: 2010-05-03 15:19 UTC by wingfire
Modified: 2017-05-20 11:41 UTC (History)
3 users (show)

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

Attachments
csv file with dummy data (926 bytes, text/plain)
2010-05-03 15:21 UTC, wingfire 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description wingfire 2010-05-03 15:19:59 UTC 
Hi all,
i created a mail merge with the wizard.
1. "Use the current document"
2. "E-mail message"
3. "Select Address List ..." -> "Add..." Datasource is a csv-file (UTF-8, comma
separated, " as delimiter).
6. "Edit Document ..."
Now i click on "Data Sources" to check the data and find the column
icef_event__name is changed to "0".
Column 15 is changed to null, always.
Comment 1 wingfire 2010-05-03 15:21:00 UTC 
Created attachment 69262 [details]
csv file with dummy data
Comment 2 eric.savary 2010-05-03 15:41:30 UTC 
Field mixed of alpha and numerical data. Issue 25840.

*** This issue has been marked as a duplicate of 25840 ***
Comment 3 eric.savary 2010-05-03 15:41:39 UTC 
closed
Comment 4 wingfire 2010-06-16 14:06:18 UTC 
the duplicate ticket is closed and integrated in the version DEV300_m77
http://hg.services.openoffice.org/hg/cws/calc53/rev/33fe4089cd01
but this bug is still existing
Comment 5 niklas.nebel 2010-06-16 14:35:20 UTC 
calc53 was integrated into m80, not m77. See
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fcalc53
Comment 6 wingfire 2010-06-16 15:40:49 UTC 
thanks for correction, nevertheless the bug is still present in the last dev
version 82.
Comment 7 wingfire 2010-06-17 13:29:18 UTC 
reopen
Comment 8 niklas.nebel 2010-06-18 10:59:17 UTC 
This is indeed completely unrelated to issue 25840. Calc is not involved, the
database flat-file driver is confused by the comma in the quoted text string.
Comment 9 ocke.janssen 2010-07-14 14:25:33 UTC 
Fixed in cws dba33g
Comment 10 ocke.janssen 2010-07-15 09:40:05 UTC 
Please verify. Thanks.
Comment 11 marc.neumann 2010-07-19 08:56:12 UTC 
verified in cws dba33g
Comment 12 marc.neumann 2010-07-19 08:57:29 UTC 
verified in cws dba33g