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
Created attachment 104992 [details] More than one option available
Setting as enhancement and UNCONFIRMED.
UX -- something for y'all to figure out :-)
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.
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.
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.
We're replacing our use of the 'ux-advise' component with a keyword: Component -> LibreOffice Add Keyword: needsUXEval [NinjaEdit]
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. https://help.libreoffice.org/Calc/Fill_Series https://help.libreoffice.org/Calc/Automatically_Calculating_Series
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.
*** Bug 114970 has been marked as a duplicate of this bug. ***
*** Bug 129034 has been marked as a duplicate of this bug. ***
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 Description: 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.