[Upstream] tsv import: single-quote at beginning of cell deleted

[Peter Adolphs]

Binary package hint: openoffice.org

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

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

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

cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/742483/+attachment/1940068/+files/test.tsv && 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.

[Peter Adolphs (futzilogik)]

Adding a minimal test file. The values in both columns in line 2 and 3 will be changed in that one cell-initial single-quote will be removed.

This is tested with openoffice.org-calc Version 1:3.2.0-7ubuntu4.2, Ubuntu 10.04.2 LTS.

[penalvch (penalvch)]

Created attachment 47797
test.tsv

Downstream bug may be found at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/742483

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

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

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

cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/742483/+attachment/1940068/+files/test.tsv && 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.

[Libreoffice-z (libreoffice-z)]

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!

@Christopher:
Did you check and were you able to reproduce the problem? Can reporter of original launchpad bug report test again with 4.0?

[Libreoffice-z (libreoffice-z)]

Created attachment 47798
Screenshots, see Comment 1

[penalvch (penalvch)]

Peter Adolphs, thanks for reporting this bug and the supporting documentation. Since this bug has enough information provided for a developer to begin work, I'm going to mark it as Triaged and let them handle it from here. Thanks for taking the time to make Ubuntu better!

[Björn Michaelsen (bjoern-michaelsen)]

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.

[Björn Michaelsen (bjoern-michaelsen)]

[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:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html

[penalvch (penalvch)]

Unreproducible in:

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

lsb_release -rd
Description: Ubuntu 11.10
Release: 11.10

[penalvch (penalvch)]

Peter Adolphs, thank you for taking the time to report this bug and helping to make Ubuntu better. However, I am closing it because the bug has been fixed in Oneiric Ocelot.

This is a significant bug in Ubuntu. If you need a fix for the bug in previous versions of Ubuntu, please do steps 1 and 2 of the SRU Procedure [1] to bring the need to a developer's attention.

[1]: https://wiki.ubuntu.com/StableReleaseUpdates#Procedure

[Peter Adolphs (futzilogik)]

Yes, I can confirm that it's fixed in Ubuntu 11.10. Thanks! :-)