[Libreoffice-bugs] [Bug 139173] Incorrect bounds on formula DEC2HEX

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139173

--- Comment #4 from cameron.pinnegar at gmail.com ---
(In reply to Julien Nabet from comment #3)
> (In reply to Ming Hua from comment #2)
> > ...
> > (In reply to Julien Nabet from comment #1)
> > > Unless you consider functions DEC2BIN, DEC2OCT, DEC2HEX are MS
> > > functions? (but I don't see doc about this).
> > MS has support page for DEC2HEX:
> > https://support.microsoft.com/en-us/office/dec2hex-function-6344ee8b-b6b5-
> > 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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201223/376eb067/attachment.htm>