https://bugs.documentfoundation.org/show_bug.cgi?id=155239
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|7.4.6.2 release |Inherited From OOo OS|Windows (All) |All --- Comment #1 from Eike Rathke <[email protected]> --- This seems to be an Excel speciality nonsense. Apparently the cell range F1:F4 is forced into an array evaluation for --(F1:F4) without even entering the =SUM(--(F1:F4)) formula as array mode formula. Hence when in Calc for the formula on any row other than in 1:4 there is no implicit intersection with F1:F4 and the result is #VALUE! (in a row of 1:4 it would be the value of the one intersected cell of F1:F4). Effectively --(F1:F4) should be the same as -(-(F1:F4)) or --F1:F4 but likely Excel treats them different and =SUM(-(-(F1:F4))) and =SUM(--(F1:F4)) and SUM(--F1:F4) would not all produce the same results. I'm against implementing this unless it would be clearly specified by the ODF OpenFormula (ODFF) standard. -- You are receiving this mail because: You are the assignee for the bug.
