Created attachment 91522 [details]
Spreadsheet that demonstrates the added space problem
Text fields e.g. "Bank" get corrupted when spreadsheet is saved and then re-opened. On re-opening the field contains "Bank " and lookups that depend on that field contents fail.
Steps to reproduce:
1. Open my accounts spreadsheet (ods format)
2. Fix those fields by removing spaces.
3. Save and close spreadsheet
4. Open spreadsheet
5. Examine fields - spaces now added
A space gets added erroneously.
Same problem in 184.108.40.206 also.
Field contents should be preserved.
There also looks to be a second bug.
Sometimes "Bank" == "Bank " and sometimes "Bank" != "Bank "
In the test spreadsheet this comparison is true. In my actual accounts spreadsheet (a superset of the test one) it is returning false.
I'm not going to post the full spreadsheet, but will email to a developer if required.
Operating System: Ubuntu
Version: 220.127.116.11 release
Cells are formatted with the following Excel built-in number format:
[>0]# ##0,00" ";[<0]-# ##0,00" ";" -"#" ";@
Note the extra space after the @
If I open the Style dialog and modify the style removing the trailing space, all works fine.
I do not thing there is a bug here unless this space is added by LibreOffice.
If you have Excel, can you test this:
Create a file with a style using this format (without space) in Excel
Open this file with LibreOffice and check if space is added.
If not this report can be closed.
After a search, it is the same bug as 70275.
*** This bug has been marked as a duplicate of bug 70275 ***