On 12/13/2012 12:38 PM, Brian Barker wrote:
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
Very interesting, and useful. I wonder if you know that WordPerfect is
smart enough to do this automatically?
Too bad LO is not that smart.
--doug
--
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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: 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.