Autofill with two instances per date

[wadeh]

I am using the following version of LibreOffice on Kubuntu 22.04 and trying to autofill a date column with dates:

Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 12; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb)
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.3
Calc: threaded

This works fine if there is one instance of each date. But if there are two instances per date, it does not work properly. Instead of two instances per date, I get four instances of each autofilled date.

For example, if I have the following column:

2023-12-07
2023-12-07
2023-12-08
2023-12-08

And I select the four entries and then drag the autofill handle, the result is:

2023-12-07
2023-12-07
2023-12-08
2023-12-08
2023-12-09
2023-12-09
2023-12-09
2023-12-09
2023-12-10
2023-12-10
2023-12-10
2023-12-10
…

Note that this problem is not specific to dates. If my columns are 1,1,2,2 with Format=General, and I use autofill, I get 1,1,2,2,3,3,3,3,4,4,4,4,…

Is there a way to get this to work?

Thanks,
-Wade

[Lupp]

Being curious:
Why do you think you need two rows per date (or per a different kind of incrementable ID-element)?

[wadeh]

I am recording a measurement that occurs twice per day.

I suppose that I could create two columns per day and have just one date instance, but I want to think about the data linearly and would prefer it in a single column.

[karolus]

for example:

A1 → 2023-12-07
A2 → 2023-12-07
A3 → =A1+1
A4 → =A2+1

and pull down from A4

[wadeh]

Excellent!

Thanks!