Inserting consecutive numbers in a table column

JRO · Newbie Joined: 02 Feb 2009 Posts: 1

To start with I would like to insert consecutive numbers down a column in a table.

And then if it is possible to create Product Numbering eg CAR001, CAR002, CAR003... to whatever.

JohnV · Posted: Mon Feb 02, 2009 6:26 am Post subject:

Put a number or text + number in a cell, move cursor to the bottom right of the cell until it changes to a cross hair, click and drag down.

bmetcalf · Posted: Mon Feb 02, 2009 4:30 pm Post subject:

This sounds great, but I can't seem to get a crosshair. What am I missing?

Bruce A Metcalf
OpenOffice 2.4.1 under Debian Lenny

JohnV · Posted: Tue Feb 03, 2009 7:43 am Post subject:

Oops, your in Writer not in Calc but we can set up a Writer table that way using Calc.

In Calc go to cell A1 (or wherever you want) and do as I said. Now select the numbers and any other columns that you will want in Writer and copy. Go to Writer and do Edit > Paste Special > Unformated text. Select everything that was pasted then do Table > Convert > Text to Table and accept the defaults.