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

Ask Your Question

Calc: AutoCorrect and fractions

asked 2018-07-14 04:39:51 +0200

BillC gravatar image

updated 2021-06-05 17:28:19 +0200

Alex Kemp gravatar image

Calc wants to change my fractions in cells from "1/4" to "¼" and I want to stop that for this document or range of cells in document. I can get the desired results by going to Tools > AutoCorrect Options > Options > Use replacement table: OFF, (https://forum.openoffice.org/en/forum...), but I want to do this automatically for this document, and if possible, without affecting the users preferences for other documents. Can this be done some way in a macro?

Sorry for oo link, but it seemed like a clear example of what I wanted to do. Not relevant to above but same project, https://ask.libreoffice.org/en/question/159490/macro-on-leaving-a-cell/

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-07-14 18:03:22 +0200

erAck gravatar image

Unfortunately currently there is no other way to prevent the replacement to happen than disabling the AutoCorrect option or remove the specific 1/2 and 1/4 entries in the replacement table.

In version 6.1 it will be possible to press Ctrl+Z once after cell input was closed to undo the replacement.

edit flag offensive delete link more


I was afraid that was true, had to add code for those cases to solve my problem.

BillC gravatar imageBillC ( 2018-07-26 02:41:45 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-14 04:39:51 +0200

Seen: 338 times

Last updated: Jul 14 '18