https://bugs.documentfoundation.org/show_bug.cgi?id=101112
Bug ID: 101112
Summary: Pasted number loses one decimal or a space when adding
text.
Product: LibreOffice
Version: 5.1.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
If there is a number with decimals in a cell and you copy paste that to the
edit box, remove all but one digit after the decimal dot and add text then the
last decimal is removed automatically.
Ok, so the description and the bug is a bit weird so the below steps of how to
reproduce should clear it.
Part one:
1) Enter a number with a decimal dot and more than one digit after it to a
field. Example: 1.555 in A1
2) copy that cell. (ctrl-c)
3) go to another cell Example: B1
4) Click in the input line and paste the value. (ctrl-v)
5) Verify that you have the expected number. Example: 1.555
6) Remove extra digits so that you only have one after the decimal Example 1.5
7) Add in some letters after the automatically included space Example: tons
8) Look in the input box and see that you have the expected thing. Example: 1.5
tons
9) Press enter to accept
10) look in the cell and note that the number after the . is removed but the
rest is there. Example: 1. tons
Expected result would be that the field would still be 1.5 tons.
Note that you should keep the cursor in the input box(not clicking outside or
pressing enter or similar) for steps 4-8. If you click enter and click again
in the edit box after step 4 or 5 before step 6 you will get the correct result
of 1.5 tons in the cell
Part two:
Do the same, except leave 2 numbers after the decimal dot and note that you
have the value with only one number after the decimal dot. In the previous
example in step 6 editing the "1.555" to be "1.55 tons" results in "1.5 tons"
at step 10.
Same can then be repeated with three and so on, you always lose one digit in
such.
Part three:
Do the same except do not remove any decimal digits just adding the text. So in
above skip step 6 fully. Thus in the example at step 8 you have "1.555 tons"
Then the space is removed and you end up with "1.555tons" in step 10
Used:
Version: 5.1.4.2 (x64)
Build ID: f99d75f39f1c57ebdd7ffc5f42867c12031db97a
CPU Threads: 4; OS Version: Windows 6.29; UI Render: default;
Locale: en-GB (en_GB)
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
