View original (French)

Automatic space after exclamation mark

Solved
nicoweb61 Posted messages 280 Status Member -  
nicoweb61 Posted messages 280 Status Member -

Hello,

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

  1.
    Pierr10 Posted messages 13833 Registration date   Status Moderator Last intervention   5 843
     

    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)

    2
    1. nicoweb61 Posted messages 280 Status Member 19
       

      Hello,

      I indeed think that the setting needs to be done in the autocorrection, but I couldn't find the element for the automatic spacing of punctuation marks.

      We are using LibreOffice 7.5.2.2.

      0
  2. trotte-menu Posted messages 904 Registration date   Status Member Last intervention   349
     

    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

    2
    1. Pierr10 Posted messages 13833 Registration date   Status Moderator Last intervention   5 843
       

      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.

      0
      1. trotte-menu Posted messages 904 Registration date   Status Member Last intervention   349 > Pierr10 Posted messages 13833 Registration date   Status Moderator Last intervention  
         

        Hello,

        When the behavior does not match, I would recommend purging the user profile.

        0
      2. Pierr10 Posted messages 13833 Registration date   Status Moderator Last intervention   5 843 > trotte-menu Posted messages 904 Registration date   Status Member Last intervention  
         

        It's a good idea, since there doesn't seem to be a solution in the LibreOffice options.

        0
    2. nicoweb61 Posted messages 280 Status Member 19
       

      Your response with the video really solved the problem for me.

      Thank you for your help!

      0
  3. georges97 Posted messages 14602 Registration date   Status Contributor Last intervention   2 932
     

    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.

    1
    1. brucine Posted messages 24924 Registration date   Status Member Last intervention   4 178
       

      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.

      0
      1. Pierr10 Posted messages 13833 Registration date   Status Moderator Last intervention   5 843 > brucine Posted messages 24924 Registration date   Status Member Last intervention  
         

        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.

        1
  4. trotte-menu Posted messages 904 Registration date   Status Member Last intervention   349
     

    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

    0
  6. trotte-menu Posted messages 904 Registration date   Status Member Last intervention   349
     

    We will not know what motivated the Resolved marking.

    MBP + macOS Ventura
    OpenOffice, LibreOffice

    0
    1. Pierr10 Posted messages 13833 Registration date   Status Moderator Last intervention   5 843
       

      Hello

      Marked resolved by the requester at 9:22 AM.

      0