Created attachment 165628 [details]
File containing errenonuous bug
When performing this function a few hundres times, sometimes results will be padded with a bunch (up to over 300) zeros.
This bug also existed in 184.108.40.206.
Created attachment 165629 [details]
Screenshot of invalid occurrence
In case the bug won't show on the tester's computer, here a screenshot of the bug.
hm. it's possibly a rendering problem. If you try increase a row height, then you'll see right result
anyway I confirm it in
Version: 220.127.116.11.alpha0+ (x64)
Build ID: 8c18cd6823ddf4ef5ba67801a84cee26c9b5a9a6
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Vulkan; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
I'm not sure if it may be a function problem...
Created attachment 165682 [details]
test format scientific
it looks like the Text() formula interprets the dec2hex results as scientific numbers.
Created attachment 165683 [details]
Created attachment 165684 [details]
detailed calculation settings
changing "detailed calculation settings" will influence the result.
bzw: i tend to say it is not a bug, cause ms excel 2016 does it same ...
something like =REPT("0";7-LEN(C3))&C3 should work as a repleacement for Text()
DEC2HEX returns a text not a value. You should remove your TEXT function.
TEXT try to interpret string as a value. So each time the string returned by DEC2HEX is of the following type : [0-9]E[0-9] a scientific value is detected.