[Libreoffice-ux-advise] [Bug 157629] Sheet fill series also copies formats

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=157629

Stéphane Guillou (stragu) <stephane.guillou at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
           Keywords|                            |needsUXEval
           See Also|                            |https://bugs.documentfounda
                   |                            |tion.org/show_bug.cgi?id=47
                   |                            |778
     Ever confirmed|0                           |1
             Blocks|                            |113499
                URL|                            |https://ask.libreoffice.org
                   |                            |/t/fill-down-without-changi
                   |                            |ng-background-color/86737
            Version|7.5.5.2 release             |Inherited From OOo
                 CC|                            |libreoffice-ux-advise at lists
                   |                            |.freedesktop.org,
                   |                            |stephane.guillou at libreoffic
                   |                            |e.org

--- Comment #4 from Stéphane Guillou (stragu) <stephane.guillou at libreoffice.org> ---
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.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=113499
[Bug 113499] [META] AutoFill bugs and enhancements
-- 
You are receiving this mail because:
You are on the CC list for the bug.