spreadsheets opened in read only mode can not be edited
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
libreoffice (Ubuntu) |
Expired
|
Undecided
|
Unassigned |
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~
Candidate: 1:3.6.2~
Version table:
*** 1:3.6.2~
900 http://
100 /var/lib/
1:
500 http://
3) What is expected to happen in Calc via a terminal:
cd ~/Desktop && wget -c https:/
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://
100 /var/lib/
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://
100 /var/lib/
1:
500 http://
1:
500 http://
tags: | added: i386 precise |
Changed in libreoffice (Ubuntu): | |
status: | Incomplete → New |
description: | updated |
description: | updated |
Malac, thank you for reporting this and helping make Ubuntu better. Could you please provide an example document that demonstrates this problem?