[TriLUG] openoffice question

[jonc]

If you start the field with a " then it seems to work fine.
  "192.168.1.1  ==>  "192.168.1.2, "192.168.1.3, "192.168.1.4, ...


Note: if you start the field with a " and end it with a " then it just
copies the same thing to each line:
  "192.168.1.1"  ==> "192.168.1.1", "192.168.1.1", 192.168.1.1", ...

It seems to be very peculiar about doing IP addresses. When I played
with it as just numbers I got something similar to your results. It just
does not understand the Numerical format used by IP addresses - even
when the formating variable is set properly. With one decimal point
(12.34) it treats it like a real number and simply adds one to each
iteration:
  12.34 ==> 13.34, 14.34, 15.34, ...

With two decimal points (12.34.56) it treats the field either like a
date (and adds one day to each iteration) or; if it's an illegal date,
it tries to treat it like a real number but adds it to the number as
though it were string... Very odd.

12.34.56 ==> .34.5613, .34.5614, .34.5615

See its treating the first "12" as though that is an integer, then it
treats the rest (".34.56") as though that were some sort of immutable
string. The result is:
  ".34.56" + (12 +1)  ==> ".34.56" + 13 ==> ".34.5613"

At least in my version of OO (v1.99 - beta 2.0)

Jon Carnes

On Mon, 2006-01-02 at 16:00, 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/
> >
> >