socialcalc icon indicating copy to clipboard operation
socialcalc copied to clipboard

Published 20 hours ago • verified publisher icon infojunkie

Empty string not handled like other strings

Open infojunkie opened this issue 11 years ago • 1 comments

This formula will show No where in Excel it will show Yes: A1 = ="" A2 = =IF(A1 > 100, "Yes", "No")

infojunkie avatar Aug 11 '12 20:08 infojunkie

The root cause seems to be in a difference between Excel's implicit type conversions (used in the comparison above between a string and a number) and SocialCalc's.

Not sure how Excel implicit conversion works, and the OpenDocument specification does not address the issue of comparing mixed types in the Infix Operator Ordered Comparison ("<", "<=", ">", ">=") section.

Unsure how to proceed at this point.

infojunkie avatar Aug 11 '12 22:08 infojunkie