Issue 64221 - undesidered characters while Importing .DBF file
Summary: undesidered characters while Importing .DBF file
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 1.1
Hardware: Mac Mac OS X, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-04-10 17:05 UTC by reporter
Modified: 2006-04-11 08:02 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
dbf file (211.30 KB, application/x-compressed)
2006-04-10 19:10 UTC, reporter 		no flags Details
.sxc file (425.85 KB, application/x-compressed)
2006-04-10 19:13 UTC, reporter 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description reporter 2006-04-10 17:05:57 UTC 
This bug occurs when importing a .dbf file; I can see a " ' " character before
every value in every cell.

I saw this using neooffice that is OOo 1.1 based on.
Fabri
Comment 1 frank 2006-04-10 18:34:59 UTC 
Hi,

is the field used defined as Textfield ?

Please attach a DBF file showing this behaviour.

Thanks

Frank
Comment 2 reporter 2006-04-10 19:06:01 UTC 
I added dbf. and .sxc files
Comment 3 reporter 2006-04-10 19:10:27 UTC 
Created attachment 35615 [details]
dbf file
Comment 4 reporter 2006-04-10 19:13:32 UTC 
Created attachment 35616 [details]
.sxc file
Comment 5 frank 2006-04-11 08:02:27 UTC 
Hi,

this is not a bug. The table structure of the dbf file for all the fields
containing leading apostrophes say they are characters. This can easily seen if
you import the DBF file and look at the first row. All columns have a header
defining it. C is for characters (text), N would be nummeric.

So Calc imports the values correctly as Characters. As the numberformat for the
default template is set to nummeric, a apostrophe is placed in front of the
value to make it a text.

To change such text values to real nummeric values, you have two choices. 

1.) Change the field setting in the DBF from C to N and re-import the file or
2.) use the Search and replace functionality. Open the search and replace dialog
and enter '.*' (without the quotes) into the search field. Type '&' (also
without quotes) into the replace field. Now press on the More Button and tag the
option Regular expression. Click on replace all and all the apostrophes should
be gone.

For more information about regular expressions use the help system please.

Frank
Comment 6 frank 2006-04-11 08:02:49 UTC 
closed invalid