Posted 8 September 2017, 2:52 pm EST
I have a requirement in farpoint spread control like below:
in the first row, there are merge cell named: bbb;
first I should copy this merge cell to next and merge those tow cell in to one cell(still named like: bbb);
second, I want to copy this first row to below at row 8;
the first operation is implemented in button (Copy bbb and Merge to one cell) like below:
this.fpSpread1.Sheets.CopyRange(0, 1, 0, 5, 1, 4, false);
this.fpSpread1.Sheets.AddSpanCell(0, 1, 1, 8);
the second operation is implemented in button(Copy first row to below) like below:
this.fpSpread1.Sheets.CopyRange(0, 0, 8, 0, 6, 200, false);
the issue is that the CopyRange function has conflicts with this merge cells.
Exception popup and say that: This operation will cause overlapping spans.
I had attached my simple solution in Attachments, Can you help me have a look with this conflict and find one walkaround with this requirement.