https://bugs.freedesktop.org/show_bug.cgi?id=63274
--- Comment #4 from [email protected] --- For someone with commit acccess, it is simple to clarify the help text to avoid confusion. The original example given in the help is misleading as it does not work for arbitrary valid hex digits. The example (64) is fine, but other examples (eg A1) are clearly a cell reference, and cannot be used as per the example. Non-ambigous results, like 1A don't work at all, and using single-quotes gives the wrong answer entirely. In my testing, direct strings with double-quotes return the right answer every time, as do cell references. I assume with cell references there is some type conversion happening that is not happening in the forumula bar. The cell reference case is possibly a separate case, as can be seen by typing 6a into cell A1, then elsewhere typing =IF(A1 == "6a", "String equals","Not string equals"). It is possible == is performing type conversion. Removing the ambiguity in the example would be very helpful. =HEX2DEC("6a") (106): =HEX2DEC(6a) (262) =HEX2DEC(0A) (#NAME) =HEX2DEC(1A) (#NAME) This bug is a little old unfortunately, and easy to trip over. -- 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
