Auto numbering of row in table?

cwchia · Posted: Tue Feb 10, 2004 3:14 am Post subject: Auto numbering of row in table?

I have been trying to make cells that automatically insert consecutive numbers down the column. EG <C2> is numbered as 1, <C3> is numbered as 2 and so on. I tried to highlight the range of cells and click and the numbering icon is greyed out. Am I missing something or this feature is not present in OOo?

Issue 12102

cwchia · Posted: Thu Feb 12, 2004 12:56 am Post subject:

Do you knwo how tedious to manually insert the row number, re arrange the rows if you have inserted or deleted some rows in a big table!!!?

Crying or Very sad

JohnV · Posted: Thu Feb 12, 2004 5:26 am Post subject:

Hi cwchia,

It doesn't appear that you can number an existing set of rows in a straight forward manner however if you start numbering in row two and then add additional rows they continue the numbering.

To number a set of exiting rows create the numbering in another table then copy & paste. Don't know how stable is one is.

Back to another subject. Under Windows 98, when I first attempt to put a spreadsheet item into a Writer doc as a DDE field OO crashes. Upon recovery the field is there and adding additional ones does not cause another crash. Have you experienced this? BTW, congratulations on solving this one when no one else could!

cwchia · Posted: Thu Feb 12, 2004 7:28 pm Post subject:

gearond · Guest

Select all the cells that you want to fill. Then go to [Edit][Fill][Series] The starting value, increment, etc are all there. I did numbers, I don't know if it will do more complex ones like A0-A9, then B0 ....

gearond · Guest

See [Tools][Options][Spreadsheet][Sort LIsts]

8daysaweek.co.uk · Super User Joined: 29 Nov 2003 Posts: 2130 Location: UK

gearond,

The method you describe works for a spreadsheet (Calc) but cwichia was referring to a table in Writer.

If you look at the top of the page when reading a thread there is a line which tells you the forum the post is from (in case you came here from [New Posts] or somewhere):
OOoForum.org Forum Index -> OpenOffice.org Writer.

Good to see you chipping in here though Smile

_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site

cwchia · Posted: Wed Feb 25, 2004 11:36 pm Post subject:

Hi James and gearond,

I spent a good one minutes reading and re-reading the writer menu and failed to find the menu entry described by gearond until I scroll down to read James' post... Smile

Anyway thanks for your thoughts pals.

Please vote for the issue linked to my earlier post. Very Happy

shambhagwat · General User Joined: 07 Jul 2010 Posts: 7

Edit > Fill Series facility is available in Calc but not available in writer.

So, first use this facility in calc and fill the series as per your requirement.

Then select the above series and copy it (ctrl + C)

Open a new writer document.
Click on Edit>Paste special.
Select Formatted Text (RTF)

The series will be pasted.
The pasted Series is now in table format.
Select the newly pasted series.
Copy it. (ctrl + c)
Close the newly opend document.

Open your main document and select the cell where you want the starting point of the series.
Past it. (ctrl+ v)