https://bz.apache.org/ooo/show_bug.cgi?id=126754
--- Comment #7 from [email protected] --- (In reply to warenhuis1 from comment #6) > That makes sense, mroe. Thank you. I will have to look for workarounds then > :/. But is this a bug or not? I think it is. In addition, the user 'Lupp' has made the following conclusions after viewing my testfile. I will also post it here for others to see: by Lupp ยป Tue Dec 29, 2015 1:44 am 0. @warenhuis : As long as your HEX numbers are text by type, no suppression of leading zeros will occur. General (and possibly important): 1. There is clearly a bug, not just a problem to be solved (worked around) by users. 2. Using AOO4.1.2 I do not get the result "1" for "=LEFT(TEXT("7E";"00");1)" as "warenhuis" stated, but "0" (both these digits being text). I cannot understand the "1" in any way. 3. The error is caused by the application of an incorrect automatic conversion of a text like "7E" into a number, and independent of the subsequent application of TEXT (or LEFT after that). 4. The most reduced appearence of the bug is CODE: SELECT ALL EXPAND VIEW =0+"7E" returning the number 7. Starting from that the other buggy behaviour mentioned is fully consequent. 5. The background "mroe" is guessing in the discussion of the mentioned bug may or may not be correct. It should not be relevant, however. In accordance with the general rules for implicit conversion the TEXT function (or the evaluator preprocessing the parameters?) shall be implemented in a way also accepting a numeric text on the numeric parameter position. It has to do it by a correct automatic conversion of that text into a number, of course. 6. The complete syntax for constant numbers as specified in the only mandatory document http://docs.oasis-open.org/office/v1.2/ ... -part2.odt is: CODE: SELECT ALL EXPAND VIEW 5.3 Constant Numbers Constant numbers are written using '.' (FULL STOP, U+002E) dot as the decimal separator. Optional "E" or "e" denotes scientific notation. Syntactically, negative numbers are positive numbers with a prefix "-" (HYPHEN-MINUS, U+002D) operator. A constant numberis of type Number. Number ::= StandardNumber | '.' [0-9]+ ([eE] [-+]? [0-9]+)? StandardNumber ::= [0-9]+ ('.' [0-9]+)? ([eE] [-+]? [0-9]+)? Evaluators should be able to read the Number format, which accepts a decimal fraction that starts with decimal point '.' (FULL STOP, U+002E), without a leading zero. Evaluators shall write numbers only using the StandardNumber format, which requires a leading digit, and shall not write numbers with a leading '.' (FULL STOP, U+002E). This does obviously not allow for an empty exponent (resulting in taking "7E" for "7E0"). This is how numbers are to be represented in the file (persistent). Since there is nothing said in addition about numbers regarding the UI, the above specification should also be applicable on that level. This with the exception of details overlayed by the locale. No such exception relevant for the case under discussion here! 7. I am not known to the AOO bugzilla site. Might someone else care for the conclusions from this post to be also posted in the mentioned bug report, please? 8. LibO V5.0.4 does not suffer from the bug. Original link: https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=81032 -- You are receiving this mail because: You are the assignee for the issue.
