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.

** Attachment added: "GLASS CALC 3.xlr"
   
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1018002/+attachment/3243407/+files/GLASS%20CALC%203.xlr

-- 
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:
  Incomplete

Bug description:
  Hopefully the summary says it all but when a file is opened in LibreOffice 
Calc as read-only it should still be editable and allow changing of values and 
formula calculations to take place.
  I have a few spreadsheets which are used as complex calculators and I don't 
want the formulas to change but the input boxes need to except new values. The 
files have to be marked read only as they are on a shared resource and won't 
open at all if they are not and someone else has a copy open.
  I think not being able to save the file should be sufficient.
  Possibly this is a feature request rather than a bug as such but it will also 
affect anyone coming from other spreadsheet products who are used to this 
behaviour.
  Thanks.
  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     : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp

Reply via email to