To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=57868 Issue #:|57868 Summary:|Suggestion for locale-casting functions Component:|Spreadsheet Version:|OOo 2.0 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|ENHANCEMENT Priority:|P3 Subcomponent:|code Assigned to:|spreadsheet Reported by:|bobharvey
------- Additional comments from [EMAIL PROTECTED] Mon Nov 14 04:25:04 -0800 2005 ------- There have been many remarks and suggestions about the problem of, for example, opening a UK style CSV file in a german-locale installation, or reading swiss number strings in a US spreadsheet. Much has been made of locale spotting or conversion or selection in the CSV import phase, and this is very important. But I want to suggest another enhancement that would also help with cut-and-paste. Why not impliment spreadsheet functions to cast number strings from one locale to another? The obvious conversion from ',' to '.' may not be enough, and the whole locale structure should be involved. How about =cast(from-locale;to-locale;string) as a function definition? --------------------------------------------------------------------- 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]