[Upstream] Calc makes cells protected when it shouldn't

Bug #704789 reported by karaluh on 2011-01-19
This bug affects 1 person
Affects Status Importance Assigned to Milestone
libreoffice (Ubuntu)

Bug Description

Binary package hint: openoffice.org

1) lsb_release -rd
Description: Ubuntu precise (development branch)
Release: 12.04

2) apt-cache policy libreoffice-calc
  Installed: 1:3.5.2-2ubuntu1
  Candidate: 1:3.5.2-2ubuntu1
  Version table:
 *** 1:3.5.2-2ubuntu1 0
        500 http://us.archive.ubuntu.com/ubuntu/ precise/main i386 Packages
        100 /var/lib/dpkg/status

3) What is expected to happen in LibreOffice Calc via the Terminal:
cd ~/Desktop && wget -c https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/704789/+attachment/3075997/+files/Test%20case.ods -O example.ods && localc --nologo example.ods

open www.ubuntu.com in a web browser, copy "Fast, secure and stylishly simple," into A1, then try to delete the pasted text and it is deleted.

4) What happens instead is the text isn't deleted and the cell becomes protected.

ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: openoffice.org-calc 1:3.2.1-7ubuntu1
ProcVersionSignature: Ubuntu 2.6.35-25.43-generic
Uname: Linux 2.6.35-25-generic i686
Architecture: i386
Date: Tue Jan 18 16:02:24 2011
 PATH=(custom, no user)
SourcePackage: openoffice.org
ApportVersion: 1.23-0ubuntu4
Architecture: i386
DistroRelease: Ubuntu 11.10
Package: libreoffice-calc 1:3.4.5-0ubuntu1
PackageArchitecture: i386
 PATH=(custom, user)
Tags: oneiric
Uname: Linux 3.3.0-030300-generic i686
UpgradeStatus: Upgraded to oneiric on 2011-10-18 (180 days ago)
UserGroups: adm admin audio cdrom dialout dip floppy fuse libvirtd lpadmin plugdev sambashare scanner video

karaluh (karaluh) wrote :
Robert Roth (evfool) wrote :

I can not reproduce this 100%, sometimes it happens, sometimes it doesn't. There were many occasions, when the rich text was pasted as simple text, and then this did not happen, but when the text was pasted as rich text, the results were as you have described. Tested on both OpenOffice 3.3 and LibreOffice 3.3.
There might be two separate issues here (the one you have described, and rich text is not always pasted as formatted).

Changed in openoffice.org (Ubuntu):
status: New → Confirmed
status: Confirmed → New
Changed in openoffice.org (Ubuntu):
status: New → Won't Fix

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.

karaluh, thank you for reporting this and helping make Ubuntu better. Maverick reached EOL on April 2012.
Please see this document for currently supported Ubuntu releases:

We were wondering if this is still an issue in a supported release? If so, can you try with the latest development release of Ubuntu? ISO CD images are available from http://cdimage.ubuntu.com/releases/ .

If it remains an issue, could you run the following command in a supported release from a Terminal (Applications->Accessories->Terminal). It will automatically gather and attach updated debug information to this report:
apport-collect -p libreoffice 704789


Changed in libreoffice (Ubuntu):
status: New → Incomplete

Steps to reproduce:
1. Unprotect cell
2. Protect sheet
3. Paste the text "Fast, secure and stylishly simple," from ubuntu.com into the unprotected cell.

Current behavior:
Cell becomes protected.

Expected behavior:
Cell stays unprotected. See also https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/704789

Platform (if different from the browser):

Browser: Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:11.0) Gecko/20100101 Firefox/11.0

apport information

tags: added: apport-collected oneiric
description: updated
Changed in libreoffice (Ubuntu):
status: Incomplete → New
status: New → Confirmed

karaluh, could you please provide a specific website and example document that this problem is reproducible in?

Changed in libreoffice (Ubuntu):
status: Confirmed → Incomplete
karaluh (karaluh) wrote :

Webpage is ubuntu.com, paste the "Fast, secure and stylishly simple, " text for example

Changed in libreoffice (Ubuntu):
status: Incomplete → Confirmed

karaluh, thank you for taking the time to report this bug and helping to make Ubuntu better. The issue you are reporting is an upstream one and it would be nice if somebody having it could send the bug to the developers of the software by following the instructions at http://wiki.documentfoundation.org/BugReport . If you have done so, please tell us the number of the upstream bug (or the link), so we can add a bugwatch that will inform us about its status. Thanks in advance.

description: updated
Changed in libreoffice (Ubuntu):
importance: Undecided → Medium
status: Confirmed → Triaged
Changed in df-libreoffice:
status: New → Incomplete
karaluh (karaluh) on 2012-04-16
Changed in df-libreoffice:
importance: Undecided → Unknown
status: Incomplete → Unknown
summary: - Calc makes cells protected when it shouldn't
+ [Upstream] Calc makes cells protected when it shouldn't

Reproducible, tested using Linux Mint 17 x64 with LibreOffice Version: Build ID: f511a2915ed856f048fd7dd91fd9f7537b1e0479

* Open Calc
* Right click on Cell A1 > Format Cells...
* Tab 'Cell Protection' > uncheck 'Protected' > OK
* Right click on the sheet1 tab > Protect Sheet...
* Enter a password and click OK

* From http://www.ubuntu.com/ copy 'Open source, OpenStack software and tools for private and public clouds.'
* In Calc select cell A1 > Ctrl+V to paste

Behavior: try to right click on A1. It only has the context menu of a protected cell. If you unprotect the sheet again, and go again to the 'Cell protection' (steps above) you'll see the 'Protection' is checked again.

Kind regards,

Changed in df-libreoffice:
importance: Unknown → Medium
status: Unknown → Confirmed
Adolfo Jayme (fitojb) on 2015-04-24
no longer affects: openoffice.org (Ubuntu)

** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of LibreOffice (4.4.1 or later): https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior

If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case)

If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)


2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword

Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for your help!

-- The LibreOffice QA Team This NEW Message was generated on: 2015-07-18

I could not paste into the cell, but the checkbox for Protected never got checked.
Perhaps this could be closed?

Win 7 Pro 64-bit Version:
Build ID: 186f32f63434e16ff5776251657f902d5808ed3d
TinderBox: Win-x86@39, Branch:master, Time: 2015-10-16_09:42:47
Locale: en-US (fi_FI)

Still repro on Linux.

Build ID: Arch Linux build-3
Locale: fi-FI (fi_FI.UTF-8)
Gnome Shell 3.18.1

Changed in df-libreoffice:
importance: Medium → Low
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.