Bug 106250 - When open a file if "0" is first in a cell Libra delete it
Summary: When open a file if "0" is first in a cell Libra delete it
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
5.2.5.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: dataLoss
Depends on:
Blocks:
 
Reported: 2017-03-01 07:33 UTC by Andrey
Modified: 2017-03-01 11:16 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
price autoparts csv (2.56 MB, application/zip)
2017-03-01 07:37 UTC, Andrey 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Andrey 2017-03-01 07:33:49 UTC 
Description:
If I open file in notepad++ I can find xmr-05800175;05800175;
If I open file in LibraOffice I see xmr-05800175	5800175
It deleted "0" before 5800175.
settings for opening file - http://prntscr.com/eejleb
windows-1251, Russian, ";" ,  text separator - empty
File for testing - https://cloud.mail.ru/public/5pmo/tLKyYB6ZE



Steps to Reproduce:
1. Open file for testing - https://cloud.mail.ru/public/5pmo/tLKyYB6ZE
. settings for opening file - http://prntscr.com/eejleb
windows-1251, Russian, ";" ,  text separator - empty
2. Find xmr-05800175;05800175;
3. After you'll see xmr-05800175 and you will not find 05800175, only 5800175, but if you'll try to open it in notepad++ everything is ok!

Actual Results:  
deleted 0 in lots of cells

Expected Results:
do not delete 0 in a cell, open file as is.


Reproducible: Always

User Profile Reset: No

Additional Info:
repeated problem on whatever PC

File for testing - https://cloud.mail.ru/public/5pmo/tLKyYB6ZE



User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36
Comment 1 Andrey 2017-03-01 07:37:05 UTC 
Created attachment 131546 [details]
price autoparts csv

it's ok
Comment 2 Andrey 2017-03-01 07:52:23 UTC 
How it could be unconfirmed????
http://prntscr.com/eeju96

It's absolutely confirmed
Comment 3 Julien Nabet 2017-03-01 11:06:14 UTC 
The second piece of information 05800175 is considered as a number, so "0" is automatically removed.
If you don't want this removing, you must import your file by indicating to LO that second column is "Text" instead of "Standard" (it's in one of next screens of the dialog you attached as image).
Comment 4 Andrey 2017-03-01 11:13:20 UTC 
Is it possible to turn off automatic detection of columns?
Comment 5 Julien Nabet 2017-03-01 11:16:12 UTC 
I don't think so but don't know really.