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: [email protected]
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
