[TriLUG] openoffice question

[Ryan Leathers]

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.