** Description changed: - 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. + 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-wst example.xls && localc --nologo example.xls + + one may input data into different fields, 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: 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 + 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
** 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 + 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-wst example.xls && localc --nologo example.xls + 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 different fields, 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). + 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: 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 + 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 -- 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: New 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: 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 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