Description: Trim(string_with_spaces) = string_with_spaces so the function does nothing Steps to Reproduce: 1.Enter trim function in a cell: =trim("a b c") 2. 3. Actual Results: "a b c" Expected Results: "abc" Reproducible: Always User Profile Reset: No Additional Info: Version: 5.3.1.2 Build ID: 1:5.3.1-0ubuntu2 User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36 OPR/49.0.2725.39
Trim function removes the spaces and tabs from the beginning and end of the string, but not from the middle. If you want to remove the spaces in between, you need to use =SUBSTITUTE("a b c"; " "; "" ) Closing as RESOLVED NOTABUG
Trim (https://help.libreoffice.org/Calc/Text_Functions#TRIM) trims leading and trailing spaces, and folds multiple adjacent spaces into single spaces, like this: =TRIM(" a b c ") -> "a b c" It works like that in 5.3.1.2, as well as in 5.4.3.2 => NOTABUG