https://bugs.documentfoundation.org/show_bug.cgi?id=169846
Bug ID: 169846
Summary: LibreOffice Calc removes leading 0 even when pasting
as unformatted text
Product: LibreOffice
Version: 24.2.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a list of phone numbers copied like this:
02313454
06478844
The leading zeros are obviously required.
I have formated the targetted cells as text
I tried normal pasting, special pasting, paste as text, CTRL ALT SHIFT V, calc
keeps removing leading 0s.
Especially when using the *text* import dialog, the preview shows the leading
0, but when I proceed with "OK", the leading 0s get truncated.
Here are relevant screenshots:
https://ibb.co/4w1f2RFb
https://ibb.co/DPYzDs0f
Steps to Reproduce:
1. copy phone numbers list
2. paste as unformatted text
Actual Results:
leading 0s are removed
Expected Results:
leading 0s not removed
Reproducible: Always
User Profile Reset: No
Additional Info:
Here are relevant screenshots:
https://ibb.co/4w1f2RFb
https://ibb.co/DPYzDs0f
--
You are receiving this mail because:
You are the assignee for the bug.