Bug 82424 - Control use of direct formatting in Fill actions
Summary: Control use of direct formatting in Fill actions
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Floating-Menu
  Show dependency treegraph
Reported: 2014-08-10 17:56 UTC by kirubhakarandurai
Modified: 2017-08-10 15:45 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:

More than one option available (189.38 KB, image/png)
2014-08-20 17:38 UTC, kirubhakarandurai

Note You need to log in before you can comment on or make changes to this bug.
Description kirubhakarandurai 2014-08-10 17:56:44 UTC

Comment 1 Joel Madero 2014-08-10 19:21:54 UTC
Please do not describe the bug in the bug title - make the bug title succinct and give reproducible steps along with observed/expected behavior. Also include information about your OS and LibreOffice.

Marking as NEEDINFO - once you do the above mark as UNCONFIRMED. Thanks
Comment 2 kirubhakarandurai 2014-08-20 17:38:14 UTC
Created attachment 104992 [details]
More than one option available
Comment 3 Buovjaga 2014-11-27 06:52:05 UTC
Setting as enhancement and UNCONFIRMED.
Comment 4 Robinson Tryon (qubit) 2014-12-21 22:30:08 UTC
UX -- something for y'all to figure out :-)
Comment 5 thoskk 2015-08-12 23:11:28 UTC
Copy with / without format is really needed, in both cases when copy/paste or dragging cells across is used.
It's quite annoying when you have change the format back if you just want to have the contents copied.
And please consider to give a choice for copying conditional formattings or not, as well.
Comment 6 Regina Henschel 2015-08-13 10:25:21 UTC
You find these options -and a lot more- in "Paste special". You can access "Paste special" from context menu, via ctrl+shift+V or via menu Edit. Do not expect, that different applications have all tools at the same place.
Comment 7 V Stuart Foote 2015-08-13 13:11:00 UTC
Believe the concern of OP is that there is not a concise GUI widget associated with a selected cell range to manipulate the fill options.

Suggest addition of the menu Fill split button to the Context menu for selected range is a reasonable and simple enhancement.

Paste Special takes care of any copy requirements. But a Fill of block or series *with or without formatting* is an issue.  The fill currently takes direct formatting of the originating selection and overrides cell style. Do not have a way to control that.

In addition to adding the Fill split button to the context men, suggest we would need a way to toggle the fill action (by block or series) without formatting--similar to what is implemented for Paste Special.
Comment 8 Robinson Tryon (qubit) 2016-08-25 05:39:03 UTC Comment hidden (obsolete)
Comment 9 Heiko Tietze 2017-08-08 15:55:09 UTC
The requested enhancement is a floating menu for the autofill function (enter 1,2,3 in adjacent cells, select them, and extend the selection with the mouse). We do not use this type of interaction with floating 'options buttons' (also known in MS Office for paste special and direct formatting) but we have the functionality per keyboard modifier (like in Excel). With ctrl being pressed the series is copied instead of extended => WFM.

Comment 10 Heiko Tietze 2017-08-10 15:45:10 UTC
We talked about the idea of floating menus in general and decided to keep it alive. Removing needsUXadvice until someone is interested in the implementation.