https://bugs.documentfoundation.org/show_bug.cgi?id=173202
--- Comment #12 from Eyal Rozenberg <[email protected]> --- (In reply to ady from comment #5) > Standard Calc should be as compatible as possible > regarding Functions. This makes me wonder: May we should deal with this and other LO-specific functions or extra functionality as another compatibility setting? We already have those for other aspects of Calc and other modules; see Tools > Options > LibreOffice Calc > Compatibility . We currently have two items there, for hyperlink scope and for key bindings. We could introduce the setting "Use only functions supported by [ ... ]" and have a drop-down menu. Or maybe a specific setting for the legitimacy of `=LAMBDA()`. > You do not understand the relevance regarding inter-compatibility between > spreadsheet tools. In the area of Functions, you have no idea of how many > difficulties an incompatibility brings, even when someone thinks that some > particular syntax, or Function's argument, or format, or whatever, is better > than what other spreadsheet tools support. I'll admit I am not faced with the challenge of collaborating on the same document, with a colleague using MSO. However - you are not distinguishing between actual incompatibility and the use of a different feature. > Minor incompatibilities in Functions have derived in years of discussions on > how to improve the situation in future ODF standards, users posting > questions everywhere, bug reports of all sorts... > > > One example, of many more, would be how to deal with date-time and duration > values, rounding differences, close-to-midnight values... Or when a function > in Calc has different constraints and/or requirements and/or arguments than > in other spreadsheet tools. But these examples are of actual incompatibility, not of functionality that's simply not supported, like defining a lambda and using it elsewhere. > Such discussions have taken years, with multiple experienced people from > different organizations involved, not only from TDF. > > Knowingly introducing incompatibilities in Functions is not a plus. So, how, in your opinion, would new functions be introduced for Calc, ever? -- You are receiving this mail because: You are the assignee for the bug.
