| Summary: | FORMATTING Single quote to force text not hidden as expected | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | James Murray <james> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | vsfoote |
| Priority: | medium | ||
| Version: | 4.1.4.2 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | trivial spreadsheet with unexpected quote showing | ||
Reproduced with LibO 4.2.0.1 rc1 on Win7 *** Bug 96158 has been marked as a duplicate of this bug. *** Still the same in 5.0.4.2, 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 5.1.1.3 and in the 5.1.5.1 version I used just now. In 5.2.0.2 that worked properly again, as in 4.0.4.2 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 5.2.0.2 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. Yes, Thanks. That appears to work for me. Eike R. took care of this at 5.2.0 with http://cgit.freedesktop.org/libreoffice/core/commit/?id=48d0affa114d6838c0e99f3f3588dd611a4a2b72 Details in dupe bug 99930 *** This bug has been marked as a duplicate of bug 99930 *** |
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 '1 'test Expected result, spreadsheet shows: 1 test Actual result, spreadsheet shows: 1 'test