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 = <span class="kwd">this</span>.fpSpread1_Sheet1.GetSelections();
<span class="kwd">int</span> start = cr.Row;
<span class="kwd">int</span> len = cr.RowCount;
String msg = <span class="st">""</span>;
<span class="kwd">for</span> (<span class="kwd">int</span> i = start; i < start+len; i++)
msg += i + <span class="st">") "</span> + <span class="kwd">this</span>.fpSpread1_Sheet1.Cells[i, 1].Value.ToString() + <span class="st">"\r\n"</span>;
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?