Hi Ryan,
Try this:
Before entering any numbers, select the column and format the cells
(format / cells)
Choose 'user defined' and enter the first three octets of the IP address
in a string as below:
"192.168.0."#
Enter '1' in the first cell and '2' in the second.
Select both cells and drag the handle down
Voila!
Not as slick as the method you've used in Excel, but it gets the job done.
tc
Ryan Leathers wrote:
Any openoffice whiz-kids able to 'splain this to me?
I have used excel in years past to create a quick list of sequential IP
addresses by typing the first and then dragging that cell to generate
the next 254.
In openoffice, this same procedure increments the value of the first
octet rather than the fourth.
Do I need to create some custom formatting somewhere to recognize and
treat IP addresses in a useful way? Surely I'm not the first person to
encounter this with openoffice.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
