To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26565
------- Additional comments from [EMAIL PROTECTED] Thu Jan 27 13:23:49 -0800 2005 ------- Hi Kohei, I have been taking a look at your work on "natural" sorting in the spreadsheet. I have a couple of observations that may be of interest: 1. The "natural" sort you are implementing always reads numbers as floating point. It may be preferable to be able to read numbers as integers as well (regarding decimal points etc. as common text). Imagine for instance that you want to read a sequence of OpenOffice source-file version numbers, e.g. 1.8 1.9, 1.10 1.11, which would still be sorted "unnaturally", as 1.10, 1.11, 1.8, 1.9. Also, when trying to sort other types of version numbers, e.g. 1.1.3, 1.1.4 etc. the comparison algorithm would probably throw an exception when trying to read the strings as floating point numbers. 2. If I have read your changes correctly, the new comparison function will always use the standard locale decimal points and thousand separators when parsing floting point numbers. Maybe it should be possible for the user to change this, for instance when importing files from other countries (the number formats change, but the strings do not). Regards, SÃren --------------------------------------------------------------------- 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]