[Libreoffice-bugs] [Bug 114970] Autofill keep cell format mode is needed

[bugzilla-daemon]

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

Heiko Tietze  changed:

   What|Removed |Added

   Keywords|needsUXEval |
 CC|libreoffice-ux-advise@lists |
   |.freedesktop.org|

--- Comment #5 from Heiko Tietze  ---
Shift/Cmd+ sounds like a good solution; just don't use Alt as it is the
hotkey to moves the Window under Linux.

Alternatively, keep things and use the remove formatting command (ctrl+M).

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114970] Autofill keep cell format mode is needed

[bugzilla-daemon]

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

--- Comment #4 from Alexander Ilyin  ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114970] Autofill keep cell format mode is needed

[bugzilla-daemon]

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

Thomas Lendo  changed:

   What|Removed |Added

   Keywords||needsUXEval
 CC||c...@nouenoff.nl,
   ||libreoffice-ux-advise@lists
   ||.freedesktop.org,
   ||thomas.le...@gmail.com,
   ||tietze.he...@gmail.com,
   ||vstuart.fo...@utsa.edu
 Blocks||113499

--- Comment #3 from Thomas Lendo  ---
Maybe an additional modifier key can help to keep the formatting of autofilled
cells. How's about the Shift key in addition to autofill selection (for
ascending values) and Ctrl+autofill selection (for identical values)?


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 the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114970] Autofill keep cell format mode is needed

[bugzilla-daemon]

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

--- Comment #2 from Alexander Ilyin  ---
I did not find 6.1 however I have installed and tried out the dev nightly
build:
libo-60-64_2018-01-12_01.38.12_LibreOfficeDev_6.0.1.0.0_Win_x64

The autofill is still screw up my formatting and no good way to deal with it.
The only workaround with paste special described in the mentioned forum. But
paste is working well in 5.x and I believe in the earlier versions.

It helps but not too much because it is annoying to do autofill, see the
screwed up cell formats, undo, select the cells, copy, do autofill and then
select it again and do special paste with format only.

Instead it would be very useful to do autofill without cell format changes.
Just values and formulas. E.g. when user holds Alt.

According to the mentioned forum post the Excel can do that if you drag handle
using right-click. That is good way do as well.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114970] Autofill keep cell format mode is needed

[bugzilla-daemon]

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

--- Comment #1 from Xavier Van Wijmeersch  ---
In newer versions from 5.3 => 6.1 alpha there is a something like paste only
text, number or formula. In 6.1 there is even more options.
Try to install a still or fresh LO and you will have what you want

Best regards

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs