[Issue 125636] New: Choice of decimal point when exporting/saving .csv files

[bu...@apache.org]

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

          Issue ID: 125636
        Issue Type: DEFECT
           Summary: Choice of decimal point when exporting/saving .csv
                    files
           Product: Calc
           Version: 4.1.1
          Hardware: All
                OS: Windows 7
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: save-export
          Assignee: issues@openoffice.apache.org
          Reporter: larsj@sund.ku.dk

Created attachment 83963
  --> https://issues.apache.org/ooo/attachment.cgi?id=83963&action=edit
Sample data file using comma as decimal point

Saving a .csv file uses the language setting of the system, not the language
setting the file was opened with. 

As an example is attaced a small .csv file using comma (,) as decimal point and
tab as separator. It can be correctly opened/imported specifying e.g. Danish
language setting. However, when the file is saved, the current systems language
setting will be used. If the system language setting is e.g. English, it will
be saved with period (.) as decimal point.

Or inversely: I use Danish language setting, but also work with files where
period (.) is used as decimal point. If I edit them in Calc (choosing Language
as English in the Open dialogue) and saves them as .txt or .csv file, I
afterwards have to re-open in Notepad to change all "," to ".".

One way to fix this could be to add "Language" setting as a choice in the Save
dialogue for .csv and .txt files (like in the Open dialogue for .csv).
Preferentially, the default setting of the language setting should be the same
as was used for opening the file.

This issue on exporting .csv files can be seen as a mirror of issue ID 49978
about IMPORTING .csv files.

--Lars J

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 125636] Choice of decimal point when exporting/saving .csv files

[bu...@apache.org]

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

Lars Jødal <la...@sund.ku.dk> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |larsj@sund.ku.dk
           See Also|                            |https://issues.apache.org/o
                   |                            |oo/show_bug.cgi?id=49978

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.