[Upstream] Calc comments disappear saving to .xlsx

[rooijan]

Binary package hint: openoffice.org
Binary package hint: libreoffice

1)
lsb_release -rd
Description: Ubuntu natty (development branch)
Release: 11.04

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

3) What is expected to happen is when one performs at the Terminal:

cd ~/Desktop && localc -nologo

Secondary click cell B2 -> click Insert Comment -> type TEST -> click outside the comment box -> File -> Save As -> File name: localc_comment -> File type: Office Open XML Spreadsheet (.xlsx) -> Save button -> Keep Current Format button -> close file and reopen via the Terminal:

localc -nologo localc_comment.xlsx

the comments in B2 remain.

4) What happens instead is they do not.

ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: openoffice.org-calc 1:3.2.1-7ubuntu1
ProcVersionSignature: Ubuntu 2.6.35-23.40-generic 2.6.35.7
Uname: Linux 2.6.35-23-generic x86_64
NonfreeKernelModules: fglrx
Architecture: amd64
Date: Wed Dec 1 07:56:42 2010
EcryptfsInUse: Yes
InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Release amd64 (20101007)
ProcEnviron:
 LANG=en_US.utf8
 SHELL=/bin/bash
SourcePackage: openoffice.org

[Robert Roth (evfool)]

This seems to be fixed in later versions, as it doesn't happen with OpenOffice 3.3 or LibreOffice 3.3.

[penalvch (penalvch)]

rooijan, thank you for reporting this bug and helping make Ubuntu better. Could you please attach the Calc file that demonstrates this problem? Does this issue occur for you in LibreOffice Calc?

sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y install libreoffice-calc

[rooijan (rrossouw)]

Not resolved. I did not try the PPA version just LibreOffice 3.3.1 from Ubuntu 11.04.

root@guest-VirtualBox:/home/guest# cat /etc/issue
Ubuntu natty (development branch) \n \l

root@guest-VirtualBox:/home/guest# aptitude show libreoffice-calc | grep Version
Version: 1:3.3.1-1ubuntu3

How to reproduce:
Open LibreOffice spreadsheet > Right Click in any cell > Insert Comment > Type your test comment > Click in a different cell > Save As > File Type > Office Open XML Spreadsheet(.xlsx)

Open the saved sheet and cell comment is gone.

I tried other formats:
.xls lost the comment (pretty sure this worked when I reported the bug initially)
.ods worked

[penalvch (penalvch)]

rooijan, this bug is unreproducible in Ubuntu 11.04 LibreOffice Calc via the Terminal:

localc -nologo

Secondary click cell A1 -> click Insert Comment -> type example -> click outside the comment box -> File -> Save As -> File name: example -> File type: Office Open XML Spreadsheet (.xlsx) -> Save button -> Keep Current Format button -> close file and reopen via the Terminal:

localc -nologo example.xlsx

Notice the comment is still there.

Secondary click cell A1 -> click Insert Comment -> type example -> click outside the comment box -> File -> Save As -> File name: example -> File type: Microsoft Excel 2007 XML (.xlsx) -> Save button -> Keep Current Format button -> close file and reopen via the Terminal:

localc -nologo example.xlsx

Notice the comment is still there.

Could you be more detailed on how this issue is reproducible in LibreOffice Calc? Could you please attach the document you can reliably demonstrates this problem in?

lsb_release -rd
Description: Ubuntu natty (development branch)
Release: 11.04

apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.1-1ubuntu3
  Candidate: 1:3.3.1-1ubuntu3
  Version table:
 *** 1:3.3.1-1ubuntu3 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages
        100 /var/lib/dpkg/status

[rooijan (rrossouw)]

Christopher I know this sounds bizarre but you might be able to reproduce it if you try a cell other than A1. For me cell A1 worked but not others.

[penalvch (penalvch)]

rooijan, could you please attach a Calc file to this bug, with detailed step-by-step instructions, that demonstrate this problem?

[rooijan (rrossouw)]

Christopher, I reproduced like this.

Ubuntu 11.04 LibreOffice Calc via the Terminal:

localc -nologo

Secondary click cell B2 -> click Insert Comment -> type TEST -> click outside the comment box -> File -> Save As -> File name: localc_comment -> File type: Office Open XML Spreadsheet (.xlsx) -> Save button -> Keep Current Format button -> close file.

Double click file on desktop and voila there is no comment in cell B2.
*** Note I said cell B2 not A1.

[penalvch (penalvch)]

Confirmed in Ubuntu 10.10 LibreOffice Calc via the Terminal:

cd ~/Desktop && localc -nologo

Secondary click cell B2 -> click Insert Comment -> type TEST -> click outside the comment box -> File -> Save As -> File name: localc_comment -> File type: Office Open XML Spreadsheet (.xlsx) -> Save button -> Keep Current Format button -> close file and reopen via the Terminal:

localc -nologo localc_comment.xlsx

Notice the comment in B2 is gone.

lsb_release -rd
Description: Ubuntu 10.10
Release: 10.10

 apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.1-1ubuntu3~maverick1
  Candidate: 1:3.3.1-1ubuntu3~maverick1
  Version table:
 *** 1:3.3.1-1ubuntu3~maverick1 0
        500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages
        100 /var/lib/dpkg/status

[penalvch (penalvch)]

Downstream bug may be found at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/683717

1)
lsb_release -rd
Description: Ubuntu natty (development branch)
Release: 11.04

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

3) What is expected to happen is when one performs at the Terminal:

cd ~/Desktop && localc -nologo

Secondary click cell B2 -> click Insert Comment -> type TEST -> click outside the comment box -> File -> Save As -> File name: localc_comment -> File type: Office Open XML Spreadsheet (.xlsx) -> Save button -> Keep Current Format button -> close file and reopen via the Terminal:

localc -nologo localc_comment.xlsx

the comments in B2 remain.

4) What happens instead is they do not.

[Cedric-bosdonnat-ooo (cedric-bosdonnat-ooo)]

Muthu, that one is for you. I could reproduce it on master.

[penalvch (penalvch)]

roojian, 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!

[Sumuthu (sumuthu)]

Fixed.

[penalvch (penalvch)]

Muthu, this is still reproducible in LibreOffice 3.4.2. Is this fixed in master? If so, could you please post a commit?

lsb_release -rd
Description: Ubuntu oneiric (development branch)
Release: 11.10

apt-cache policy libreoffice-writer
libreoffice-writer:
Installed: 1:3.4.2-2ubuntu2
Candidate: 1:3.4.2-2ubuntu2
Version table:
*** 1:3.4.2-2ubuntu2 0
500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages
100 /var/lib/dpkg/status

[Sumuthu (sumuthu)]

Sorry for the long delay...I seem to have problems receiving fdo mails:

commit: http://cgit.freedesktop.org/libreoffice/calc/commit/?id=78cae641e3eef57212cd90ba0870b610a760f516

[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.

[Sumuthu (sumuthu)]

Re-closing. At least it should be there in 3.5!

[Björn Michaelsen (bjoern-michaelsen)]

Fixed as per upstream 3.5.0 released with precise.