To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50670
------- Additional comments from [EMAIL PROTECTED] Sat Nov 26 14:52:43 -0800 2005 ------- Just to recap: One of the problems are that the example guy Herbert in Germany wants to use both HTML spreadsheets written in German and in English, and dependent on which language the input is in, the data should be interpreted differently. The draft spec by mmc will not handle this situation correctly. If the proposed option is set, the English data will be handled wrongly for Herbert. I propose one more option, and that is to set the thousands and decimal separator according to the 'lang' field of the input HTML document. This can be done via an association of the 'lang' parameter of the input HTML document to a system locale. Claus says that you generally cannot do this association between language and locale, but that is pretty easy in my mind, you can just provide a table for all these relations. I am willing to provide such a table for UNIX, as I am personally one of the main contributors of locales for UNIX. I don't know too much on locales for MS Windows, maybe there is not a database of locales readily available on normal windows systems. Another way forward is to have a table from language to a pair of (thousands separator, decimal separator) - I can also construct that table for maybe 100 languages. I can even provide you with the code for this, given I get the programming language to write this in. My suggestion is thus that there be the option that mmc described, and the option that I described above. Then we can try them out and the users can pick the one that suits them best. That is, two strings: "Import numbers according to locale setting of ooo" "Import numbers according to language setting of imported file" And then I have nothing against a further option in the insert special dialog. --------------------------------------------------------------------- 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]