[Libreoffice-bugs] [Bug 139173] Incorrect bounds on formula DEC2HEX
https://bugs.documentfoundation.org/show_bug.cgi?id=139173 Eike Rathke changed: What|Removed |Added Status|NEW |ASSIGNED Assignee|libreoffice-b...@lists.free |er...@redhat.com |desktop.org | --- Comment #9 from Eike Rathke --- All three functions are Excel functions. It is futile to discuss whether Calc could do better than Excel, the definition of DEC2HEX is there https://docs.oasis-open.org/office/OpenDocument/v1.3/cs02/part4-formula/OpenDocument-v1.3-cs02-part4-formula.html#DEC2HEX and the current implementation has one-off errors in its interval. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 139173] Incorrect bounds on formula DEC2HEX
https://bugs.documentfoundation.org/show_bug.cgi?id=139173 himajin100...@gmail.com changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=68 ||930 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 139173] Incorrect bounds on formula DEC2HEX
https://bugs.documentfoundation.org/show_bug.cgi?id=139173 --- Comment #8 from himajin100...@gmail.com --- https://opengrok.libreoffice.org/xref/core/scaddins/source/analysis/analysis.cxx?r=107399d6#662 more note: SCA_MAX2 and SCA_MAX8 are odd numbers, but SCA_MAX16 is an even number. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 139173] Incorrect bounds on formula DEC2HEX
https://bugs.documentfoundation.org/show_bug.cgi?id=139173 --- Comment #7 from himajin100...@gmail.com --- oops,typo souce => source -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 139173] Incorrect bounds on formula DEC2HEX
https://bugs.documentfoundation.org/show_bug.cgi?id=139173 --- Comment #6 from himajin100...@gmail.com --- personally I prefer Julien's opinion. but putting aside that, I can provide a souce code pointer. https://opengrok.libreoffice.org/xref/core/scaddins/source/analysis/analysishelper.cxx?r=93c64a61=ConvertFromDec#704 This is not fNum <= fMin || fNum >= fMax -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 139173] Incorrect bounds on formula DEC2HEX
https://bugs.documentfoundation.org/show_bug.cgi?id=139173 Julien Nabet changed: What|Removed |Added CC|serval2...@yahoo.fr | --- Comment #5 from Julien Nabet --- (In reply to cameron.pinnegar from comment #4) >... > 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. So you prefer LO sticks to Excel limitations instead of LO being able to do better just for compatibility sake? It seems most people prefer Excel compatibility as a top priority for Calc, I find it crazy. Anyway, don't worry, I must be the only one (at least never saw another one) to think like this, so I suppose this "bug" will be "fixed" :-) => uncc myself -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 139173] Incorrect bounds on formula DEC2HEX
https://bugs.documentfoundation.org/show_bug.cgi?id=139173 --- Comment #4 from cameron.pinne...@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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 139173] Incorrect bounds on formula DEC2HEX
https://bugs.documentfoundation.org/show_bug.cgi?id=139173 --- Comment #3 from Julien Nabet --- (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? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 139173] Incorrect bounds on formula DEC2HEX
https://bugs.documentfoundation.org/show_bug.cgi?id=139173 Ming Hua changed: What|Removed |Added Blocks||108827 Status|UNCONFIRMED |NEW Ever confirmed|0 |1 CC||er...@redhat.com, ||ming.v@qq.com --- Comment #2 from Ming Hua --- I can reproduce the reported inconsistency with 7.1.0 Beta1, i.e.: DEC2BIN(2^9) and DEC2BIN(-(2^9)-1) gives Err:502 DEC2HEX(2^39) gives "80" and DEC2HEX(-(2^39)-1) gives "7F", not errors Version: 7.1.0.0.beta1 (x64) Build ID: 828a45a14a0b954e0e539f5a9a10ca31c81d8f53 CPU threads: 2; OS: Windows 10.0 Build 18363; UI render: default; VCL: win Locale: zh-CN (zh_CN); UI: zh-CN Calc: threaded Also both DEC2HEX(2^39) and DEC2HEX(-(2^39)) gives "80", so this is definitely a bug. (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 believe this is Eike's area of expertise, adding him to CC. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108827 [Bug 108827] [META] Calc functions bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 139173] Incorrect bounds on formula DEC2HEX
https://bugs.documentfoundation.org/show_bug.cgi?id=139173 Julien Nabet changed: What|Removed |Added CC||serval2...@yahoo.fr --- Comment #1 from Julien Nabet --- Why LO should be in accordance with Excel or more precisally, with the same limitations? Unless you consider functions DEC2BIN, DEC2OCT, DEC2HEX are MS functions? (but I don't see doc about this). -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
