Automatic space after exclamation mark
SolvedHello,
In Calc, when I try to set a password that contains an exclamation mark, the software automatically adds a space just before it.
How can I prevent this?
Thank you in advance.
5 answers
-
Moderator
Hello,
I couldn't reproduce the issue with Calc from LibreOffice. I should clarify that aside from typing passwords, there is indeed a space that automatically inserts before the exclamation mark. (This is defined in AutoCorrections).
Make sure you have the latest version of your software and preferably use LibreOffice over OpenOffice.
The simplest solution remains not to use punctuation marks in passwords. You still have plenty of options.
What is understood well is expressed clearly,
And the words to say it come easily.
(Boileau) -
Hello,
Hello,
Tools Menu > AutoCorrect Options > Language Options > Add a non-breaking space before punctuation marks...
Checked: Even in Calc, creating said space that disappears as soon as another character is entered.
Unchecked: No creation of non-breaking space.
MBP + macOS Ventura
OpenOffice, LibreOffice-
Moderator
Hello!
Very well!
But the problem is that, even with the option checked, no non-breaking space is inserted when creating a password (at least for me).
That's what I explained earlier: normally, when creating a password, the autocorrect rules of the text editor do not apply. So there is no non-breaking space when you insert a punctuation mark in a password.
The issue for nicoweb61 is that this simple rule does not apply for him and spaces are created when he types a password.
-
-
Moderator@trotte-menu
It's a good idea, since there doesn't seem to be a solution in the LibreOffice options.
-
-
-
Contributor
Hello,
It’s probably because these special characters (punctuation or other signs) are not accepted in file names like in passwords. Try using a number or a digit instead.
Also, wait for other responses because this is just a guess.
-
Hello,
If it's about the passwords for Libre Office files, I would be more inclined to suggest the grammar checker; I use Microsoft Office (where you need to uncheck spacing before/after punctuation), I don't know where to set that up in Libre Office.
Still under Word, if I manually remove that space, Word flags it as a "spelling mistake" and that’s where it ends: also check the automatic corrections. -
Moderator@brucine
Hello!
What's wrong is that there is autocorrect applied to the writing of the password. Normally, passwords are not treated like text and thus escape any spell or grammar checking.
That's what I observe on my end. I can do anything with passwords. There is no autocorrect.In the tests I've done, I've simply noticed that there is poor management of spaces. Normally, you don't put spaces in a password.
-
-
For reference, simplified procedure proposed by yclik:
- Close LibreOffice
- Press the Windows key (the little flag) while holding down the R key
- Enter %appdata%
- Find the LibreOffice folder and rename it to OldLibreOffice
- Restart LibreOffice
MBP + macOS Ventura
OpenOffice, LibreOffice -
We will not know what motivated the Resolved marking.
MBP + macOS Ventura
OpenOffice, LibreOffice
