https://issues.apache.org/ooo/show_bug.cgi?id=123230
Bug ID: 123230 Issue Type: DEFECT Summary: The function IF result in #RIF error if a confront string is 'KB' Product: Calc Version: 4.0.0 Hardware: All OS: Windows 8 Status: UNCONFIRMED Severity: normal Priority: P3 Component: editing Assignee: issues@openoffice.apache.org Reporter: gilb...@gmail.com CC: issues@openoffice.apache.org Enter 'KB' in IF function on a cell generate #RIF error instead of correct result. Example normal: the formula =if(G2='GB';1;2) results 1 or 2 if cell G2 is equal or different to 'GB'. Example with wrong result: the formula =if(G2='KB';1;2) results always #RIF. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.