[Libreoffice-bugs] [Bug 119272] New: Dangerous function : select several thumbs

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119272

            Bug ID: 119272
           Summary: Dangerous function : select several thumbs
           Product: LibreOffice
           Version: 5.4.7.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: yves30b at gmail.com

Description:
When multiple sheets are selected then any edit made to a given cell (for
example Sheet1 cell B13) will also silently be made on the other selected
sheets to that same cell (for example Sheet2 cell B13, and Sheet3 cell B13)
without any notification to the user that those changes are being propagated
throughout all the selected sheets - they may in fact be unaware that multiple
sheets are selected.

They may be unaware because it's hard to tell the difference between a selected
sheet (white tab), and unselected sheet (nearly-white tab).  One must
simultaneously select all sheets that they want printed as a single job, and
it's easy to forget that they're selected afterwards.

The ability to do this may be by design, but if so then at a minimum the user
should be notified that multiple sheets are selected and edits on any cell will
be made to all selected sheets.  In short, whenever something is done invisibly
in the background that is potentially destructive to invaluable data the user
should be always notified of the fact.  I also recommend making the tabs of
selected sheets more visibly different than unselected tabs, say perhaps making
the tab dark gray or something like green4.
The Issue Type has been changed from "Defect" to "Enhancement".  Note also that
this "Enhancement" report is also related to "Defect" report here (cell
protection broken): http://openoffice.org/bugzilla/show_bug.cgi?id=118151

There are 3 possible enhancements I can think of to the edit-propagation
feature (by "edit-propagation" I'm referring to the feature wherein the edits
of any cell of the active sheet are automatically propagated to the same cell
address of all other simultaneously selected sheets).  Ideally they'd all be
implemented.

1) An event-triggered warning.  Whenever the user selects multiple sheets they
are notified that changes to any cell made on the active sheet will
automatically be made to the same cell address on the other selected sheets.
2) Toggle the feature on/off. Ideally this feature could be a selectable option
in the "Options" dialog window.  It would be nice, for example, to be able to
select multiple sheets for printing purposes without exposing their data to
edit-propagation vulnerability.
3) Better visibility of sheet-selection status (by perhaps increasing the color
difference of selected vs. unselected worksheet tabs).  Although this doesn't
resolve the original concern, it would make the edit-propagation feature more
likely beneficial instead of potentially destructive.
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.

Performing changes that are not visible to the user is bad practice.
When multiple sheets are selected an attempt to input data into visible sheet
should break the selection of sheets and be applied to the visible sheet only.


Actual Results:
Sorry, I don't speak english

Expected Results:
Sorry, I don't speak english


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180814/5c0d1a78/attachment.html>