Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||DataPilot gives percent results in an unreasonable number format|
|Component:||formatting||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||issues, kyoshida, rainerbielefeld_ooo_qa|
|Version:||OOo 2.1||Keywords:||needmoreinfo, oooqa|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
|Issue Depends on:|
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
@swubuntu Please contribute a sample document with a realistic application showing that problem.
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 column". 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. @swubuntu 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. Frank
Comment 7 Martin Hollmichel 2007-11-09 16:52:58 UTC
change target from 2.x to 3.x according to http://wiki.services.openoffice.org/wiki/Target_3x