| View previous topic :: View next topic |
| Author |
Message |
kingkronk
Newbie
Joined: 13 Nov 2006
Posts: 2
Location: Canada
|
 Posted: Mon Nov 13, 2006 12:13 pm Post subject: Auto Number Counting in OOo Writer... |
 |
|
Hi All,
I am trying to get a template to auto number. For example, I have a quotation template done up and one of the sections (table cell) has a quote number in it. It currently is set to 0532. I want this number to count up (0533 for next quote, 0534 for the next one and so on...) every time I do up a new quote for someone. Is this possible and how?
I have tried over and over and thus far am only changing it manually (deleting the last digit and enter the new one). is it possible to do something like this?
Any help would be appreciated.
Thank you.  |
|
| Back to top |
|
 |
Hagar Delest
Super User
Joined: 06 Feb 2006
Posts: 5167
Location: France
|
| Posted: Mon Nov 13, 2006 1:06 pm Post subject: |
|
|
You can use a field: menu Insert>Fields>Others (or CTRL + F2), Variables tab and select the Number range type. Give it a name in the field at the bottom and a value for the first entry. Check that the numbering format is the right one and then click on Insert.
To add new numbers, you can leave the dialog open. Clear the Value field, place your cursor in the new location and click on Insert. It will increment by 1 from the previous entry.
But I didn't managed to get the zero displayed. Either someone will have a better idea or you add manualy the zero before inserting the field.
_________________
Now on the EN user community forum |
|
| Back to top |
|
|
foxcole
Super User
Joined: 19 Jan 2006
Posts: 2771
Location: Minneapolis, Minnesota
|
| Posted: Mon Nov 13, 2006 1:15 pm Post subject: Re: Auto Number Counting in OOo Writer... |
|
|
| kingkronk wrote: | Hi All,
I am trying to get a template to auto number. For example, I have a quotation template done up and one of the sections (table cell) has a quote number in it. It currently is set to 0532. I want this number to count up (0533 for next quote, 0534 for the next one and so on...) every time I do up a new quote for someone. Is this possible and how?
I have tried over and over and thus far am only changing it manually (deleting the last digit and enter the new one). is it possible to do something like this. |
What I've done in both Word and Writer is simply apply a numbered paragraph style to the number column, and just not type any text there. Tabbing to create a new row, or inserting a row, numbers it correctly. But I don't know whether the numbering can accept a leading zero. I'm in a bit of a rush at the moment, but if needed, I can look into it a little more thoroughly later.
_________________
Cheers!
---Fox
WinXP Pro SP2, OOo Portable 2.3.1, OOo local 2.4 RC4
New OpenOffice forum: http://user.services.openoffice.org/en/forum/
Manuals: http://documentation.openoffice.org/manuals/index.html |
|
| Back to top |
|
|
acknak
Moderator
Joined: 13 Aug 2004
Posts: 4295
Location: ~ 40°N,75°W
|
| Posted: Mon Nov 13, 2006 5:44 pm Post subject: |
|
|
| foxcole wrote: | | ... simply apply a numbered paragraph style to the number column, and just not type any text there. |
There is unfortunately no option to apply a number format to the list numbers, so I don't think this will work.
| Hagar wrote: | | You can use a field: menu Insert>Fields>Others (or CTRL + F2), Variables tab and select the Number range type. Give it a name in the field at the bottom and a value for the first entry. Check that the numbering format is the right one and then click on Insert. |
If you use a regular variable (instead of a Number range), then you can apply a much more flexible level of number formatting. Just enter an expression in the "Value" field. If your variable is named "QNum", then enter "QNum+1" in the "Value" field and it will auto-increment each time you insert it.
In the "Number Format" list, click "Additional formats...", then you can change the "Leading zeroes." E.g. if you set the "Leading zeroes" to 4, then 5 will be shown as "0005", and 534 will be displayed as "0534".
If you care about the numbers, i.e. if you want the number for a particular quotation to never change, then you may not want to use a dynamic method like this. It's too easy to add or delete something and cause all the following numbers to shift.
Also, you might want to think about doing this in a database. That would give you auto-incrementing numbers, and it's really easy to pop up a database, locate a specific quotation and then drag it into a document. |
|
| Back to top |
|
|
Hagar Delest
Super User
Joined: 06 Feb 2006
Posts: 5167
Location: France
|
| Posted: Mon Nov 13, 2006 11:25 pm Post subject: |
|
|
Right, thanks acknak ! I'd not tried this (by the way, in case you search - like me - the regular variable, the exact name is Set variable).
_________________
Now on the EN user community forum |
|
| Back to top |
|
|
kingkronk
Newbie
Joined: 13 Nov 2006
Posts: 2
Location: Canada
|
| Posted: Tue Nov 14, 2006 6:06 am Post subject: |
|
|
Thanks for the replys! I'll try those options you gave.
The reason I would like this is sometimes I forget to change the quote number at the top and two clients get the same number... so automating it for me would eliminate this little problem.
Thanks again!
_________________
If you don't have time to do it right, you must have time to do it over. - Anonymous. |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
