Bug 112349

Summary: Text import fails for entries with leading zeros.
Product: [Retired] Red Hat Linux Reporter: Charles Sullivan <cwsulliv01>
Component: gnumericAssignee: Caolan McNamara <caolanm>
Status: CLOSED RAWHIDE QA Contact: David Lawrence <dkl>
Severity: medium Docs Contact:
Priority: medium    
Version: 9   
Target Milestone: ---   
Target Release: ---   
Hardware: i586   
OS: Linux   
Whiteboard:
Fixed In Version: FC2 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2004-05-13 10:49:14 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
an example to import none

Description Charles Sullivan 2003-12-18 04:30:32 UTC 
Description of problem:  When importing a CSV text file containing column entries with significant leading zeros, like part numbers or ZIP codes, identifying these columns as text (@) in the text import filter fails - the
entries are still treated like numbers and the leading zeros are stripped off.

Version-Release number of selected component (if applicable):  gnumeric-1.0.12-3

How reproducible: Always

Steps to Reproduce:
1. With gnumeric open, click on File>Import.   Select file using File format: "Text import (configurable)".
2. In Separation customization window, click the Comma separator box.
3. In Column formatting window, select data column(s)  with leading-zero entries, then select
Format: "@" for text.  (Leading zeros appear). Click on [Finish].
  
Actual results:
Leading zeros are stripped from the entries in the spreadsheet.  Subsequently selecting
Format>Cells>Text does not restore them.

Expected results:
Leading zeros should not be stripped for columns identified as text.

Additional info:
If _before_ importing the file the pertinant columns in the empty spreadsheet are highlighted
and Format>Cells>Text is selected, then when  steps 1,2,3 are performed as above the
columns appear correctly, retaining the leading zeros.
Comment 1 Caolan McNamara 2004-05-13 10:39:18 UTC 
Created attachment 100208 [details]
an example to import

an example to import
Comment 2 Caolan McNamara 2004-05-13 10:49:14 UTC 
redhat 9 is now end of lifed :-( But gnumeric 1.2.8 as included in
fedora core 2 doesn't exhibit this problem, i.e. in the attached
example I can select "text" for the first column with the import
wizard, the the leading 0's are retained, while using "general" will
continue to give the normally useful treatment of the field as a number