Bug 65198 - EDITING: No alphabetical autofill to add sequential letters in cells
Summary: EDITING: No alphabetical autofill to add sequential letters in cells
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: AutoFill
  Show dependency treegraph
Reported: 2013-05-31 03:13 UTC by stragu
Modified: 2021-07-31 08:39 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description stragu 2013-05-31 03:13:08 UTC
Problem description: 

I feel like this was not a problem before, for some reason...
When adding a letter and then drag-and-dropping the autofill corner, it autofills only the same letter. If doing the same with two sequential letters (to somehow "hint" LibreOffice), it just repeats the sequence over and over instead of continuing it.

Steps to reproduce:
1. Add a letter in a cell, click outside
2. Drag and drop from the cell's autofill corner towards any direction

Current behavior:
No sequential letters are added, only the same letter is repeated

Expected behavior:
There should be a default behaviour that autofills the alphabet.
The user should not have to go to "Tools>Options>LibreOffice Calc>Sort lists" in order to create a custom sort list for that.

Tested on Ubuntu 13.04 64 bits with LO

Operating System: Ubuntu
Version: release
Comment 1 ign_christian 2013-05-31 07:28:21 UTC
confirm same behavior on LO (Win7 32bit)

don't know whether it's an enhancement request?
Comment 2 stragu 2013-06-05 05:51:28 UTC
Can someone try this on an older version ? I feel like I could fill cells with series of letters before without any problem...

How come it is marked as "unconfirmed" ?
Comment 3 stragu 2013-10-30 04:53:32 UTC
This is still the case in

I am setting this as "new" as no one replied, and it has been confirmed by Christian.
Comment 4 QA Administrators 2015-04-01 14:42:59 UTC Comment hidden (obsolete)
Comment 5 stragu 2015-04-18 02:28:32 UTC
I can confirm this is still the case with on KXstudio 14.04 64bits
Comment 6 QA Administrators 2016-09-20 09:24:54 UTC Comment hidden (obsolete)
Comment 7 stragu 2016-09-20 12:20:44 UTC
I can confirm that this is still the case with LO (Build ID: 1:5.1.5~rc2-0ubuntu1~trusty1) on KXStudio 14.04
Comment 8 stragu 2017-08-18 23:14:05 UTC
reproduced in current still version:

Build ID: 50d9bf2b0a79cdb85a3814b592608037a682059d
CPU Threads: 2; OS Version: Linux 3.13; UI Render: default; VCL: kde4; Layout Engine: new; 
Locale: en-GB (en_GB.UTF-8); Calc: group
Comment 9 QA Administrators 2018-10-29 03:58:41 UTC Comment hidden (obsolete)
Comment 10 stragu 2018-10-29 06:51:48 UTC
confirmed in 6.0 branch

Details of my system:

Build ID: 1:6.0.6-0ubuntu0.18.04.1
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_GB.UTF-8); Calc: group
Comment 11 stragu 2019-07-11 12:47:55 UTC
Still present in this version:

Build ID: 41ac97386aba908b6db860cfb4cfe2da871886ae
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-US
Calc: threaded
Comment 12 Andreas Heinisch 2021-03-22 09:10:00 UTC
Just a question, how this should work in practice:

Should this only work for the latin alphabet? For instance, if I start with "A" I can drag till "Z", and from "a" to "z". Or should it just add +1 to the unicode table? For instance, after Z there would be "[".
Comment 13 stragu 2021-03-23 00:41:28 UTC
Hi Andreas

Yes, as a speaker of languages that use the Latin alphabet, my original idea was to autofill the Latin alphabet, but I can't see why another sequential script couldn't behave similarly.

I'm not sure extending this to the whole unicode table is something that would be desirable. It could be useful to some, but I think it would just be overwhelmingly outweighed by the confusion most would feel when they see such a sequence autopopulate.
Comment 14 Andreas Heinisch 2021-03-23 07:19:03 UTC
Thank you for the clarifications! What about, if we reach the last letter of the alphabet and dragging further? How should LO react?

A ... Z Z Z Z or A ... Z A B ... Z?
Comment 15 BogdanB 2021-07-31 08:38:00 UTC
For customs list the elements are repeating again after the list ends.

The same. Retested with 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 16 BogdanB 2021-07-31 08:39:47 UTC
Maybe a list of Latin letters to be added as the defualt Lists?