Issue 95260 - Export to CVS should ignore blank as text delimiter
Summary: Export to CVS should ignore blank as text delimiter
Status: RESOLVED FIXED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 3.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2008-10-21 13:13 UTC by docb
Modified: 2014-01-12 06:57 UTC (History)
2 users (show)

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

Attachments
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 docb 2008-10-21 13:13:14 UTC 
This is a follow-up on 94999 . With regard to the last comment OO should ignore
blank (' ') as a valid text delimiter, for the following reasons:
- for the user it is nearly impossible to judge if the field for Text delimiter
is empty/deleted or filled with a blank.
- The result is different for " as delimiter vs. blank:

With a " as delimiter, the result is:
"Deeside Line 1 - 220 Silver Std JCAT91"
With a blank it is:
 Deeside  Line  1  -  220  Silver  Std  JCAT91 
(Please note the additional blank around each word)

This mean, with a blank as delimiter it behaves irregular.

For these reasons....please ignore a blank as text separation char...
Comment 1 Edwin Sharp 2014-01-07 19:15:22 UTC 
Please attach an example.
Comment 2 docb 2014-01-11 05:58:59 UTC 
(In reply to Edwin Sharp from comment #1)
> Please attach an example.

As a result of the export with <blank> as trext delimiter, you may use the attachment as in this comment:
https://issues.apache.org/ooo/show_bug.cgi?id=94999#c1
Comment 3 Edwin Sharp 2014-01-11 18:05:28 UTC 
Can not reproduce description.
AOO410m1(Build:9750)  -  Rev. 1555399
2014-01-06_04:13:46 - Rev. 1555657
Debian

For column G "Short text":
Import with text delimiter blank = Import with text delimiter double quote = Import with Calligra Sheets 2.6.4.

Please explain.
Comment 4 Edwin Sharp 2014-01-11 18:07:20 UTC 
Same for column E "Text"...
Comment 5 docb 2014-01-12 06:22:56 UTC 
(In reply to Edwin Sharp from comment #3)
> For column G "Short text":
> Import with text delimiter blank = Import with text delimiter double quote =
> Import with Calligra Sheets 2.6.4.

Sorry, I dont understand what you mean by this.
If you want to say: It looks all the same in the three cases, then the problem was obviously fixed in between. My bug-report is more than 5 years old!
Comment 6 Edwin Sharp 2014-01-12 06:57:37 UTC 
fixed per comment 5