hyperformula icon indicating copy to clipboard operation
hyperformula copied to clipboard

Sequence detection (e.g. for dragging the fill-handle in UI apps)

Open sequba opened this issue 4 years ago • 0 comments

Description

Many popular spreadsheet applications have the ability to detect the arithmetic/geometric/weekdays/etc sequences and fill the destination range by the continuation of a sequence. E. g.: 1,2,3 -> 4,5,6,7... Monday, Tuesday -> Wednesday, Thursday, ... "Day 1", "Day 2" -> "Day 3", "Day 4"...

We need a function that can return the continuation of a sequence given a few first elements.

Links

#887 https://superuser.com/questions/1334032/what-exactly-is-excels-auto-fill-algorithm

sequba avatar Feb 10 '22 16:02 sequba