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

I am having a problem replicating this issue with 3.5.6 64-bit DEB 
install on Ubuntu 10.04.

I type '123 and get 123.
Well if I type '123+234 I get the quote.

I do have the problem with finding "Custom Quotes" as an option.  There 
a "Localize Options" that show options for quotes though.


.
On 09/15/2012 05:35 AM, Brian Barker 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.
>
> > In Getting Started with LibreOffice 3.5 it says:
> >   If "smart quotes" are used for apostrophes, the apostrophe remains 
> > visible in the cell.
> >   To choose the type of apostrophe, use Tools > AutoCorrect > Custom 
> > Quotes.
> >   The selection of the apostrophe type affects both Calc and Writer.
> >
> > But there's no such option (there's Tools > AutoCorrect Options...).
>
> Yes: at Tools | AutoCorrect Options... | Custom Quotes | Single 
> quotes, you can remove the tick from Replace in order to suppress this 
> behaviour.
>
> > I'm alarmed that a way of working that has been common in spreadsheet 
> > programs for a very long time has been changed ...
>
> It doesn't appear to me that it has.
>
> > ... 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.
>
> I trust this helps.
>
> Brian Barker


--
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