Re: [libreoffice-users] Entering numbers as text in Calc (single quote)

On 15 September 2012 10:35, Brian Barker <b.m.barker@btinternet.com> wrote:
> At 10:02 15/09/2012 +0100, Leon Stringer wrote:
> > In the past you would prefix numbers with a single quote to get them
> > treated as text in Calc (and other spreadsheets), i.e. you'd type '123 and
> > see 123 in the cell with the contents left-aligned (in Western LTR languages
> > at least).  Now auto-correct appears to be changing the single quote to a
> > left single quote so it appears in the cell, i.e. you see '123 in the cell.
>
>
> I'm surprised you say "Now": this behaviour was certainly the case in
> OpenOffice, before LibreOffice existed.  At least, that was my experience on
> Windows XP.

My mistake: you're quite correct.

> > ... but, does anyone know how number should now be entered as text in
> > Calc?
>
> Yes.  You can switch off the AutoCorrect behaviour as above (and easily
> switch it on again after a particular period of data entry if you prefer).
>
> But there is another workaround which may be more convenient, especially if
> you normally choose to rely on the AutoCorrect behaviour with quote marks.
> Calc sees the typing of the quote mark and the subsequent automatic
> correction as two separate actions, so you can achieve what you need by
> undoing the second action and leaving just the first.  Immediately after you
> type the quote mark (and see the correction), go to Edit | Undo - or, more
> easily, press Ctrl+Z - and you will see the quote mark changed back to a
> straight quote.  Then enter your number.

Brian: That's a complete answer, thanks very much for your help!

> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted