GridWeb Control - Showing the grouped rows in collapsed state by default

Aspose.Cells Product Family
1

Hello,

I have the following requirement.

On the gridweb control, I am grouping certain rows. I need to show the first two groups in collapsed state and rest in expanded state when the page loads for the first time.

As of now, all groups are loaded in their expanded state.

Can you suggest a solution to acheive this?

Thanks.

2

Hi,

I am afraid the feature is not supported for Grouping Rows of GridWeb control. I have logged a ticket for Grouping Rows feature’s enhancement with an id: CELLSNET-25682. We will look into it soon.

Thank you.

3

Can we do the collapsing of the group (of rows) using some client-side code in any way?

Thanks.

4

Hi,

I am afraid, there is also no client side scripts available for collapsing the grouped rows. We are already working on your issue to figure it out soon. Once we have any update, we will update you here.
Thank you.

5

Hi,

We have fixed your issue in our latest fix release Aspose.Cells.GridWeb v2.5.1.2003. That you can download from this link.

It is now available that setting rows-group’s state in this latest fix. Please try the following script, the first parameter of setGroupedRowsState() is zero-based index of rows-groups.

function expand()<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

{

var grid = document.getElementById("GridWeb1");

grid.setGroupedRowsState(0, "expanded");

}

function collapse()

{

var grid = document.getElementById("GridWeb1");

grid.setGroupedRowsState(0, "collapsed");

}

Please update the Aspose.Cells.GridWeb.dll file first, and then remove all files in /acw_client/ virtual directory, update it with /acw_client directory in the zip file.

Looking forward to your test results.

6

Thanks for the updates. I will check it and let you know the test results.

7

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan