To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=64221
User fst changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue Apr 11 00:02:27 -0700
2006 -------
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
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
