[Expired for libreoffice (Ubuntu) because there has been no activity for
60 days.]
** Changed in: libreoffice (Ubuntu)
Status: Incomplete => Expired
--
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1018002
Title:
spreadsheets opened in read only mode can not be edited
Status in “libreoffice” package in Ubuntu:
Expired
Bug description:
1) lsb_release -rd
Description: Ubuntu 12.10
Release: 12.10
2) apt-cache policy libreoffice-calc
libreoffice-calc:
Installed: 1:3.6.2~rc2-0ubuntu4
Candidate: 1:3.6.2~rc2-0ubuntu4
Version table:
*** 1:3.6.2~rc2-0ubuntu4 0
900 http://archive.ubuntu.com/ubuntu/ quantal-updates/main i386
Packages
100 /var/lib/dpkg/status
1:3.6.2~rc2-0ubuntu3 0
500 http://archive.ubuntu.com/ubuntu/ quantal/main i386 Packages
3) What is expected to happen in Calc via a terminal:
cd ~/Desktop && wget -c
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1018002/+attachment/3243407/+files/GLASS%20CALC%203.xlr
-O example.xls && chmod a-w example.xls && localc --nologo example.xls
one may input data into any cell, but when one attempts to save the
file, it prevents them from doing so. Instead, one would have to Save
As to another file name, as it is in Microsoft Office Professional
Plus 2010 Excel Version 14.0.6023.1000 (32-bit).
4) What happens instead is a pop up comes up noting:
Document opened in read-only mode.
WORKAROUND: Allow read/write/execute permissions to the file for the
appropriate users -> open file -> highlight cells one would like to
have modifiable by users -> secondary click one of the highlighted
cells -> primary click Format cells... -> tab Cell Protection ->
uncheck Protected -> button OK -> secondary click the desired sheet ->
Protect Sheet... -> check Protect this sheet and the contents of
protected cells -> type and confirm password -> button OK
WORKAROUND: Use Gnumeric.
apt-cache policy gnumeric
gnumeric:
Installed: 1.10.17-1.1ubuntu1
Candidate: 1.10.17-1.1ubuntu1
Version table:
*** 1.10.17-1.1ubuntu1 0
500 http://archive.ubuntu.com/ubuntu/ quantal/universe i386 Packages
100 /var/lib/dpkg/status
Original Reporter Comments:
Description: Ubuntu 12.04 LTS
Release: 12.04
libreoffice-calc:
Installed: 1:3.5.4-0ubuntu1
Candidate: 1:3.5.4-0ubuntu1
Version table:
*** 1:3.5.4-0ubuntu1 0
500 http://gb.archive.ubuntu.com/ubuntu/ precise-proposed/main i386
Packages
100 /var/lib/dpkg/status
1:3.5.3-0ubuntu1 0
500 http://gb.archive.ubuntu.com/ubuntu/ precise-updates/main i386
Packages
1:3.5.2-2ubuntu1 0
500 http://gb.archive.ubuntu.com/ubuntu/ precise/main i386 Packages
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1018002/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : [email protected]
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
