To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=69156
                 Issue #|69156
                 Summary|=EXACT(LOWER("J");"j") and a few others are FALSE
               Component|Spreadsheet
                 Version|OOo 2.0.3
                Platform|All
                     URL|
              OS/Version|All
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|code
             Assigned to|spreadsheet
             Reported by|modax





------- Additional comments from [EMAIL PROTECTED] Thu Aug 31 14:54:23 -0700 
2006 -------
The function =EXACT(LOWER("J");"j") yields FALSE, because LOWER("J") does not 
return a real "j", but a similar (in apperance) letter. Check out an attached 
testcase and a screenshot ("NETEISINGAI" means FALSE and "TEISINGAI" means 
TRUE in Lithuanian) for detailed analysis.

My testcase is only valid when the locale is set to Lithuanian (in both 
Windows XP and Linux (Debian)), i.e.

On Windows XP with regional settings set to Lithuanian, OOo 2.0.3 - the bug is 
there
On Linux with LANG=lt_LT, OOo 2.0.3 - the bug is there
On Linux with LANG=C, OOo 2.0.3 - the bug is not there

So it seems to be a locale specific bug in LOWER() function. UPPER() does not 
seem to be affected.

P.S. I *don't* have Lithuanian or any other language pack installed. I'm not 
sure where are those "NETEISINGAI" and "TEISINGAI" comming from. But it must 
be a translation from vanilla en_US OOo installation.

---------------------------------------------------------------------
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]

Reply via email to