https://bugs.freedesktop.org/show_bug.cgi?id=47932
Bug #: 47932
Summary: : Formula if
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.5 RC1
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 59102
--> https://bugs.freedesktop.org/attachment.cgi?id=59102
example sheet
Problem description:
Steps to reproduce:
1. N12 and O12 - number value
2. =if ((N12-O12)>0;N12-O12;CHAR(32))
3. polish version =JEŻELI((N12-O12)>0;N12-O12;ZNAK(32))
4. this bu is happen in versions above 3.3.3
Current behavior:
when (N12-O12)<0, calc return me #ARG!
Expected behavior:
empty cell (with white space)
Platform (if different from the browser):
Windows Vista, XP, 7.
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:11.0) Gecko/20100101
Firefox/11.0
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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