https://bugs.freedesktop.org/show_bug.cgi?id=63649
Priority: medium
Bug ID: 63649
Assignee: [email protected]
Summary: EDITING ? Cut and Paste operations on data input cells
corrupt formulae in adjacent protected cells.
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
Created attachment 78145
--> https://bugs.freedesktop.org/attachment.cgi?id=78145&action=edit
A simulation of the alleged bug using a small part of original spreadsheet.
Part of a much larger spreadsheet is used to input competitors names in pairs
alongside an appropriate pair number on a club score sheet. To save typeing,
all club members names are stored in protected cells. When required, each
member's name is copied from its protected cell and pasted into an un-protected
cell in the same row as his pair number, his score, and his placing. His
partners name is likewise pasted alongside. The list of members names and the
un-protected entry cells are not part of the printable area of the score sheet.
Within the printable area, a double column of cells contains formulae which
simply concatenate; member's name + ampersand + partner's name.
All works well when using just copy and paste are used. BUT if an un-suspecting
user sees that several pairings have not changed since the previous use, but
need to be moved up or down the columns, then he may attempt a cut and paste on
the un-protected columns. This modifies the source addresses in the protected
columns, and if the user is not the compiler of the spreadsheet, he will be
unlikely to be able to sort out the mess.
This seems similar to Bug ID 51757 (STATUS - CLOSED NOTABUG) but the
possibility of protected cells being modified by a legitimate operation on an
un-protected cell is surely unacceptable.
I will attach a copy of a file which simulates the affected area of the
original spreadsheet, filename BUGSHOW.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
