Issue 88793 - FieldSeparator property doesn't work as expected
Summary: FieldSeparator property doesn't work as expected
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: DEV300m6
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 3.0
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2008-04-28 08:33 UTC by Oliver Specht
Modified: 2009-07-20 15:57 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description Oliver Specht 2008-04-28 08:33:48 UTC
Use Writer's mailmerge wizard and create a new database. 
The created data cannot be used because the Tab character is not set as
FieldSeparator. 

Additionally: 
- close the wizard
- call the database browser (F4)
- edit the database of the newly created data source
- change the separator to TAB ->the document is not modified

Repeat the steps after connecting the database in the db-browser then it works.
Comment 1 Oliver Specht 2008-04-28 08:34:23 UTC
regression, target set to 3.0
Comment 2 Oliver Specht 2008-04-28 09:28:57 UTC
I wrote the issue too early.
The changed setting gets lost sometimes. At least at restart of the office.
Comment 3 Frank Schönheit 2008-05-22 13:47:29 UTC
fs->oj: You don't need mail merge for this. Just use an arbitrary text-based
database, and change, in the UI, the Field Delimiter to {Tab}. After saving,
closing, and re-opening the document, this setting is gone.

Looking into the content.xml there is
 <db:driver-settings>
  <db:delimiter db:field="&#x09;"
                db:string="&quot;"
                db:decimal="."
                db:thousand=","/>
  <db:font-charset db:encoding="UTF-8"/>
 </db:driver-settings>
I.e., the setting is properly written, but not properly read by the filter.
Comment 4 ocke.janssen 2008-05-27 12:37:41 UTC
In a dev300m13
Comment 5 ocke.janssen 2008-05-27 12:38:05 UTC
.
Comment 6 Oliver Specht 2008-05-30 12:39:45 UTC
->OJ: Checked in a DEV300m14, wntmsci12 - it still doesn't work
Comment 7 Frank Schönheit 2008-05-30 21:14:41 UTC
In this case let's re-open it.
Comment 8 ocke.janssen 2008-06-02 07:46:07 UTC
Fixed in cws dba30d.
Comment 9 ocke.janssen 2008-06-16 11:34:33 UTC
Please verify. Thanks.
Comment 10 marc.neumann 2008-06-18 08:53:50 UTC
I can't reproduce the problem in a DEV300_m13 and DEV300_m17. So I also can't
check the fix.

Please add a description how to reproduce the issue and how to test the fix.
Comment 11 marc.neumann 2008-06-18 08:54:26 UTC
reassign back to oj
Comment 12 ocke.janssen 2008-06-18 09:19:27 UTC
- start mail merge
- go to 3. Insert address book
- Push button Select Different Address List
- Push button Create
- Push button Save and set a name
- Push button Ok
- Push button Match Fields
=> The columns can not be matched
Comment 13 ocke.janssen 2008-06-18 09:19:48 UTC
.
Comment 14 marc.neumann 2008-06-18 11:31:00 UTC
verified in CWS dba30d

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba30d
Comment 15 marc.neumann 2008-06-18 11:31:41 UTC
msc -> oj: thanks
Comment 16 thorsten.ziehm 2009-07-20 15:57:46 UTC
This issue is closed automatically and wasn't rechecked in a current version of
OOo. The fixed issue should be integrated in OOo since more than half a year. If
you think this issue isn't fixed in a current version (OOo 3.1), please reopen
it and change the field 'Target Milestone' accordingly.

If you want to download a current version of OOo =>
http://download.openoffice.org/index.html
If you want to know more about the handling of fixed/verified issues =>
http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues