Bug 112349 - Text import fails for entries with leading zeros.
Summary: Text import fails for entries with leading zeros.
Keywords:
Status: CLOSED RAWHIDE
Alias: None
Product: Red Hat Linux
Classification: Retired
Component: gnumeric
Version: 9
Hardware: i586
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Caolan McNamara
QA Contact: David Lawrence
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2003-12-18 04:30 UTC by Charles Sullivan
Modified: 2007-04-18 17:00 UTC (History)
0 users

Fixed In Version: FC2
Clone Of:
Environment:
Last Closed: 2004-05-13 10:49:14 UTC
Embargoed:


Attachments (Terms of Use)
an example to import (46 bytes, text/plain)
2004-05-13 10:39 UTC, Caolan McNamara
no flags Details

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


Note You need to log in before you can comment on or make changes to this bug.