Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.