Created attachment 91625 [details]
trivial spreadsheet with unexpected quote showing
In Excel and OpenOffice typing in a single quote "'" at the start of a field forces text.
In this version of LibreOffice (at least) the quote itself is shown unexpectedly.
e.g. start a new spreadsheet and type
Expected result, spreadsheet shows:
Actual result, spreadsheet shows:
Reproduced with LibO 18.104.22.168 rc1 on Win7
*** Bug 96158 has been marked as a duplicate of this bug. ***
Still the same in 22.214.171.124, it is inconsistent annoying behaviour.
This one is annoying to me, not because it looks different but because it also behaves differently in lookups.
Below is what I wrote as we concluded checks for a different problem.
Using a single quote at the start of a number ('65635 because I want it treated as text) is treated differently in my LO 126.96.36.199 and in the 188.8.131.52 version I used just now. In 184.108.40.206 that worked properly again, as in 220.127.116.11 and earlier. In 5.1.x.x I have to copy another cell to where I want the new value then backspace out the unwanted number and type in the new one else my lookups do not work on the new (account) number. The difference is very visible in the cell. I did not ask about that earlier as I had changed computers and thought that might be the problem. But 18.104.22.168 worked so I doubt that it is the hardware.
They appear to be stored differently as can be seen in the examples copied below. The same key was used to commence those numbers but in different versions of LO.
'27393 < should be not > ‘29999
Hope that helps.
Any change if you on Tools -> AutoCorrect Options -> Localized Options tab uncheck the Single Quotes replace action?
The glitch is fixed for 5.2 and master builds.
That appears to work for me.
Eike R. took care of this at 5.2.0 with
Details in dupe bug 99930
*** This bug has been marked as a duplicate of bug 99930 ***