Hi David,
Right. If you reference one of the cells using my method, you'll get
only the last octet. 'Copy / paste special' will give you the whole
address. Your method is preferable, as long as the rows are correct. It
may need an adjustment if you're not starting at row 1 or address 1.
It's definitely easier to modify as well.
tc
David Chapman wrote:
Tht's a neat approach to this problem. My only beef with it is that the
value of
the cell is not 192.168.0.1 or whatever - but 1
Here is an alternate approach that addresses the above concern (formula
should be modified to suit)
In cell A1 - enter =concatenate("192.168.0.";row())
Drag down...
Dave
On 1/2/06, Anthony Chilco <[EMAIL PROTECTED]> wrote:
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]
--
My OpenOffice Calc Website
http://www.openofficetips.com
