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 changed: 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 ** Changed in: libreoffice (Ubuntu) Status: New => Incomplete -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1018002 Title: spreadsheets opened in read only mode can not be edited To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1018002/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
