Apache OpenOffice (AOO) Bugzilla – Issue 70135
DataPilot gives percent results in an unreasonable number format
Last modified: 2017-05-20 11:11:21 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.
@swubuntu Please contribute a sample document with a realistic application showing that problem.
Created attachment 42964 [details] requested sample document
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".
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
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
Hi Niklas, one for you I think. Frank
change target from 2.x to 3.x according to http://wiki.services.openoffice.org/wiki/Target_3x
Reset assigne to the default "issues@openoffice.apache.org".