Bug 58146 - FILESAVE: Text field unexpectedly split by delimiting character
Summary: FILESAVE: Text field unexpectedly split by delimiting character
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.2.2 release
Hardware: All All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: CSV
  Show dependency treegraph
 
Reported: 2012-12-11 15:39 UTC by a2171776
Modified: 2021-08-14 07:26 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
example file to reproduce bug (160 bytes, text/csv)
2012-12-11 15:39 UTC, a2171776
Details

Note You need to log in before you can comment on or make changes to this bug.
Description a2171776 2012-12-11 15:39:45 UTC
Created attachment 71341 [details]
example file to reproduce bug

Version 3.6.2.2 (Build ID: 360m1(Build:2))

1.  Open the file "start.csv" in LibreOffice Calc
2.  Change anything in the file (e.g. a column width)
3.  Press the "Save" button
4.  Re-open the file in LibreOffice Calc

The "importloc" column is now split into two columns.  The split occurred where the comma was formerly.  This is a most unexpected and annoying behavior that results in some data loss.
Comment 1 john.pratt 2012-12-21 16:19:04 UTC
I can confirm that this bug exists in 4.0 beta 2 on windows XP.

The problem seems to be that on selecting save it does not provide the option to change the filter settings (which it does allow via file -> save as).

Workaround: use 'file -> save as' and select 'edit filter settings'.  The edit filter settings dialogue has an option quote all text which resolves the problem.

Suggested solution: when saving a csv libreoffice should automatically quote text if that was the case in the file loaded.
Comment 2 ign_christian 2013-07-08 02:38:52 UTC
I still can reproduce on LO 4.0.4.2 (Win7 32bit).
Set Platform: All
Comment 3 Ravindra Vidhate 2015-03-25 06:42:49 UTC
I tried to reproduce the issue on Ubuntu 14 LTS, but unsuccessful. I am not able to reproduce the issue on Ubuntu.

Following is the LO version.

Version: 4.5.0.0.alpha0+
Build ID: 1dc47816ac137d9bd5ce2070fdec1ddebebcbbd3
Comment 4 84.55.242.99 2016-01-05 04:19:48 UTC
in a Bugzilla installation.
A bug on launchpad.net
An issue on code.google.com.
A bug on bugs.debian.org.
An issue in a JIRA installation.
A ticket in a Trac installation.
A bug in a MantisBT installation.
A bug on sourceforge.net.
An issue on github.com.
Comment 5 84.55.242.99 2016-01-05 04:23:17 UTC
??? in a Bugzilla installation?

-A bug on launchpad.net occurs?
-An issue on code.google.com can't be issued ?
-A bug on bugs.debian.org issued.
-An issue in a JIRA installation can be a solution.
-A ticket in a Trac file installation may work.
-A bug in any installation can occurs.
-A bug on sourceforge.net issued.
-An issue can be found on www.github.com
-Error#144
Comment 6 84.55.242.99 2016-01-05 04:35:04 UTC
??? in a Bugzilla installation ???
-A bug on launchpad.net may have issued.
-An issue on code.google.com can't be issued?
-A bug on bugs.debian.org may have issued.
-An issue in a JIRA installation can work.
-A ticket in a Trac file installation may work.
-A bug in any installation can issue.
-A bug on sourceforge.net issued.
-An issue could be find on bugs.documentfoundation.org/show_bug.cgi?id=58146
Comment 7 QA Administrators 2017-03-06 14:05:59 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2020-10-27 04:25:25 UTC Comment hidden (obsolete)
Comment 9 Andreas Heinisch 2021-08-14 07:26:34 UTC
Cannot be reproduced in:

Version: 6.4.7.2 (x64)
Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU threads: 6; OS: Windows 10.0 Build 19042; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: CL

and neither in:

Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: d01d582bb068497bd526403e866236ce3be2f375
CPU threads: 6; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: CL