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