Download it now!
Bug 38133 - FILEOPEN tsv import: single-quote at beginning of cell deleted
Summary: FILEOPEN tsv import: single-quote at beginning of cell deleted
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.2 release
Hardware: x86 (IA32) Linux (All)
: low normal
Assignee: Not Assigned
Depends on:
Reported: 2011-06-09 20:26 UTC by Christopher M. Penalver
Modified: 2012-01-03 18:31 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

test.tsv (134 bytes, text/tab-separated-values)
2011-06-09 20:26 UTC, Christopher M. Penalver
Screenshots, see Comment 1 (66.85 KB, application/x-download)
2011-06-09 21:56 UTC, Rainer Bielefeld Retired

Note You need to log in before you can comment on or make changes to this bug.
Description Christopher M. Penalver 2011-06-09 20:26:30 UTC
Created attachment 47797 [details]

Downstream bug may be found at:

1) lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04

2) apt-cache policy libreoffice-calc
  Installed: 1:3.3.2-1ubuntu5
  Candidate: 1:3.3.2-1ubuntu5
  Version table:
 *** 1:3.3.2-1ubuntu5 0
        500 natty-updates/main i386 Packages
        100 /var/lib/dpkg/status
     1:3.3.2-1ubuntu4 0
        500 natty/main i386 Packages

3) What is expected to happen in LibreOffice Calc via the Terminal:

cd ~/Desktop && wget && localc -nologo test.tsv

in the text import window, highlight the Separated by radio button -> check the Tab checkbox -> uncheck all other checkboxes -> delete the contents of the Text delimiter combo box -> click OK button and the preview should look the same as the imported file.

4) What happens instead is one of the single-quotes at the beginning of the cell is removed. If there are several initial single-quotes, only one is removed. Single quotes at the end of the cell are not changed.
Comment 1 Rainer Bielefeld Retired 2011-06-09 21:51:26 UTC
NOT Reproducible with "LibreOffice 3.4.0  – WIN7  Home Premium  (64bit) German UI [OOO340m1 (Build:12)]" and reporter's sample file (I renamed it to .csv, .tsv is a pain), all single quotes remain (pls. see attached screenshots). Playing with auto replace options did not lead to the bug.

Linux specific? Ubuntu specific? Version specific? Related to particular settings? We need more information!

Did you check and were you able to reproduce the problem? Can reporter of original launchpad bug report test again with 4.0?
Comment 2 Rainer Bielefeld Retired 2011-06-09 21:56:30 UTC
Created attachment 47798 [details]
Screenshots, see Comment 1
Comment 3 Björn Michaelsen 2011-12-23 12:23:33 UTC
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:

more detail on this bulk operation:
Comment 4 Christopher M. Penalver 2012-01-03 18:31:32 UTC
Unreproducible in:

 apt-cache policy libreoffice-calc
  Installed: 1:3.4.4-0ubuntu1
  Candidate: 1:3.4.4-0ubuntu1
  Version table:
 *** 1:3.4.4-0ubuntu1 0
        500 oneiric-updates/main i386 Packages
        100 /var/lib/dpkg/status
     1:3.4.3-3ubuntu2 0
        500 oneiric/main i386 Packages

lsb_release -rd
Description:	Ubuntu 11.10
Release:	11.10