https://bugs.documentfoundation.org/show_bug.cgi?id=155239
--- Comment #5 from ady <[email protected]> --- (In reply to TBeholder from comment #4) > > =SUM(--(F1:F4)). > It's not an array formula That's the point. For versions of Excel that support dynamic arrays, that _is_ an array; not in the traditional "legacy" CSE way. As already said, =SUMPRODUCT(--(F1:F4)) already supports this, because the function does not need to be introduced with CSE. In older versions of Excel (which do not support "dynamic" functions) the same =SUM(--(F1:F4)) formula would fail too, in the same way as in LO. LO should be more precise regarding which features (e.g. "dynamic arrays") to support, in which context, in which versions. Otherwise, users would report things like "LO works fine with this particular function or feature but it fails in such and such context; LO is broken". I'm not saying this request should be completely rejected; I'm saying the "feature" doesn't seem to be defined in precise terms. How is Calc currently importing "dynamic" formulas from XLSX files? Is there some definition for "dynamic arrays" in some ODF(F) extension, or in the standard itself? If there isn't, then IMHO _that_ should be developed/defined first (and sooner rather than later, because, with time, these requests are probably going to be more frequent). -- You are receiving this mail because: You are the assignee for the bug.
