spreadsheets opened in read only mode can not be edited

Bug #1018002 reported by Malac on 2012-06-26
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
libreoffice (Ubuntu)
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~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

Malac, thank you for reporting this and helping make Ubuntu better. Could you please provide an example document that demonstrates this problem?

Changed in libreoffice (Ubuntu):
status: New → Incomplete
Malac (malacusp) wrote :

Sorry for the delay.
This happens on any .xlr file with 400 permissions (read-only). This is not related to being marked read-only on a windows share as I have transfered the file to a test system and marked it read-only using the linux permissions.
I have attached a file that this specifically happens on.
It is a calculation program and the cells A7, B7, C7, D7 and E7 should be altered to calculate a price.
However when opened in read-only mode the cells themselves are read-only not the file. I think this behaviour is not expected.
I would expect the cells to allow modification but the file not to be "save-able".

I will also be raising a bug with Writer as well as it seems this is the norm for Writer too as an .odt document can not be altered from within Writer if it is read-only. Again I don't think this is the expected behaviour.

tags: added: i386 precise
Changed in libreoffice (Ubuntu):
status: Incomplete → New
description: updated
description: updated

Malac, regarding your scenario, do you have the user permissions to change the file permissions in your environment, or are you looking to do this from an end-user/cannot edit file permission perspective?

As well, does the following WORKAROUND provide a solution for your situation:
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

description: updated
Changed in libreoffice (Ubuntu):
status: New → Incomplete
Launchpad Janitor (janitor) wrote :

[Expired for libreoffice (Ubuntu) because there has been no activity for 60 days.]

Changed in libreoffice (Ubuntu):
status: Incomplete → Expired
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers