You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/07/09 03:38:44 UTC

[Bug 120216] New: Save as csv, tab separated isn't possible

https://issues.apache.org/ooo/show_bug.cgi?id=120216

          Priority: P3
            Bug ID: 120216
          Assignee: ooo-issues@incubator.apache.org
           Summary: Save as csv, tab separated isn't possible
          Severity: critical
        Issue Type: DEFECT
    Classification: Application
                OS: Mac OSX, 10.7
          Reporter: wkoorengevel@yahoo.com
          Hardware: Mac
            Status: UNCONFIRMED
           Version: AOO 3.4.0
         Component: save-export
           Product: spreadsheet

I cannot export my .ods file to (or save as) a .csv file, field tabular
separated. I mean: Tab = {Tab} = \t, nothing works. Output looks like:
`Field{Field{..{Field}'. And I really need this... Please help! Thanks a lot!

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120216] Save as csv, tab separated isn't possible

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120216

fanyuzhen@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         QA Contact|                            |emiliano.lucetti@gmail.com

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120216] Save as csv, tab separated isn't possible

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120216

Risto Jääskeläinen <rj...@saunalahti.fi> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |rjaaskel@saunalahti.fi

--- Comment #5 from Risto Jääskeläinen <rj...@saunalahti.fi> ---
I made a proposal (or 2) on Dutch Pootle SCSTR_FIELDSEP line. If it happens
that there is not now in summer time enough work force do this little change I
think I can commit it. I suppose I have correct rights in Pootle to do that.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120216] Save as csv, tab separated isn't possible

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120216

--- Comment #4 from Regina Henschel <rb...@t-online.de> ---
It seems to be an error in the string SCSTR_FIELDSEP in the file localize.sdf

in nl version I see
,\t\t44\t\t;\t\t59\t\t:\t\t58\t\t{Tab}\t\t9\t\t{spatie}\t\t32

in de version I see
,\t44\t;\t59\t:\t58\t{Tab}\t9\t{Leer}\t32

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120216] Save as csv, tab separated isn't possible

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120216

--- Comment #3 from Regina Henschel <rb...@t-online.de> ---
Created attachment 78622
  --> https://issues.apache.org/ooo/attachment.cgi?id=78622&action=edit
Errors in csv dialog in Dutch version

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120216] Save as csv, tab separated isn't possible

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120216

Oliver-Rainer Wittmann <or...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|CONFIRMED                   |RESOLVED
                 CC|                            |orw@apache.org
         Resolution|---                         |FIXED
              Flags|4.0.0_release_blocker?      |

--- Comment #8 from Oliver-Rainer Wittmann <or...@apache.org> ---
(In reply to Dick Groskamp from comment #7)
> FIXED in 3.4.1
> 
> Translation has been adapted and stands.
> 
> Issue can be closed

Ok, resolving as fixed.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120216] Save as csv, tab separated isn't possible

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120216

fanyuzhen@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |fanyuzhen@gmail.com
              Flags|                            |4.0.0_release_blocker?

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120216] Save as csv, tab separated isn't possible

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120216

Regina Henschel <rb...@t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|CLOSED                      |REOPENED
           Hardware|Mac                         |All
         Resolution|INVALID                     |---
     Ever confirmed|0                           |1
                 OS|Mac OSX, 10.7               |All

--- Comment #2 from Regina Henschel <rb...@t-online.de> ---
After some private mails, I can confirm the problem. The error does not occur
in an English version, but you see it in a Dutch version. It is sufficient to
install the Dutch language pack.
The error is as described, selecting the item {tab} from the field delimiter
drop-down list, gives the character { instead of a tab in the resulting csv
file.

The drop-down list looks odd. It has some items, which should not be there. I
will attach a screenshot.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120216] Save as csv, tab separated isn't possible

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120216

Regina Henschel <rb...@t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |rb.henschel@t-online.de
         Resolution|---                         |INVALID

--- Comment #1 from Regina Henschel <rb...@t-online.de> ---
This is a support request and no bug report. Please use the mailing list or
forum. So I will close it. Feel free to reopen it, if the following HowTo fails
for you.

How to export:
1. File > Save As...
2. Select filter "Text CSV (.csv)" and check "Edit filter settings". You get
the dialog "Export Text File"
3. From the drop-down list "Field delimiter" choose the item {Tab}. Make sure,
that the other settings are correct too; especially "Save all content as shown"
has to be unchecked in most cases.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120216] Save as csv, tab separated isn't possible

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120216

Regina Henschel <rb...@t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REOPENED                    |CONFIRMED

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120216] Save as csv, tab separated isn't possible

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120216

Regina Henschel <rb...@t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120216] Save as csv, tab separated isn't possible

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120216

Dick Groskamp <th...@quicknet.nl> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |th.groskamp@quicknet.nl

--- Comment #6 from Dick Groskamp <th...@quicknet.nl> ---
Regina / Ristoi,

thanks for stepping in.

I've  fiound the conflicting string.
It is due to some superfluous tabs that got into the Dutch trabslation. (As
Regina saw correctly)
I noticed that tose appear when you copy the original English string to the
field for editing

I removed the superfluous tabs and adjusted the Dutch translation. I can't
check if the correction
stnds if the suggestion will be accepted, since I have no acces to Pootle.

As Ristoi did I entered a suggestion 2 (nobody)
In Ristoii's suggestions I see the removed tabs as strikethrough, which is
probably not the solution

@Juergen: please accept suggestiion #2  in segment 2609 
          (scstring.src#SCSTR_FIELDSEP.string.text)
          to see if the suggestion stands. If not I will type the text in the  
          field for editing instead of copying it from the original text

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120216] Save as csv, tab separated isn't possible

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120216

--- Comment #7 from Dick Groskamp <th...@quicknet.nl> ---
FIXED in 3.4.1

Translation has been adapted and stands.

Issue can be closed

-- 
You are receiving this mail because:
You are the assignee for the bug.