Auto sequential numbering

Hello
I am looking to create a Form spread sheet with a 5 digit sequential number that I can put onto our server that others can access and fill out. I am looking to create a Macro so that when the file is opened or saved or in some manner, that 5 digit sequential number will auto advance. Is there any thing out there like that available.

I am looking for a single cell to have a sequential number that advances upon opening or saving. What I am attempting to do, is to create a Purchase order form that I can put onto our server. We have a dozen people whom generate Purchase orders. I have created an interactive form fill PDF file, but I can’t get an auto advance sequential number to work with it. As of now we buy carbon Purchase order form books that are numbered. So alas, we get our number from this. Looking to do away with paper as much as possible so looking to do something digital without spending money on software. So, my attention turned towards generating some thing in LibreOffice using a Macro, if this is possible.

Thanks in Advance.

Hi @sl4grl,

What sequential numbering do you want to increase? Are you looking for a new file to be created:

spreadsheet_00001.ods
spreadsheet_00002.ods
spreadsheet_00003.ods
...

Or do you want increasing numbering in a column in the spreadsheet?

Or something else?