To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50670 Issue #:|50670 Summary:|HTML Import and Clipboard Paste behaviour Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|All URL:| OS/Version:|All Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|formatting Assigned to:|spreadsheet Reported by:|ft
------- Additional comments from [EMAIL PROTECTED] Mon Jun 13 07:20:16 -0700 2005 ------- Problem: Importing or pasting HTML formatted content into Calc can result in irritating formattinmg behaviour on Calcs side. Some strings might be interpreted as numbers other as dates, even if the source wasn't either of them. Explanation: This is due to an autodetection mechanism that tries to identify the formatting of the incoming strings by certain characteristics, such as number of separators, kinds of separators and combination of separators. Suggested Solution: To avoid such unwanted automatism the following is suggested: Inserted HTML formatted content via import or clipboard will always be interpreted by Calc current set locale. If the user inserts HTML content with a different locale than the one set in Calc he needs to change the locale (temporary) via "Tools - Options - Language Settings - Document Language" to the source locale to get correct interpretation of the inserted values. The interpretation will follow exactly the same rules as if the user would insert the strings manually. --------------------------------------------------------------------- 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]
