Description: Please add a mode to fill series either by drag and drop the field corner or by Sheet->Fill Cells->Fill Series, that only copies the content that is a formular or a countable value. Steps to Reproduce: 1. Field with value "1" 2. Vertically there are 29 empty fields left with a frame around 3. Drag and drop the field corner down to count up to "30" Actual Results: The last field with a bottom frame gets a new format without a frame. Expected Results: Only the value should be copied without the format. Reproducible: Always User Profile Reset: No Additional Info: Maybe add a mode by pressing Shift or Ctrl while doing the drag and drop to ignore the format. Add an option in the dialog of Sheet->Fill Cells->Fill Series to copy the format or not.
The current workaround is to copy the last field first, then do the fill series, then re-apply the format.
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 190059 [details] sheetFillSeries.ods
Thank you for the sample document. Reproduced in OOo 3.3 and recent trunk build. Drag to fill has same result as double-click the handle to autofill (if there is data in the adjacent column). Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: fd69b546ad36452560cb11ccb28e78632d65f045 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Some related questions that shows that other have the same frustration: - https://ask.libreoffice.org/t/fill-down-without-changing-background-color/86737 - https://ask.libreoffice.org/t/autofill-without-changing-format/36729 - https://superuser.com/questions/1685683/libreoffice-fill-down-without-affecting-format - workaround that works since OpenOffice times: https://forum.openoffice.org/en/forum/viewtopic.php?p=173077 I support having an option to not autofill the format, I can imagine many users have pre-formatted spreadsheets to fill in the data later on. I like the idea of using the Shift key, which could be used with or without Ctrl (the key used to deactivate the increment). Just copying UX/Design team for potential input.
(In reply to Massimo B. from comment #0) > Maybe add a mode by pressing Shift or Ctrl while doing the drag and drop to > ignore the format. If you press Ctrl, the function copies the value(s) rather than increasing. Using Shift in combination or not sounds reasonable, though. > Add an option in the dialog of Sheet->Fill Cells->Fill Series to copy the > format or not. A checkbox "[x] Copy format" may do the trick.