To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77872 Issue #|77872 Summary|Cell format at dos/text insert/Sheet from file Component|Spreadsheet Version|1.0.0 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|bengtseb
------- Additional comments from [EMAIL PROTECTED] Mon May 28 14:26:05 +0000 2007 ------- Vår/Our ref: E74662 28 May 2007 I have the following -pc with Centrino Duo -Win XP with latest sp -Open Office 2.2.1 set to Calc The file is -a file crated from a dos-program/txt-format and cleaned in Notes ie some blank lines removed I do the following -Insert sheet from file -character set western Europe Dos Nordic -fixed width -manually set the tabs to suit -OK and import Result When I try to import a txt-file into Open Office Calc some columns set themselves to date-format and it seem impossible to get back to the original numbers. The numbers are like 30.1 becomes 30-01-01. It seem to be the single decimal numbers that turn into date, not the double decimal numbers like 30.54. It is not possible to change the Format of the cells. The number does not come back to the original. Summary Numbers like 30.1 turns to date format 30-01-01. Without the tabs the figures open correctly. I cannot use this as I do not get the columns required. The seem clearly to be a bug in the program. Regards Bengt --------------------------------------------------------------------- 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]