Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | DataPilot gives percent results in an unreasonable number format | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | niederbayern <eva-email> | ||||
Component: | formatting | Assignee: | AOO issues mailing list <issues> | ||||
Status: | CONFIRMED --- | QA Contact: | |||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | issues, kyoshida, rainerbielefeld_ooo_qa | ||||
Version: | OOo 2.1 | Keywords: | needmoreinfo, oooqa | ||||
Target Milestone: | --- | ||||||
Hardware: | All | ||||||
OS: | All | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Issue Depends on: | |||||||
Issue Blocks: | 15522 | ||||||
Attachments: |
|
Description
niederbayern
2006-10-05 15:22:59 UTC
@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". |