[TriLUG] openoffice question

[Ryan Leathers]

One more suggestion by Kohei Yoshida which I don't want to neglect

The work around it would do for now is to put each octet of an IP
address into an individual cell, say, '192' in A1, '168' in B1, '1' in
C1 and '1' in D1, and use CONCATENATE cell function in cell E1 to put
them together:

=CONCATENATE(A1;".";B1;".";C1;".";D1)

and drag cell D1 down for incremental fill, and Ctrl-drag A1 through
C1 for simple fill i.e. non-incremental fill.

On Mon, 2006-01-02 at 16:00 -0500, Mark Freeze wrote:
> Ryan,
> Did you ever solve this problem?  I tried  the old excel trick of 'giving it
> a hint' by entering 10.0.0.1 in the first cell and then 10.0.0.2 in the
> second and then trying to drag it, but that only copied the first cell as
> text and repeated it.
> 
> I'd be interested inn the solution if you find it.
> 
> Thanks,
> Mark.
> 
> 
> On 1/2/06, Jason Faulkner <jasonlf at gmail.com> wrote:
> >
> > No idea. Try posting it to users at openoffice.org.
> >
> > --Jay
> >
> > On 1/2/06, Ryan Leathers <ryan.leathers at globalknowledge.com> 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.
> > >
> > > --
> > > TriLUG mailing list        :
> > http://www.trilug.org/mailman/listinfo/trilug
> > > TriLUG Organizational FAQ  : http://trilug.org/faq/
> > > TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
> > >
> >
> >
> > --
> > Jason Faulkner
> > ------------------------
> > OldOs.org Owner/Admin //
> > OpenDocument Fellowship Sysadmin
> >
> > --
> > TriLUG mailing list        : http://www.trilug.org/mailman/listinfo/trilug
> > TriLUG Organizational FAQ  : http://trilug.org/faq/
> > TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
> >
> >