Skip to content

Generate equidistant Date&Time and integer values in the spreadsheet

Alexander Semke requested to merge work/generate-datetime-values into master

Description

This MR implements the generation of equidistant DateTime values ("time series") and integer values in the spreadsheet which was possible for double values only in the past. The dialog allows to generate numeric and datetime values at the same time (numeric and datetime columns were selected in the spreadsheet and the "generate equidistant values"-dialog was called):

grafik

In case only numeric columns or only datetime columns were selected, the relevant part only is shown: grafik

grafik

With this MR it's also possible now to generate values by fixing the number of them and the increment at the same time (either fixing the number of fixing the increment was possible in the past). This allows to generate data range like "generate 100 values starting from 0 and increasing by 5" or "generate 20 datetime values starting from today and increasing by 1 day", etc:

grafik

with the result

grafik

Furthermore, we properly handle the conversion of the column modes when needed. For example, "generate equidistant values" was called for an integer column but the increment is a float number and the column needs to be converted to "Double", or the integer values go beyond the max int value and the column mode needs to be changed to "Big Int".

Conformity

When external dependencies are removed

  • Reporting to ...
Edited by Alexander Semke

Merge request reports