Bug 65198 - EDITING: No autofill to add sequential Latin alphabet letters in cells
Summary: EDITING: No autofill to add sequential Latin alphabet letters in cells
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: AutoFill
  Show dependency treegraph
Reported: 2013-05-31 03:13 UTC by Stéphane Guillou (stragu)
Modified: 2023-08-01 15:55 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 Stéphane Guillou (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 Stéphane Guillou (stragu) 2013-06-05 05:51:28 UTC Comment hidden (obsolete)
Comment 3 Stéphane Guillou (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 Stéphane Guillou (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 Stéphane Guillou (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 Stéphane Guillou (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 Stéphane Guillou (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 Stéphane Guillou (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 Stéphane Guillou (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?
Comment 17 QA Administrators 2023-08-01 03:16:43 UTC Comment hidden (obsolete)
Comment 18 Stéphane Guillou (stragu) 2023-08-01 15:55:43 UTC
Latin alphabetical autofill was not present in OOo 3.3, so marking as inherited and enhancement.

(In reply to BogdanB from comment #16)
> Maybe a list of Latin letters to be added as the defualt Lists?

I think that's a nice and easy solution, having both lowercase and uppercase lists by default.
If someone doesn't like it, we can offer two solutions:
- just like for numbers, use the Ctrl key so it doesn't increment
- delete the sort list in the options