Pivot Grid API needs more depth

[dsconzoParticipant]

Hi JQX Team,

Thanks for the awesome widgets! I’m having a really hard time manipulating what should be easy features in the jqxpivotgrid! https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxpivotgrid/jquery-pivotgrid-api.htm?search=

Things like:

a) Setting the value width – it doesn’t default to the text size in the value items and I don’t see any documentation under value items on where to set it. Shouldn’t sizing to the value name be default like in excel?

b) Setting the width of the expanding row items – they don’t default to the size of the row name, it gets cut off. Shouldn’t sizing to the row name be default like in excel?

c) How can I change where the popups for the grid designer items are displayed (filters, columns, rows, and values)?

d) Renaming the items in the grid designer’s values popup – ‘Nagatives’ should be ‘Negatives’

Can you guys provide better api documentation or alternatively typescript classes so that I can see what I can play with with the objects?

Thanks so much!

-Denis

[dsconzoParticipant]

So I guess some of the features I thought were normal are not. My apoologies if I came off as rude. Can someone help me figure the issue above I noted?

Thanks so much!

Kind Regards,
Denis Sconzo

[TodorParticipant]

Hello Denis,

a) and b) – unfortunately there is no property for width manipulation. You could check the following docs to find out which pivotgrid’s classes can be changed.
c) – as above
d) – this is a typo by our side. It would be fixed. You could not change it.

Let us know if you need further assistance.

Best Regards,
Todor

jQWidgets Team
https://www.jqwidgets.com

[dsconzoParticipant]

Thanks so much Todor.

Can I have an example of how to apply a custom style based on the directions below? I don’t know how to set the theme property!

When you create a custom style with colors and backgrounds for jqxPivotGrid, you need to do the following:
Add the above CSS classes related to jqxPivotGrid
After each CSS class, add your theme name.
For example:
jqx-pivotgrid-light
To apply your custom style to jqxPivotGrid, you need to set its ‘theme’ property(option) to point to your theme name string.

[TodorParticipant]

Hello Denis,

Please review the following example whether it fits your needs.

Let us know if you need further assistance.

Best Regards,
Todor

jQWidgets Team
https://www.jqwidgets.com

[dsconzoParticipant]

Hi Todor,

Thanks for the example, but it does not work, even when I use an ‘!important’. Can you please provide better API documentation or a typescript class so I can see what is going on with this widget? The documentation here, https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxpivotgrid/jquery-pivotgrid-api.htm?search=pivotgrid, is not sufficient. Most of the other jqx widgets have jsfiddle examples for how to use events. Jqx Pivot Grid has zero! I literally just clicked every tab in the api and every property, method, and event and there are no jsfiddle examples. Take a look at ‘Pivot Value Field’s formatSettings. It expands to nothing, all I know is that it is an object, which is not helpful at all.

Kind Regards,
Denis Sconzo

[TodorParticipant]

Hello Denis,

Thanks for your feedback. We are constantly trying to improve our API documentation and adding more examples. However we work on different tasks based on their priority level therefore the documentation is not updated so often.

There are also jqxPivotGrid demos page where you could find examples about events and other features.

Also if you have a certain question we could try to provide an example.

Best Regards,
Todor

jQWidgets Team
https://www.jqwidgets.com

[dsconzoParticipant]

Thanks I guess. I’m going to try a different pivotgrid object then.

[Author]

Posts