@TXTNLRN,asks,@zohosheet,Seems like the Exact function is not working correctly

@TXTNLRN,asks,@zohosheet,Seems like the Exact function is not working correctly

Hello,
Scenario:

In Zohosheet I have a cell with text "sd@s.com,d1@d1.com"
In another cell I have sd@s.com,sd@s.com

In the third cell I am using the Exact function =IF(EXACT(L4;Z4);2;1)
(Please note, I did type a comma between L4 and Z4 and wherever there is a semicolon displayed. Zohosheet changed it to a semicolon)

The result is 2 which is incorrect. Should be 1.

I did the same in MS Excel 2007 the Exact function =IF(EXACT(L4,Z4),2,1)
and result displayed is 1 which is correct.

Please advise at the earliest if I am missing any detail or this a defect.
and do let me know if you have questions.

Thank you,
Staff TXTNLRN
Software testing Dept.
@TXTNLRN
http://www.TXTNLRN.com
text 5128504898