How to hide empty subtotals columns when showTotals is set to false?
Open this fiddle: http://jsfiddle.net/czL2yk76/
First columns “Sum of Price” and “Sum of Discount” are empty because showTotals is set to false, but they are still using some space.
Is it possible to hide those columns?
If you expand “Australia”, “Australia Total” is hidden if showTotals is set to false. I would like to have the same behaviour for columns.
Moreover, it would be great to be able to specify if we want rows subTotals, columns subTotals, or both, like for showGrandTotals (“rows”/”columns”/”on”/”off”).
Thank you for writing. Currently, our сlassic view option is available for row headers. Column headers are displayed in a compact form, that is why you see the empty columns. We have already received the requests about adding the classic view for column headers from our other customers. This feature is added to our customers’ wish list. However, we are not able to provide you with an estimated timeframe. We will inform you about any updates on the subject.
As to your second request about rows and columns subTotals, we would like to know the following: are you interested in this feature regardless the implementation of the ‘classic view for column headers’ feature? Our development team will consider the further steps based on your reply. We would be grateful for your feedback.
Thanks for your quick answer. Yes, about rows and columns subTotals, I’m interested in this feature regardless the implementation of the ‘classic view for column headers’ feature.
We are going to release our next major version 2.4 in a month. We can offer to add rows and columns subTotals feature during one of the first minor releases after 2.4. Would it work for you? Also, please tell us which component’s version you are using now.
Yes, it’s OK. We are using version 2.314.
I am glad to inform you that the minor releases 2.403 is available for download now.
showTotals option was extended to show subtotal rows (
"rows"), subtotal columns (
"columns"), all subtotals (
"on" ) or do not show them (
"off" ). Please note that Options pop-up in Toolbar was updated respectively to use extended
showTotals option. The localization variables were updated as well.
You are welcome to update the component.