Issue 74790 - E-mail fields CVS/Text displayed as '0'
Summary: E-mail fields CVS/Text displayed as '0'
Status: CLOSED DUPLICATE of issue 69965
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.2 RC1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 2.x
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-02-22 23:20 UTC by milek_pl
Modified: 2007-08-09 11:19 UTC (History)
2 users (show)

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

Attachments
Sample CVS file (32 bytes, text/plain)
2007-02-22 23:22 UTC, milek_pl 		no flags Details
Database with Email error (1.57 KB, application/vnd.sun.xml.base)
2007-02-23 09:43 UTC, milek_pl 		no flags Details
Multi-field file with E-mail displaying as '0' (78 bytes, text/plain)
2007-04-24 15:22 UTC, milek_pl 		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 milek_pl 2007-02-22 23:20:15 UTC 
After configuring the connection to a text / CVS file where a comma (,) is a
separator, Base displays text fields as numerical values if they contain e-mail
addresses. I'm attaching a sample file. Steps to reproduce:

1. connect to the file;
2. set "," as field separator, {None} as text delimiter, and whatever other
characters in the other fields.
3. open the table to see that the E-mail column contains '0' instead of my
e-mail address.

The bug does not appear where there is only a single field.
Comment 1 milek_pl 2007-02-22 23:22:37 UTC 
Created attachment 43300 [details]
Sample CVS file
Comment 2 marc.neumann 2007-02-23 07:48:21 UTC 
Hi,

I can't reproduce this.

The Email is displayed correctly with the bugdoc database table.

Can you please attach also the database file.

Thanks and bye Marc
Comment 3 milek_pl 2007-02-23 09:43:07 UTC 
Created attachment 43306 [details]
Database with Email error
Comment 4 milek_pl 2007-02-23 09:44:32 UTC 
I attached the offending database (actually, I recreated the bug in a new one).
Note that this could depend on Polish locale, as separators are locale
dependent. I haven't tested this in other versions of OOo.
Comment 5 kpalagin 2007-04-24 14:54:00 UTC 
CSV file gets displayed just fine (both with one column and with two) using 
m209 on WinXP.
I even set OO localle to Polish and e-mail value displays correctly.
Resolving as WFM.
Comment 6 kpalagin 2007-04-24 14:55:59 UTC 
and closing.
Comment 7 milek_pl 2007-04-24 15:21:12 UTC 
Oops, the attached test file was wrong. See the original description:

"The bug does not appear where there is only a single field."

But there is only a single field in the file. I'm attaching a different one.
Comment 8 milek_pl 2007-04-24 15:22:42 UTC 
Created attachment 44641 [details]
Multi-field file with E-mail displaying as '0'
Comment 9 milek_pl 2007-04-24 15:23:39 UTC 
tested on 2.2.0 PL
Comment 10 kpalagin 2007-04-24 15:52:46 UTC 
Confirming with new file and separator set to SEMICOLON (;) using m209 on 
WinXP - first field "administrator" gets imported as is, but e-mail field is 
converted to 0. 

BTW, please do not change Version field - it is supposed to indicate when the 
problem was detected first.
Comment 11 christoph.lukasiak 2007-04-30 14:53:22 UTC 
i can repro that like described 

- it seems that because of the '.' in the e-mail address the format is
interpreted as an invalid number
Comment 12 kpalagin 2007-05-02 07:37:49 UTC 
Chris,
any chance for 2.3?
Comment 13 Frank Schönheit 2007-05-02 09:45:07 UTC 
fs->oj: yours
Comment 14 christoph.lukasiak 2007-05-02 14:06:46 UTC 
clu->kpalagin: chance yes, but i do not like to gamble with such things ;)
Comment 15 ocke.janssen 2007-08-09 11:19:09 UTC 
It's the same reason as issue 69965. The email wil be converted into number
because the following column is one.

*** This issue has been marked as a duplicate of 69965 ***
Comment 16 ocke.janssen 2007-08-09 11:19:35 UTC 
Closing this one.