Details

Type: Bug

Status: Applied

Priority: Major

Resolution: Fixed

Affects Version/s: ODF 1.2

Fix Version/s: ODF 1.3

Component/s: OpenFormula, Part 2 (Formulas)

Labels:None

Proposal:
Description
The formulas for SS~resid~ and SS~reg~ and R2 have wrong index.
For example for case const=TRUE() it is
// SS_{resid} = sum from j=1 to k ((a+ sum from i=1 to n b_j x_{i j})y_i)^2
but it should be
// SS_{resid} = sum from i=1 to k ((a+ sum from j=1 to n b_j x_{i j})y_i)^2
The current version makes no sense because currently the index of b refers to the outer sum and the index of y refers to the inner sum.
For the other cases see the proposal.
Please Andreas, have a look.