https://bugs.documentfoundation.org/show_bug.cgi?id=152665
Bug ID: 152665
Summary: Fill cells (e.g. Fill down) not working on
single-column/single-row selection discontinuous
ranges of cells such as e.g. after applying autofilter
(filtered cells)
Product: LibreOffice
Version: 7.3.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: temporary2...@homolog.de
Description:
There are multiple functions to fill cells, but all are disabled, when a
discontinuous range of cells is selected. This makes it impossible to fill such
a range with a value.
At least simple cases should work: E.g. on discontinuous single-column
selections, it is expected that "Fill down" or "Fill up" works by skipping the
unselected/hidden/filtered out cells. Similar on discontinuous single-row
selections.
But the "Fill cells" functions should also work on multi-column / multi-row
selections.
And there is no workaround for this (e.g. pasting does not work either, but
pastes the value from the clipboard to the first cell only instead of to all
cells selected).
I declared severity as "Enhancement request", but as this contradicts the
expectations of the user on what Calc should do, this could also be considered
a bug in terms of user experience.
Steps to Reproduce:
Variant 1 (Fill cells):
1. Start with a new Calc document
2. Write "A" into cell A1
3a. Select cells A1, A3 and A5.
or
3b. Select cells A1, C1 and E1.
Variant 2 (Paste):
1. Start with a new Calc document
2. Copy the text "A" to the clipboard
3. Mark a discontinuous range of cells (e.g. one of those given in steps 3a or
3b above)
4. Paste
Actual Results:
Variant 1: Nothing can be done to fill the range - all Fill cells functions are
disabled
Variant 2: Past only fills the top left cell.
Expected Results:
There should be any way to fill a discontinuous range of cells. Either using
the "Fill cells" functions or by pasting a single-cell value from the
clipboard.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.3.5.2 (x64) / LibreOffice Community
Build ID: 184fe81b8c8c30d8b5082578aee2fed2ea847c01
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: en-GB
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug.
