** 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 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 [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
