Issue 70135 - DataPilot gives percent results in an unreasonable number format
Summary: DataPilot gives percent results in an unreasonable number format
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks: 15522
  Show dependency tree
Reported: 2006-10-05 15:22 UTC by niederbayern
Modified: 2017-05-20 11:11 UTC (History)
3 users (show)

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

requested sample document (26.46 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-02-13 06:47 UTC, niederbayern
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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 "".