Re: [libreoffice-users] Curly apostrophe

At 09:15 13/12/2012 -0800, Karen DInse wrote:
> Using Calc, a spreadsheet created in Excel 2003 is opened. A column 
> within the spreadsheet is formatted as Number, General. The user is 
> trying to enter number of inches (27.5' S/W Pin) using the 
> apostrophe to indicate inches. They are using Times New Roman as the 
> font. The apostrophe is showing as a curly apostrophe, but the user 
> wants it to be straight. (27.5' S/W Pin) (unfortunately these both 
> show as straight apostrophes here).
>
> I tried changing the font, but that didn't work. I've tried changing 
> the column to text, but that didn't work either. Is there a way to 
> change curly apostrophes to straight ones?

Yes.  There are two alternatives:

o Calc sees the "correction" from a straight quote to a typographer's 
one as a separate action from typing the quote itself.  So if, 
immediately after typing the quote, you go to Edit | Undo (or 
Ctrl+Z), you can undo the correction and keep the straight quote you typed.

o If you wish to disable this automatic correction (for all documents 
and all types of document), remove the tick at Tools | AutoCorrect 
Options... | Localized Options | Replace.

Incidentally, one tick mark is feet; two is inches.

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