#10498: Pivot Grid with only Row Field does not carry count function to Excel 2007

kin-hong reported 2013-10-17T20:30:28Z · last modified 2013-10-22T16:40:37Z

Dev	kin-hong
QA	swissarmyknife(*)

Priority	Low
Complexity	Unknown

Component	Q Analyzer - Pivot Grid Results
Version	15.0

1. In ADS, ensure File->General->Default Spreadsheet Format is set to "Excel 2007"

2. Set up a pivot grid in a Query Analyzer

3. Add one numeric row field (do not add data or column fields)

4. Notice that the Grand Total column shows Count function

5. Click View as Spreadsheet. Notice that the "Pivot Result" sheet in the Excel Workbook displays the column with Sum function

6. This problem does not exist if File->General->Default Spreadsheet Format is set to "Excel 2003"

All Comments (3) Change History

kin-hong 2013-10-17T21:08:26Z

This issue also occurs in the latest version of Aspose.Cells for Java (7.6.0).

This issue does not occur if it is saved as Excel 2003 format.

We will submit a bug to Aspose.

SachinPrakash 2013-10-18T17:05:20Z

SachinPrakash 2013-10-22T16:40:37Z

Turns out that there is a bug in LibreOffice, not Aspose.