Issue 29054 - import textfield as number -> 'at the beginning
Summary: import textfield as number -> 'at the beginning
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
: 62596 (view as issue list)
Depends on:
Blocks:
 
Reported: 2004-05-11 14:43 UTC by contixy
Modified: 2006-03-13 09:46 UTC (History)
1 user (show)

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

Attachments
sample for the problem, imported from access (6.74 KB, application/vnd.sun.xml.calc)
2004-05-11 14:47 UTC, contixy 		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 contixy 2004-05-11 14:43:59 UTC 
Hello,

I do not know if it is ab bug, but when I copy tabels from MS Access or 
Navision  into a spreadsheet and a field is defined as text but is filled with 
numbers the field beginns with  ' . A field with the value 1000 becomes '1000. 
It can not be formated as a number, the only way to calculate with these 
fields is to erase the ' manualy.
Comment 1 contixy 2004-05-11 14:47:14 UTC 
Created attachment 15175 [details]
sample for the problem, imported from access
Comment 2 frank 2004-06-02 15:42:51 UTC 
Hi,

this behaviour is correct. The table definition from the Access database is
text. Numbers in these fields will be exported as text. This is indicated by the
apostrophe in front of them.

You have wo choices to remove them :

1. Change the field definition in Access to number
2. Use search and replace on the selected column with '.*' (without the quotes)
as search string and '&' (without the quotes) as the replace string and regular
expression enabled.

Frank
Comment 3 frank 2004-06-02 15:43:12 UTC 
closed invalid
Comment 4 frank 2006-03-13 09:46:43 UTC 
*** Issue 62596 has been marked as a duplicate of this issue. ***