We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How do I turn off direct formatting in Calc? [closed]

asked 2018-03-09 03:08:22 +0200

scottishgent gravatar image

updated 2020-09-23 13:24:57 +0200

Alex Kemp gravatar image

In LibreOffice Calc, when entering numbers with a suffix to indicate order, the suffix is automatically changed to superscript format. I can use the "Clear Direct Formatting" tool to return the superscript to normal text, but I would like to simply turn off the direct formatting for the entire sheet. I have already tryed to clear direct formatting for a range but when I make an entry inside the range, the direct formatting appears again. I have checked under the Format menu and the Tools -- Options menus and was not able to find anything suitable. Is it possible to turn off direct formatting for a range or sheet?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-04-23 17:41:19.750483

1 Answer

Sort by » oldest newest most voted

answered 2018-03-09 05:15:25 +0200

KH gravatar image

updated 2018-03-09 05:17:48 +0200

Your problem is not direct formatting, but AutoCorrect. Go to Tools > AutoCorrect Options > Localized Options and turn off the setting "format ordinal number suffixes".

Note: These settings are global. I don't think it's possible to configure them "by sheet" or otherwise.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-03-09 03:08:22 +0200

Seen: 735 times

Last updated: Mar 09 '18