https://issues.apache.org/ooo/show_bug.cgi?id=121760
Rob Weir <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |INVALID --- Comment #2 from Rob Weir <[email protected]> --- C25 is empty and in D27 this is compared to a null string, and this evaluates as TRUE. So D27 has the value of the null string. The formula in K27 then essentially asks whether D27>9.6, or essentially "">9.6. This is mixing data types and the results might not be what you expect. Better is to convert to compatible types directly, e.g., Do something like: VALUE(D27)>0.095 In any case, I don't see a bug here. Better to take formula questions to the community support forum at http://forum.openoffice.org -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug.
