Bug 45061 - EDITING: drag-fill works only linearly (cannot fill both directions at once)
Summary: EDITING: drag-fill works only linearly (cannot fill both directions at once)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.4 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: AutoFill
  Show dependency treegraph
Reported: 2012-01-21 16:21 UTC by ChrisMiami
Modified: 2022-03-15 17:42 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description ChrisMiami 2012-01-21 16:21:03 UTC
drag-fill works only linearly (cannot fill both directions at once)
Comment 1 sasha.libreoffice 2012-05-10 23:44:29 UTC
Thanks for new idea
Currently we should drag first in one direction then in another. This may have reason. By default Calc does auto-increment during drag. By separate dragging in different direction we can control incrementing of values. Vertical and horizontal separately.
Comment 2 Jared 2012-08-15 18:43:29 UTC
Confirm that this is still present in

MS Excel allows for this two-way expansion of filling cells.  So there may be user who expect the same experience.  Google Spreadsheets operates the same as LibreOffice.
Comment 3 BogdanB 2021-07-31 08:28:22 UTC
Repro. Retested in Version: / LibreOffice Community
Build ID: 5aa74aa1e6fac571f99146ebcb6adc9feb1459ad
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-07-28_19:35:14
Calc: threaded
Comment 4 AndreasHengst 2022-03-15 17:42:13 UTC
Confirm present in
Menu > Sheet > Fill Cells, also only offers Down or Right or Left or Up.

Documentation (Calc Guide 7.0) contains this phrase: "Click and drag in the direction you want the cells to be filled, vertical or horizontal." [not both apparently]

So if this non-bug ends up being an Enhancement, it affects several spots.

Version: (x64) / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

(I see same behavior on Mac - Calc