https://bugs.documentfoundation.org/show_bug.cgi?id=173202
--- Comment #13 from Eyal Rozenberg <[email protected]> --- (In reply to ady from comment #5) > 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 and me using Calc. > 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()`. > 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 proper incompatibility, not of functionality that's simply not supported, like defining a lambda as a cell's value and using it elsewhere. > Such discussions have taken years, with multiple experienced people from > different organizations involved, not only from TDF. But would that really happen in our case? That's not the same as function FOO() being usable with some parameters in Calc and others in Excel. Also, what happens when there is a desire or possibility for changing or expanding the functionality of some spreadsheet cell function? You've argued against allowing incompatibilities; is there a -- You are receiving this mail because: You are the assignee for the bug.
