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.
For unsubscribe instructions e-mail to: firstname.lastname@example.org
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy