Insert an arithmetically incremented number into part of a Text cell

[bryant]

I need to generate a large list of IP address ranges that represent subnets: for example, I need a sequence like this:

10.1.1.1, 10.1.2.1, 10.1.3.1…10.1.254.1

When I attempt to ask LibreOffice Calc to increment this sequence, it does not work.

So I need a function that arithmetically increments only one number in the middle of other numbers, within what will ultimately be a Text formatted cell.

[karolus]

Hallo

Start with

="10.1." & ROW( A1 ) & ".1"   

and pull down …

[bryant]

elegant, worked great.