To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=100874
User regina changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |WORKSFORME
--------------------------------------------------------------------------------
------- Additional comments from reg...@openoffice.org Mon Apr 6 09:34:18
+0000 2009 -------
The file not an xls-format, but a kind of csv. Excel 2007 gives you the csv
import filter, if you try to open it in Excel 2007.
In OOo you have to use a filter too. Use File > Open. OOo should show you the
CSV import dialog. If the dialog do not open in your version, then do: File >
Open, click on the file and then choose filter 'Text CSV(*.csv,*.txt,*.xls)' in
the drop-down list 'file type'.
Click on the column header in the preview in the CSV import dialog, and then
select the correct format (US English) in the drop-down list 'column type'.
You find a request for enhancement concerning number with dot --> date in issue
87999.
[The tables in the document have got numbers with units. Therefore in this
special case it might be a better way, to import the whole content as text
columns and then convert the dates manually using the functions and
search/replace in Calc.]
[Some application assign the file extension 'xls' although it is not an Excel
format, because then Excel is started when the user double click the file name
and Excel is installed on the PC.]
---------------------------------------------------------------------
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
