asked 2012-10-13 12:37:49 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
how to display an automatic number in a series as in an invoice number?
answered 2012-10-13 18:01:02 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
An easier way is to type in the cell of your first invoice number the number you want to start with. Thereafter keep that cell selected and put the cursor on the small square at the bottom right corner of the cell. Press the left mouse button and pull down. The number increases automatically by one in each cell. (if needed you can do the same pulling to the right side.) This works only for numbers not for alphabetical characters.
answered 2012-10-13 16:36:03 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
The simplest way is of course to number the first one (A1) 1, the one below =A1+1 and just copy the whole thing downwards - if you have the entries in one line. Of course, this does not account for you having to erase some. But I seem to recall that there is an auto-numbering feature somewhere?
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-10-13 12:37:49 +0200
Seen: 59 times
Last updated: Oct 13 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
