Posted 8 September 2017, 1:48 pm EST
I'm using VS2005(latest SP) and FarPoint Spread v4.0.2009.2005.
I don't know whether this is a bug or something by-degin.
I have some example data, it has only 68 rows.
First cell of each row indicated group name.
First group name is "A" and first group has 21 rows.
Second group name is "B" and it has 33 rows.
Third group name is "C" and it has 14 rows.
I create a new spread as fsdList on control, and added to my data for each record.
And I initialize only first group is visible true.
After then whenever user chooses one group, I would like to show only rows of selected group.
So, I coeded below.
for (int r = 0; r < fsdList.ActiveSheet.Rows.Count; r++)
if (fsdList.ActiveSheet.Cells[r, 0].Text == SelectedGroupName)
These codes works well when I clicked for editing some row under 21(this number is the number of first group and set visible true at first.) of other group("B" or "C").
But, when I clicked some row over 21,then the focus return to 21.
So I couldn't edit some cells over 21 because the focus of cell return to the last cell of first group.
I meet this problem after upgraded to FarPoint Spread v4.0.2009.2005, I've never seen before.
Please let me know what do I do to solve this problem.