Ask Your Question
0

Calc: AutoCorrect and fractions

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

BillC gravatar image

updated 2018-07-14 19:20:32 +0200

LibreTraining 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
0

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 31 times

Last updated: Jul 14