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

Installation & Configuration
1

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.

<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.

2

Hey @juhui,

Thanks for the question and welcome to the forum. :slight_smile:

Which exact version do you have in your:

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

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

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

where it says:

  • AutoInput

you wanted:

  • Input

Adjusted line:

<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

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:

<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?
3

Hello @Tex

Thanks for your response!

Collaboraoffice version I installed is that

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.

<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.

1 Like