Bug 68047 - EDITING: fill with series isn't working without selecting of cell group
Summary: EDITING: fill with series isn't working without selecting of cell group
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) Master
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: AutoFill
  Show dependency treegraph
Reported: 2013-08-13 09:50 UTC by isbk
Modified: 2021-07-31 08:45 UTC (History)
3 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 isbk 2013-08-13 09:50:00 UTC

I wanted to make a series from 1 to 2048 step by 1 in LibreOffice Calc.
This menu active only if I select min. 2 cell, but it cannot fill the range with the required values. It is a very annoying bug. If I enter the start value and the final value and the step value, why should I select the range before it?

I think it would be a base function.

The demand: select a cell, in the edit menu-fill-series, enter the required values, ok.

If there is any solution for this missing function, please inform me.


Comment 1 pierre-yves samyn 2014-01-25 17:15:33 UTC

I reproduce on windows 7/64 with Version:
Build ID: c63c03decdf780d8fb80823950665b782ec9ecd0

I set status to New but change Importance to Enhancement: 

This is not a bug but the expected feature as specified in help
"Before filling a series, first select the cell range."

Note: an easy way to select is to type the references in the "Name box"

Comment 2 BogdanB 2021-07-31 08:45:02 UTC
I tried with selecting 2 cells and it only fill the 2 cells selected.

The only way I could fill all 2048 cells was to select all the column (click on column letter in the top) and apply this fill function.

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