Search:

If anyone is still interested in this and migrated to any ExtJS 6.x then please take a look here https://www.mzsolutions.eu/grid-plugins.html

Not sure if you are still interested in multi level grouping but if you are then please take a look here https://www.mzsolutions.eu/grid-plugins.html

I leave this here for anyone that's interested in a multi level grouping for Ext JS 6.x: https://www.sencha.com/forum/showthread.php?471095-Multi-level-grouping-in-Ext-JS-6-x

Grid Plugins is a product I've been working on lately which adds important features to the grid panel:

multi level grouping
grouping panel to easily drag-and-drop grid columns in the grouping...

That’s for modern toolkit http://examples.sencha.com/extjs/6.6.0/examples/kitchensink/?modern#tabular-pivot-grid
There’s one example in classic KS too.

Tabular layout is available since version 6.5.

There’s something wrong with the definition of the pivot table in the generated xlsx. Can’t debug this. Maybe support team can do that with a proper test scenario.

Excel generates a log file with things that were wrong in the file. Do you have it?

What error? I don’t see any.

Take a look at how this aggregator function is implemented and do your own for the third aggregate dimension. Provide IDs to the aggregate dimensions because those will be available in the result...

The 'core' package is part of both toolkits so what I said above is valid for classic too.
You probably took the 'exporter' package from 6.5.1 and used it with a previous ExtJS version. This might...

Thanks for the report! I have opened a bug in our bug tracker.

Ext.concat exists. You will find the method in the 'core' package /src/Util.js. It's a docs issue since you can't see it there

Here you will find all supported values for "exportStyle.format": http://docs.sencha.com/extjs/6.5.0/modern/Ext.exporter.file.Style.html#cfg-format
If exportStyle.format, formatter and...

Gabe, just saw that you were talking about the Excel xml format. My answer above applies to both xml and xlsx formats and you need to define autoFitWidth on the exportStyle of that grid column:

...

Hi Gabe,

autoFitWidth doesn't really work as expected. I played around with Excel to check what it does in the xlsx when you double click a column to set autoFitWidth. Basically Excel calculates...

You can either get the nightly for 6.2.x or upgrade to 6.5.

This bug was filed as EXTJS-23405 and has been fixed already and is available in the nightly.

If you reload that fiddle you will see the fix inside. I just updated it.

Do you have a fiddle for this?

I have included a fix in your fiddle.

On that top axis dimension you can define the "sortIndex" to point to a field on the model that has numeric values that can be sorted properly.

In 6.0.1 you can only export it to Excel xml. 6.2.x offers more exporters.

You can't do that

If you use 6.2.x then you need to override the method "handleEvent" on the class Ext.pivot.plugin.configurator.Panel.