# How to turn off the auto-input setting in the 'calc' 

**URL:** <https://forum.collaboraonline.com/t/how-to-turn-off-the-auto-input-setting-in-the-calc/2332>\
**Category:** Installation & Configuration\
**Created:** [January 24, 2024, 11:15pm UTC](https://forum.collaboraonline.com/t/how-to-turn-off-the-auto-input-setting-in-the-calc/2332 "2024-01-24T23:15:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![juhui](https://avatars.discourse-cdn.com/v4/letter/j/76d3ee/32.png) [@juhui](https://forum.collaboraonline.com/u/juhui)\
**Post date:** [January 24, 2024, 11:15pm UTC](https://forum.collaboraonline.com/t/how-to-turn-off-the-auto-input-setting-in-the-calc/2332/1 "2024-01-24T23:15:20Z")

</div>

Hello,

I have installed the latest version of Collabora Office (23.05) in a CentOS 7.

I’d like to turn off AutoInput function at Calc.  
“Autoinput” is a feature that automatically fills in the same value when entering data based on columns.  
[columnA]  
[abc]  
[a…]

when user types ‘a’, The spreadsheet automatically enters abc.

I kwow that it can be disabled in the Tool menu.  
But since I prefer that all users do not use this feature, I would like to disable it through **the coolkitconfig.xcu file** using configuration settings.  
The configuration value I attempted is as follows.

```xml
<item oor:path="/org.openoffice.Office.Calc/AutoInput">
    <prop oor:name="AutoInput" oor:type="xs:boolean" oor:op="remove" oor:nillable="false">
            <value>false</value>
    </prop>
</item>

```

If the value is incorrect or if it’s not possible to turn off the ‘autoInput’ value through a configuration file change in Collabora Office, Please let me know.

---

<div class="post-metadata">

**Author:** ![Tex](https://avatars.discourse-cdn.com/v4/letter/t/eb8c5e/32.png) [@Tex](https://forum.collaboraonline.com/u/Tex)\
**Post date:** [January 25, 2024, 1:49am UTC](https://forum.collaboraonline.com/t/how-to-turn-off-the-auto-input-setting-in-the-calc/2332/2 "2024-01-25T01:49:35Z")

</div>

Hey @juhui,

Thanks for the question and welcome to the forum. 🙂

> [@juhui](#):
>
> I have installed the latest version of Collabora Office (23.05) in a CentOS 7.

Which exact version do you have in your:

- **Help \> About**
  - (There’s a little “Copy” button in there.)

> [@juhui](#):
>
> I’d like to turn off AutoInput function at Calc.  
> “Autoinput” is a feature that automatically fills in the same value when entering data based on columns.
> 
> […]
> 
> But since I prefer that all users do not use this feature, I would like to disable it through **the coolkitconfig.xcu file** using configuration settings.

I think you might have a little typo in your very first line:

```auto
<item oor:path="/org.openoffice.Office.Calc/AutoInput">

```

where it says:

- `AutoInput`

you wanted:

- `Input`

Adjusted line:

```auto
<item oor:path="/org.openoffice.Office.Calc/Input">

```

At least that’s where the setting is in LibreOffice 7.6.4:

**Preference Name** :

- `org.openoffice.Office.Calc`
  - `Input`

with the:

| Property | Type | Value |
| --- | --- | --- |
| AutoInput | boolean | true |

> [@juhui](#):
>
> If the value is incorrect or if it’s not possible to turn off the ‘autoInput’ value through a configuration file change in Collabora Office, Please let me know.

Hmmm… well, I was able to get a few other AutoCorrect settings to adjust themselves—like `TwoCapitalsAtStart` by adding this in the `coolkitconfig.xcu` file:

```auto
<item oor:path="/org.openoffice.Office.Common/AutoCorrect">
	<prop oor:name="TwoCapitalsAtStart" oor:op="fuse">
		<value>True</value>
	</prop>
</item>

```

Hmmmm… but I wasn’t able to get your specific “AutoInput” setting to stick. I was trying all sorts of mixes to work too, like trying different types of `oor:op`.

Hmmm…

* * *

**Side Note:** And, another question:

- Any specific reason WHY you want to disable the function for all users? Is it causing trouble in certain documents?

---

<div class="post-metadata">

**Author:** ![juhui](https://avatars.discourse-cdn.com/v4/letter/j/76d3ee/32.png) [@juhui](https://forum.collaboraonline.com/u/juhui)\
**Post date:** [January 26, 2024, 6:19am UTC](https://forum.collaboraonline.com/t/how-to-turn-off-the-auto-input-setting-in-the-calc/2332/3 "2024-01-26T06:19:25Z")

</div>

Hello @Tex

Thanks for your response!

Collaboraoffice version I installed is that

```plaintext
COOLWSD version: 23.05.6.5 (git hash: 84551c8 (E))
LOKit version: Collabora Office 23.05.6.4 (git hash: 058f614)
Served by: CentOS Linux 7 (Core)
Server ID: ea4e0c5d

```

I have configured it as follows, but it still doesn’t work.

```xml
<item oor:path="/org.openoffice.Office.Calc/Input">
   <prop oor:name="AutoInput" oor:op="replace">
      <value>false</value>
   </prop>
</item>

```

The reason I am trying to turn off this setting is that most users primarily use Korean.  
As Korean characters are composed of the first consonant letter, vowels, and final consonants, the AutoInput feature often leads to numerous typos when entering characters with final consonants.