Issue 74215 - Writer should use the figures displayed for calculation, like Calc does
Summary: Writer should use the figures displayed for calculation, like Calc does
Status: CONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0.4
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-02-06 10:59 UTC by ccps
Modified: 2013-02-07 22:33 UTC (History)
2 users (show)

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

Attachments
wrong result in writer if values are not rounded (14.33 KB, application/vnd.oasis.opendocument.text)
2007-02-06 11:02 UTC, ccps 		no flags Details
wrong results in writer table if values are not rounded (10.00 KB, application/vnd.oasis.opendocument.text)
2007-02-06 11:05 UTC, ccps 		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 ccps 2007-02-06 10:59:07 UTC 
Writer behaves differently than Calc when calculating. If the figures are not
explicitly rounded (like: =<A2>*<B2> round 2), it delivers wrong results.
Formatting the cells with 2 Decimal Places has only a visual effect.

Calc automatically uses the rounded figures for calculations, just by formatting
the cells and defining the desired number of decimals.
Comment 1 ccps 2007-02-06 11:02:14 UTC 
Created attachment 42781 [details]
wrong result in writer if values are not rounded
Comment 2 ccps 2007-02-06 11:05:24 UTC 
Created attachment 42782 [details]
wrong results in writer table if values are not rounded
Comment 3 ccps 2007-02-06 11:09:08 UTC 
Example1.ods is a Calc table showing the difference. Sorry for the mix up.
Comment 4 kpalagin 2007-02-06 12:45:07 UTC 
Confirming with 2.2 m5 (build 9114).
Comment 5 michael.ruess 2007-02-06 13:50:25 UTC 
Reassigned to requirements.