Posted 8 September 2017, 1:57 pm EST
Hi, I have the following piece of code that works well at copying selected rows.
The trouble I'm having is that if I copy after sorting by a column, it is copying what was originally in the selected rows' position.
I can see that it's copying the rows in the data positions rather than the sheets view positions. How can I remedy this?
FarPoint.Win.Spread.Model.IRangeSupport irs; irs = (FarPoint.Win.Spread.Model.IRangeSupport)fpBOM.Sheets.Models.Data;
cr = fpBOM.Sheets.GetSelection(0);
if (cr != null)
irs.Copy(cr.Row + cr.RowCount, 0, 0, 0, cr.RowCount, fpBOM.Sheets.ColumnCount);