Issue 39304 - Calculation error with MULTIPLE.OPERATION() not using all intermediate values.
Summary: Calculation error with MULTIPLE.OPERATION() not using all intermediate values.
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2004-12-20 00:31 UTC by pridkett
Modified: 2017-05-20 11:13 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Sample file showing the problem (78.60 KB, application/vnd.sun.xml.calc)
2004-12-20 00:32 UTC, pridkett
no flags Details
Smaller example (5.54 KB, application/vnd.sun.xml.calc)
2005-01-06 09:53 UTC, niklas.nebel
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description pridkett 2004-12-20 00:31:28 UTC
I'm creating a fairly complex amortization spreadsheet to calculate house prices
with a variety of changeable variables.  However, I've noticed some odd behavor
(see that attached spreadsheet to know what I'm talking about).

It appears that it is telling me that $0.00 * InterestRate/12 = $204.58 in cell
D106 on sheet Amortization.  What's wrong with this is that InterestRate is set
to 5.77%; and as we all know 0 times anything is 0.

This issue seems to move around as the cells change some and I don't believe
it's a problem with my formula, but it could be.  It seems as though this
reappears randomly from time to time, see all cells D156 and D180.

It could be something boneheaded on my part, when I retype the formulas they
seem to work, until I change the value of "InputAdditionalPayment" on sheet
"BigPicture".  Auto-recalculate is turned off for this sheet.
Comment 1 pridkett 2004-12-20 00:32:09 UTC
Created attachment 20669 [details]
Sample file showing the problem
Comment 2 lohmaier 2004-12-26 22:30:26 UTC
can not reproduce.
You wrote "$0.00 * InterestRate/12 = $204.58"
but D106 contain "=C106 * InterestRate/12"
so why do you think that OOo should calculate "0*smoething"?

When I enter 0  in H105 and let it recalculate, I get 0 as result.

Please provide more details (a step-by-step description on how to reproduce the
Comment 3 frank 2005-01-05 14:58:09 UTC
Hi Eike,

please have a look at this one. Problem seems to be located in calculations with
named cells. For me cell d214 was the starting point. Using the direct absolute
cell reference solves the problem too. Checked also on OOo1.9.65

Comment 4 niklas.nebel 2005-01-06 09:53:29 UTC
Created attachment 21123 [details]
Smaller example
Comment 5 niklas.nebel 2005-01-06 09:54:04 UTC
It's the use of multiple operations with a function (MATCH) that uses only some
of the intermediate values. I attached a smaller example that shows the same
Comment 6 lohmaier 2005-01-06 17:49:56 UTC
since nn apparently could reproduce -> removing needmoreinfo keyword.
Comment 7 ooo 2005-02-03 14:17:42 UTC
Accepted. Dirty condition seems not to be properly handled. Adjusted summary.

Comment 8 Marcus 2017-05-20 11:13:39 UTC
Reset assigne to the default "".