Bug 82424 - Control use of direct formatting in Fill (Autofill) actions - (suggestions to resolve in comment#13)
Summary: Control use of direct formatting in Fill (Autofill) actions - (suggestions to...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
: 114970 129034 (view as bug list)
Depends on:
Blocks: Floating-Menu
  Show dependency treegraph
Reported: 2014-08-10 17:56 UTC by kirubhakarandurai
Modified: 2020-05-03 21:18 UTC (History)
11 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.
Comment 11 Buovjaga 2020-04-27 16:57:04 UTC
*** Bug 114970 has been marked as a duplicate of this bug. ***
Comment 12 Buovjaga 2020-04-27 16:57:12 UTC
*** Bug 129034 has been marked as a duplicate of this bug. ***
Comment 13 Cor Nouws 2020-05-03 21:18:59 UTC
Suggestion to resolve this (from https://bugs.documentfoundation.org/show_bug.cgi?id=114970#c4) :

 Alexander Ilyin 2018-01-17 07:36:20 UTC

Shift key will be great!

That way you can add even more combinations.
-Shift key in addition to autofill selection (for ascending values) to keep original formating 
-Ctrl+autofill selection (for identical values)
+Shift+Ctrl+autofill - keep original formatting and for identical values

Suggestion to resolve this (https://bugs.documentfoundation.org/show_bug.cgi?id=129034#c0) 

 Michael 2019-11-26 08:29:17 UTC

In Excel, the user can autofill data only, formatting only, equations only, etc. by right-click dragging.  Until LibreOffice has this same functionality, I cannot use it.