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.

Reply via email to