Posted 8 September 2017, 12:42 pm ESTHi, I'm having problems getting selections behave as I would like it them to. I am using the following code:
FarPoint.Win.Spread.Model.CellRange cr = this.fpSpread1_Sheet1.GetSelections();
int start = cr.Row;
int len = cr.RowCount;
String msg = "";
for (int i = start; i < start+len; i++)
msg += i + ") " + this.fpSpread1_Sheet1.Cells[i, 1].Value.ToString() + "\r\n";
Which works well until user uses autofiltering, the rows that are not visible (now satistifying filter condition) are also selected, which means that if the rows look like:
and I use autofilter to display only rows with value 'name1' and then select them, rows with 'name2' and 'name4' will also be selected.
Is it possible the getselection()/getselections() methods to select only rows which are visible?