To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53909 Issue #:|53909 Summary:|DATA detection tool as "Text in columns" of ms excel Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|formatting Assigned to:|spreadsheet Reported by:|xarz
------- Additional comments from [EMAIL PROTECTED] Mon Aug 29 06:24:59 -0700 2005 ------- I've discovered recently that calc of oo2 can't detect and convert the text of a column like ms office does with the funcion of the same name. This causes problems with exported data from other programs (closed software ones) that can export to .xls format which can be opened from Calc, but we can not operate with the data of the xls because oo2 detects the cell content like text not as number. The options in language settings only afects the data entered from keyboard not existing exported data on the grid. I've attached a sample ods document showing this. And if you want to understand what I'm talking about, try to operate the data showed in column labeled "Import" and do a summatory at the end of the column. In excel you can do it selecting the column and going to "data" menu and clicking in "Text in columns" and then select the desired format for the content on the cells. This cannot be done in oo2 AFAIK. Let me know if I'm doing something wrong or I've missed something. --------------------------------------------------------------------- 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]
