https://bugs.documentfoundation.org/show_bug.cgi?id=165355
Laurent Balland <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #5 from Laurent Balland <[email protected]> --- If I understand correctly, you used in column E {=TREND( B$2:B$1312 ; A$2:A$1312 ; A2 ; )} which is interpreted as {=TREND( B$2:B$1312 ; A$2:A$1312 ; A2 ; 0 )} If 4th parameter is 0, then trend is forced to go through origin, and the result is different from what you expected. You need to define your fourth parameter different from 0 or nothing. You may also simply ignore it. Simply use {=TREND( B$2:B$1312 ; A$2:A$1312 ; A2 )} to get the expected result. Moreover (it is outside the scope of this bug report), you create 1311 matrix formula, with a different third parameter, where each matrix is composed of one cell. It is unnecessary. Create only one matrix calculation for the whole column {=TREND( B$2:B$1312 ; A$2:A$1312 )} the result should be as you expected. If I misunderstood your problem, feel free to set it back to "UNCONFIRMED" and give more details. -- You are receiving this mail because: You are the assignee for the bug.
