Issue 50511 - User defined percentage format with second subformat and calculate precision as shown displays rounded integer value
Summary: User defined percentage format with second subformat and calculate precision ...
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.3
Hardware: All All
: P4 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-06-09 04:50 UTC by mrsoto
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

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

Attachments
Please see Q4 cell and it's formula. xls file saved as sxc (23.25 KB, application/vnd.sun.xml.calc)
2005-06-09 04:53 UTC, mrsoto 		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 mrsoto 2005-06-09 04:50:50 UTC 
I've applied average (really PROMEDIO in spanish) to range which has text and
numbers, all less that 100% and the average function return 100%

values: "N/A" 0 0 0.5 0.5 0.5 0
result: 100%
Comment 1 mrsoto 2005-06-09 04:53:49 UTC 
Created attachment 27034 [details]
Please see Q4 cell and it's formula. xls file saved as sxc
Comment 2 mrsoto 2005-06-09 05:00:16 UTC 
After change number format from average's input range the result change from
100% to 0%. To see change format in range B4:H7. Q4 will change!!
Comment 3 frank 2005-06-09 10:35:16 UTC 
Hi,

this is not a prio 1 task. P3 fits better.

The problem in this case can be solved if you untag precision as shown under
tools options spreadsheet calculate.

There is an other Issue regarding the import of this setting. ( Issue 48139 )

The remaining problem is how we set the results of calculations if user defined
number formats are set and precission as shown is selected. This is declared as
Prio 4 and target later.

Frank
Comment 4 ooo 2005-06-09 12:59:18 UTC 
To be precise, the problem is "precision as shown" in combination with a
percentage number format that contains a string and a second subformat:

"P: "0%;"P:  N/D"

If the second subformat is removed the correct value is shown:

"P: "0%

Eike
Comment 5 ooo 2005-06-09 13:06:28 UTC 
Adapting summary.
Comment 6 jcfrivera 2009-07-01 02:31:31 UTC 
OpenOffice.org 3.0.1
Issue: 
Calculation - Precision as shown

Problem:
Computations are made with rounded integers and not as rounded decimal places
Comment 7 Marcus 2017-05-20 11:13:43 UTC 
Reset assigne to the default "issues@openoffice.apache.org".