Issue 39304 - Calculation error with MULTIPLE.OPERATION() not using all intermediate values.
Summary: Calculation error with MULTIPLE.OPERATION() not using all intermediate values.
Status: ACCEPTED
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:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
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: ---

Attachments
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
Add an attachment (proposed patch, testcase, etc.)

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
problem)
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

Frank
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
behavior.
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 "issues@openoffice.apache.org".