You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/01/29 17:18:19 UTC

DO NOT REPLY [Bug 118849] New: pivot report produces rows instead of columns

https://issues.apache.org/ooo/show_bug.cgi?id=118849

             Bug #: 118849
        Issue Type: DEFECT
           Summary: pivot report produces rows instead of columns
    Classification: Application
           Product: Spreadsheet
           Version: OOO330m20
          Platform: PC
        OS/Version: Windows Vista
            Status: UNCONFIRMED
          Severity: normal
          Priority: P5
         Component: editing
        AssignedTo: ooo-issues@incubator.apache.org
        ReportedBy: tommyads@yahoo.de


>From the Table
ColA    ColN1    ColN2
Alpha    22    54
Alpha    32    2
Beta    5    33
Gamma    3    43
Gamma    44    66

the data-pilot should generate a report summing up the corresponding numbers
for the same values in column ColA, yielding the table

ColA    ColN1    ColN2
Alpha    54    56
Beta    5    33
Gamma    47    109

But, instead of this, it yields the table

ColA    Daten    
Alpha    Summe - ColN1    54
    Summe - ColN2    56
Beta    Summe - ColN1    5
    Summe - ColN2    33
Gamma    Summe - ColN1    47
    Summe - ColN2    109

which is not at all useful!
The other possibility leads to the table

    ColA        
Daten    Alpha    Beta    Gamma
Summe - ColN1    54    5    47
Summe - ColN2    56    33    109

which is better, but still not usefull.

If this is not a bug, please give a hint how to achieve the wanted table. 
Thanks!
Best regards!

-- 
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

DO NOT REPLY [Bug 118849] pivot report produces rows instead of columns

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118849

tommyads@yahoo.de changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Priority|P5                          |P3

-- 
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

[Bug 118849] pivot report produces rows instead of columns

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118849

Terry Yang <po...@hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
                 CC|                            |polo8495@hotmail.com
     Ever confirmed|0                           |1

--- Comment #1 from Terry Yang <po...@hotmail.com> ---
Confirm at my side, Can't create such Pivot table, Try with MS office, it can
create such Pivot table

-- 
You are receiving this mail because:
You are the assignee for the bug.