https://bugs.freedesktop.org/show_bug.cgi?id=76294
Priority: medium
Bug ID: 76294
Assignee: [email protected]
Summary: Other: IF EXACT function - TRUE clause not selected
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.1.1 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
Steps to reproduce:
1. Enter =IF(EXACT(D20,"No");B6;0)in a cell
2. LibreOffice changes the semi-colons to commas. Help says to use
semi-colons!
3. Put 'No' in cell D20
4. Put a non-zero number in cell B6
5. Cell with formula equals number in cell B6.
6. Close file
7. Open file
8. Cell with formula equals zero.
9. Change one of the commas in the formula to a semi-colon.
10. Cell with formula equals number in cell B6.
Current behavior:
IF function doesn't return value in TRUE clause.
Expected behavior:
IF function should return value in TRUE clause.
Operating System: Windows 7
Version: 4.2.1.1 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
