https://bugs.documentfoundation.org/show_bug.cgi?id=93951
Bug ID: 93951
Summary: Changing a formula calculation to include § causes
truncation
Product: LibreOffice
Version: 5.0.1.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: vesa.r...@gmail.com
If you accidentally add § into a formula will cause the rest of the formula to
be erased. This is specially annoying in keyboard layouts where § is next to 1
so it is easy to hit by accident.
How to reproduce/example:
In all you should enter a calculation formula in a cell and see that it
produces the expected value and that when you click on it the edit bar shows
the right formula. I will use =2*2*2 as example in the following.
First example:
Change the middle 2 to a § producing =2*§*2 and press enter. You get the
expected Err:501 as cell value, but going back to edit you see =2* in the edit
box, so everything starting from § was truncated.
Expected behavior: Have =2*§*2 in the edit box so could change the § into the
meant 1
Second example:
Undo or type in =2*2*2 again to reset for next:
Change the first 2 to a § producing =§*2*2 and press enter. You get the
expected Err:501 as cell value, but going back to edit you see Err:501 in the
edit box, so everything including the = was truncated.
Expected behavior: Have =§*2*2 in the edit box so could change the § into the
meant 1
Third example:
Type in directly a new formula =§*2*2 and press enter. You get the expected
Err:501 as cell value, but going back to edit you see Err:501 in the edit box,
so everything including the = was truncated.
Expected behavior: Have =§*2*2 in the edit box so could change the § into the
meant 1
Libreoffice version:
Version: 5.0.1.2 (x64)
Build ID: 81898c9f5c0d43f3473ba111d7b351050be20261
Locale: en-GB (en_GB)
System:
Windows 8.1 Pro 64 bit.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
