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
