Bug 147293 - UI improvement to prevent accidental MODIFICATION of MULTIPLE selected sheets
Summary: UI improvement to prevent accidental MODIFICATION of MULTIPLE selected sheets
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.5.2 release
Hardware: All Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Sheet
  Show dependency treegraph
 
Reported: 2022-02-08 17:06 UTC by Robert Penny
Modified: 2023-08-19 04:39 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Penny 2022-02-08 17:06:31 UTC
Some might not call my problem a bug, but a known way of working with the UI. However I consider it a dangerous side-effect of a provided feature.

The first time I encountered the utility of selecting multiple sheets, it was in connection with exporting a document as PDF, and is very useful for getting defined print ranges from several sheets into the same PDF document. After doing this I then continued editing one of the sheets, and later discovered, to my horror, that I had been modifying multiple sheets. Now, even though I am aware of this behavior, I still find myself forgetting to deselect all but one sheet after exporting.

I can think of several possible ways to reduce this risk:

1) warn that multiple sheets are selected by changing the little gray bar underlining selected sheets to bright red (maybe even flashing) when multiple sheets are selected.

2) provide a global preference to prevent modifications in multiply selected sheets.

3) augment the menu for export as PDF by providing a sheet list where the user can select which sheets to export (perhaps even in which order).
Comment 1 m_a_riosv 2022-02-09 01:15:23 UTC
1 for 1)