Forum Discussion

Vinaydhi's avatar
Vinaydhi
Occasional Contributor
8 years ago

Group Ungroup FarPoint Spreadsheet rows

I want to group ungroup rows of farpoint spreadsheet by clicking +/- buttons and/or by clicking 1/2/3/4 buttons. These buttons are highlighted with yellow colour in the attachment "GroupUngroup.PNG"....
  • Vinaydhi's avatar
    Vinaydhi
    8 years ago

    This issue is resolved with the help of SmartBear customer care.

     

    Solution was:

    var rgi = fpSpread1.ActiveSheet.GetRangeGroupInfo(2, true);
    fpSpread1.ActiveSheet.ExpandRangeGroup(rgi.GetValue(0), true, true);

     

    Thanks SmartBear !!

     

    -Vinay

Vinaydhi's avatar
Vinaydhi
Occasional Contributor

Reason that we are not able to expand RangeGroup is that we are not getting any result for the below method.

 

fpSpread1.ActiveSheet.GetRangeGroupInfo(1, true)

 

Even though groups are available on the sheet but still this method GetRangeGroupInfo does not return anything in our case.

 

Please note if we use GetRangeGroupLevels then it shows correct number of levels.

 

Is there anything that we are missing to get the RangeGroupInfo ?

 

-Vinay

Vinaydhi's avatar
Vinaydhi
Occasional Contributor
8 years ago

This issue is resolved with the help of SmartBear customer care.

 

Solution was:

var rgi = fpSpread1.ActiveSheet.GetRangeGroupInfo(2, true);
fpSpread1.ActiveSheet.ExpandRangeGroup(rgi.GetValue(0), true, true);

 

Thanks SmartBear !!

 

-Vinay