Add column - Index column, i.e. Table.AddIndexColumn, shall create whole numbers (int) instead of decimal numbers (float)
Currently the Table.AddIndexColumn() functions creates values of type decimal (floats). I see no reason for creating decimal numbers since the incremental steps can't be set to decimal number, nor the initial value can be set to a decimal value:
Table.AddIndexColumn(table as table, newColumnName as text, optional initialValue as nullable number, optional increment as nullable number) as table
The documentation does not say what type the new column will have, but now it's created as decimal number.
The recommendation will be that Microsoft either changes the type of the generated column, or extends the parameter set with a type so we can define the type as integers (int64) instead
As there can't be anu reason for the index column to have float values, this is likely to be considered as an bug
Kenneth Barber commented
I feel that Table.AddIndexColumn, by default, should use the smallest integer type that it needs to creates all of the indexes. For example, if your table has only 100 rows, then Int8.Type would be used and not Int64.Type.