Hi there Eike Many thanks for taking the time to steer me to the solution to my problem. There is an awful lot of Open Office I have yet to explore obviously! John B
Date: Mon, 6 Jun 2005 14:44:29 +0200 From: Eike Rathke <[EMAIL PROTECTED]> To: [email protected] Message-ID: <[EMAIL PROTECTED]> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Subject: Re: [users] Calc - Autocorrect Hi John, On Sat, Jun 04, 2005 at 12:23:13 +0100, John Barman wrote: > An example of what I mean in more detail, is if I have a cell > in a spreadsheet formatted 'text', and the first entry in the column > for "J. Smith" reads "J. Smith-Order No. 123456 etc", then every entry > for "J. Smith" after that initially completes the same full entry > [...] > the option to turn the feature on or off.. is either Tools.CellContents.AutoInput or to precede the input with a leading single quote ', which doesn't become part of the cell content. Eike -- OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD
