[Solved] Automate change I cannot disable

Discuss the spreadsheet application
Post Reply
dandr69
Posts: 1
Joined: Sun Sep 24, 2017 1:46 pm

[Solved] Automate change I cannot disable

Post by dandr69 »

Hey hguys, i have a table with a column i must enter S1, S2, S3.
Every time I type S1, it replaces automatically with 01.09.2017.
I tried disabling, Autocorrect. I disabled all Macro. I disabled any kind of replacement. It still does that.
If i hit Undo, the S1 appear, if i save, 01.09.2017 apears magically.

How can I get rid of it.
P.S. Nothing appears on S2 / S3

Update: Format as text works. Thanks
Last edited by dandr69 on Sun Sep 24, 2017 6:05 pm, edited 1 time in total.
OpenOffice 4.1.3
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Automate change i cannot disable

Post by RusselB »

Please verify that there is no entry for S1 in the Replace tab of the Auto-Correct Dialog, accessed via Tools -> Auto-Correct (select the Replace tab if necessary)
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
jrkrideau
Volunteer
Posts: 3816
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Automate change i cannot disable

Post by jrkrideau »

dandr69 wrote:Hey hguys, i have a table with a column i must enter S1, S2, S3.
Every time I type S1, it replaces automatically with 01.09.2017.
I tried disabling, Autocorrect. I disabled all Macro. I disabled any kind of replacement. It still does that.
If i hit Undo, the S1 appear, if i save, 01.09.2017 apears magically.

How can I get rid of it.
P.S. Nothing appears on S2 / S3
Is S1 exactly how you type it? I cannot reproduce the problem in LibreOffice.

It looks like AOO is interpreting it as a date.
Try formatting the cell as text before you type "S1".
LibreOffice 7.3.7. 2; Ubuntu 22.04
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Automate change i cannot disable

Post by Zizi64 »

i have a table with a column i must enter S1, S2, S3.
Every time I type S1, it replaces automatically with 01.09.2017.
What is your locale setting in the applied cell style?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post Reply