4 Replies Latest reply on Sep 21, 2018 2:33 AM by a venky

    Export to Crosstab works differently in Desktop and web - bug?

    Eric McDonald

      The Desktop menu option: Worksheet -> Export -> Crosstab to Excel works differently to the web Export -> Crosstab. The web version produces a true worksheet with an entry in every cell (as a .csv file and is correct), the Desktop version attempts to group the data and merge cells (as a .xls file). is this a bug? Surely they should work the same way? Can the Desktop version just export to simple csv with no grouping?

       

      (export to Access is not an option!)

       

      Web Example:

      Category     Product     Value

      Toys           Car           100

      Toys           Spider       10

      Games        Lotto         12

      Games        Cards         5

      Games        Chess        15

       

      Desktop Example:

      Category     Product     Value

      Toys           Car           100

                        Spider       10

      Games        Lotto         12

                        Cards         5

                        Chess        15