To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=47387
User fst changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue Apr 19 07:11:29 -0700
2005 -------
Sorry,
but this isn't a bug.
Have you tried to set the column with your problematic data to US English in the
Text Import dialog ? This may solve the problem with the date conversion.
The quote in front of the numbers after formatting the imported cells to number
is to hold the data as Text as you've specified on import. To get rid of them
use the find & Replace facilities of OOo. Search for '.*' (without quotes) and
replace with '&' (also without quotation marks). Tag the checkbox Regular
Expression and press replace all.
Have a look at the Help system for in depth sights on Regular Expressions in
Calc.
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]
