Replied 8 September 2017, 2:16 pm EST
For dispalying the combo box in the hirarchical view ( 3 leavels), I am using the below code.
BUt this is not working properly.
First time it is coming for parent rows. When I am exapnding the first level, the combo box is not displaying. When I exapnd the second level then in the first level, combo box is displaying and in the second level is not displaying.
If I am exapnding the other parent row, then teh above second level combo is dispalying.. But same case for again other rows.
Can some one can help us why it is happening. Is there any wrong in the code?
Code is attached here.
objDSDM = (FarPoint.Win.Spread.Model.DefaultSheetDataModel)fpSpreadRangeDecision.Sheets.Models.Data;
int intRangeCodeColPOS = objDSDM.GetColumnIndex("STATUS");
fpSpreadRangeDecision.ActiveSheet.Columns[intRangeCodeColPOS].CellType = cmboStatus1;
ArrayList alSht1 = fpSpreadRangeDecision.Sheets.GetChildSheets();
FarPoint.Win.Spread.SpreadView childvw, grandchildvw;
foreach (FarPoint.Win.Spread.SheetView chlSht1 in alSht1)
childvw = fpSpreadRangeDecision.GetRootWorkbook().GetSpreadView(chlSht1, 0, 0);
if (childvw != null)
childvw.Sheets.Columns[intRangeCodeColPOS].CellType = cmboStatus2;
alSht2 = chlSht1.GetChildSheets();
foreach (FarPoint.Win.Spread.SheetView chlSht2 in alSht2)
grandchildvw = childvw.GetSpreadView(chlSht2, 0, 0);
if (grandchildvw != null)
grandchildvw.Sheets.Columns[intRangeCodeColPOS].CellType = cmboStatus3;
Thanks in advance,