Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

AutoCorrect and fractions

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/viewtopic.php?f=6&t=68792), 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/

AutoCorrect and fractions

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/viewtopic.php?f=6&t=68792), 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/