https://issues.apache.org/ooo/show_bug.cgi?id=123524
Bug ID: 123524
Issue Type: DEFECT
Summary: 502 error when using more than 1 column in known_x
with FORECAST function
Product: Calc
Version: 4.0.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: ui
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Price Sq.Ft. Lot Beds Baths Fireplace Sprinkler Fence
$/ft.
$329,460 3068 0.37 3 2.0 0 1 0 107.39
330,000 2516 0.50 5 3.0 1 0 1 131.16
268,000 3196 0.34 4 2.5 1 0 1 83.85
366,000 3206 0.28 4 3.5 1 0 0 114.16
400,000 3524 0.27 4 3.0 1 1 0 113.51
415,000 3083 0.39 4 2.5 1 0 0 134.61
330,000 2789 0.20 3 2.5 1 0 1 118.32
FORECAST(C2 ;B3:B8;C3:C8) returns 352308.78812199
FORECAST(C2:I2;B3:B8;C3:J8) returns error 502
FORECAST(C2:I2;B3:B8;C3:J8) returns error 502
FORECAST(C2:I2;B3:B8;C3:C8) returns
352308.78812199 193943.083441481 194078.856596428 194027.231822684
193923.982275195 193975.60704894 193923.982275195
The last example ought to throw an error because there are more columns in the
'value X' than in the 'known X' parameters, shouldn't it?
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
