hyperformula
hyperformula copied to clipboard
Sequence detection (e.g. for dragging the fill-handle in UI apps)
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