Vinaydhi
Occasional Contributor
Joined 10 years ago
User Profile
User Widgets
Contributions
How to insert new sheet in FarPoint Spread object?
Can anyone help me in adding new sheet in Farpoint Spread object? I am using TestComplete 14.0 version. I got to know some relevant functions to add a sheet but not able to use it properly: bwSpread = Aliases.ClausionFPM.TemplateEditWindow.splitContainer1.SplitterPanel.uxtpnlInpRptOutlook.uxSplitContainerControl.SplitGroupPanel2.tableLayoutPanel3.Edit_Template; bwSpread.TabStripInsertTab(); bwSpread.Sheets.Add(); bwSpread.Sheets.Insert();905Views0likes1CommentRe: Group Ungroup FarPoint Spreadsheet rows
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 !! -Vinay2.2KViews1like0CommentsRe: Group Ungroup FarPoint Spreadsheet rows
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 ? -Vinay1.1KViews0likes1CommentRe: Group Ungroup FarPoint Spreadsheet rows
Hi Alex, I tried that. It gives error: System.NullReferenceException: Object reference not set to an instance of an object. at FarPoint.Win.Spread.SheetView.ExpandRangeGroup(RangeGroupInfo group, Boolean isRowGroup, Boolean expand) -Vinay1.2KViews0likes2CommentsRe: Group Ungroup FarPoint Spreadsheet rows
I found below C# code to expand the row group: fpSpread1.ActiveSheet.AddRangeGroup(0, 20, true); fpSpread1.ActiveSheet.AddRangeGroup(0, 10, true); fpSpread1.ActiveSheet.AddRangeGroup(0, 5, true); private void Button1_Click(object sender, System.EventArgs e) { FarPoint.Win.Spread.RangeGroupInfo[] rgi = fpSpread1.ActiveSheet.GetRangeGroupInfo(2, true); fpSpread1.ActiveSheet.ExpandRangeGroup(rgi[0], true, true); } How can I convert it into JScript so that it can work in TestComplete? -Vinay2.3KViews0likes4CommentsGroup 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". Can anyone help me? -Vinay DhingraSolved2.9KViews0likes13Comments