[plug] OO Calc question

[Steve Boak]

On Thu, 22 Oct 2009 08:27:57 pm Ari wrote:
> Steve Boak wrote:
> > Hi All
> >
> > I'm trying to create a simple mailing list in OO Calc, but every time I
> > enter an email address into a cell it changes the cell appearance to a
> > button with a link to maillto:<email at address> as in the attached image. I
> > want it to display as a simple text string.
> >
> > The column is set to text format, but that doesn't seem to help. The only
> > option that makes the column look right is selecting default formatting
> > on the cell, but then if I change the contents at all it jumps back to
> > button mode.
> >
> > Can anyone throw a little light on this strangeness?
> >
> > Steve
> >
> > _______________________________________________
> > PLUG discussion list: plug at plug.org.au
> > http://www.plug.org.au/mailman/listinfo/plug
> > Committee e-mail: committee at plug.linux.org.au
> 
> Hi Steve,
> 
> I don't have a copy of OO to work with right now, but from memory it
> sounds like one of the autoformatting functions in calc is taking
> precedence over everything else. I'd try first turning off
> autoformat/autocorrect altogether and see if that solves the issue. If
> so, turn it back on and go through the options until you find the one
> responsible. Sorry I can't be more specific right now.
> 
> Good luck,
> 
> Ari

Thanks Ari, close to what I ended up with as the best solution. Go to 'Tools' 
'AutoCorrect Options', select the 'Options' tab and untick the 'URL 
Recognition' box. I know it will affect URL recognition in writer as well, but 
that's fine with me as I didn't like it there either!

For information, I got the answer from 
<http://www.granneman.com/techinfo/tools/openofficeorg/autocorrectandautoformat.htm>
it's written for OO 1.1, but the descriptions of the options is one of the 
clearest I have seen.

Steve

-- 
Steve Boak, (08) 9756 0662, P.O. Box 240, Nannup, WA 6275
Nannup Telecentre IT Support, Phone (08) 9756 3022
Engin VOIP number (08) 6461 6187 (local number in Perth)