<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Incorrect bounds on formula DEC2HEX" href="https://bugs.documentfoundation.org/show_bug.cgi?id=139173#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Incorrect bounds on formula DEC2HEX" href="https://bugs.documentfoundation.org/show_bug.cgi?id=139173">bug 139173</a> from <a class="email" href="mailto:cameron.pinnegar@gmail.com" title="cameron.pinnegar@gmail.com">cameron.pinnegar@gmail.com</a> <pre>(In reply to Julien Nabet from <a href="show_bug.cgi?id=139173#c3">comment #3</a>) > (In reply to Ming Hua from <a href="show_bug.cgi?id=139173#c2">comment #2</a>) > > ... > > (In reply to Julien Nabet from <a href="show_bug.cgi?id=139173#c1">comment #1</a>) > > > Unless you consider functions DEC2BIN, DEC2OCT, DEC2HEX are MS > > > functions? (but I don't see doc about this). > > MS has support page for DEC2HEX: > > <a href="https://support.microsoft.com/en-us/office/dec2hex-function-6344ee8b-b6b5">https://support.microsoft.com/en-us/office/dec2hex-function-6344ee8b-b6b5</a>- > > 4c6a-a672-f64666704619 > > ... > I don't understand, is "DEC2HEX" a kind of "proprietary" function of MS? > Why couldn't LO use these function names and expand what Excel can do? Is LO > bound to mimic Excel even in its limitations? Well, LO Calc is mimicking Excel's limitations already. The bounds of the formulae seem to be so that the outputs are constrained to be 10 characters long, but that's just an arbitrary thing Microsoft chose. LibreOffice doesn't have to abide by that -- it could choose to allow much bigger inputs, yet it doesn't, for what I assume are compatibility reasons. So if compatibility and consistency are goals, the bounds should match Excel's.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>