Issue 70135

Summary: DataPilot gives percent results in an unreasonable number format
Product: Calc Reporter: niederbayern <eva-email>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, kyoshida, rainerbielefeld_ooo_qa
Version: OOo 2.1Keywords: needmoreinfo, oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 15522    
Description Flags
requested sample document none

Description niederbayern 2006-10-05 15:22:59 UTC
DataPilot forces the number format of its resulting data cells to the number
format found in the cells of the corresponding source column.

When the options of a data field are set
  to "Displayed value Type = % of"
  or "Displayed value Type = % difference from"
  or "Displayed value Type = % of row"
  or "Displayed value Type = % of column"
  or "Displayed value Type = % of total"
the applied number format must not equal the number format of the source data.

Instead, a percent format or the number format "General" has to be applied.

Example: The ratio $10.00 / $200.00 € is NOT $0.05
The only valid indication of the ratio is 5% or 0.05

Note: It is no solution for the user to manually adjust the number format after
creating a DataPilot, because the number format is forced to the format of the
source column each time the DataPilot is updated.
Comment 1 Rainer Bielefeld 2007-02-13 06:10:38 UTC
Please contribute a sample document with a realistic application showing that
Comment 2 niederbayern 2007-02-13 06:47:15 UTC
Created attachment 42964 [details]
requested sample document
Comment 3 niederbayern 2007-02-13 06:49:44 UTC
The attachmed sample document contains two almost similar DataPilot results that
both are based on the data in sheet "Umsatzliste". The only difference is, that
the second DataPilot has been set to the option "Displayed value Type = % of

The DataPilot´s result automatically shows the number format "currency" because
this is the number format of the source data. This is fine only in the first
case. In the second case however, the result means relative values. It is
nonsense to display relative values in a "currency" number format.

One could try to set the number format to "percent" after doing the DataPilot.
However, this is no solution, because as soon as any minor change is done to the
DataPilot, the number format automatically is reset to "currency".
Comment 4 Rainer Bielefeld 2007-02-13 07:29:34 UTC
I checked with "2.0.2  German version WIN XP: [680m5(Build9011)]" and can
confirm the problem.

Help describe this function (correctly) "... result will be divided by the
result of the ...".
The quotient of 2 numbers with the same unit is an absolute measure without any
unit. So for this option the unit of the source data may not be shown.

Additionally, the result should be shown as %, and not as the simple quotient.

Pls. specify your OS and platform
Comment 5 niederbayern 2007-02-13 08:03:42 UTC
I have detected this issue in
OOo 2.1.0 with Windows 2000 SP4
OOo 2.0.4 with Windows 2000 SP4
OOo 2.1.0 with Ubuntu Linux Edgy 6.10
OOo 2.0.2 wiht Ubuntu Linux Dapper 6.06
Comment 6 frank 2007-02-13 10:23:23 UTC
Hi Niklas,

one for you I  think.

Comment 7 Martin Hollmichel 2007-11-09 16:52:58 UTC
change target from 2.x to 3.x according to
Comment 8 Marcus 2017-05-20 11:11:21 UTC
Reset assigne to the default "".