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