** Description changed: Binary package hint: openoffice.org - I open a tab-separated values (tsv) file in OpenOffice Calc. In the text - import window, I select "Separated by tab", I set the text delimiter to - the empty string and uncheck the other options. The preview in the - import window shows the values correctly. + 1) lsb_release -rd + Description: Ubuntu 11.04 + Release: 11.04 - In the final document, any value-initial single-quote is removed. If - there are several initial single-quotes, only one is removed. Single - quotes at the end of the cell are not changed. + 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.
** Tags added: lo33 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/742483 Title: tsv import: single-quote at beginning of cell deleted To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/742483/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
