Hello,
I'm having problems with Workbook DataSorter sort method.
Can you explain me what is the reason for "Spire.Xls.Core.Spreadsheet.XlsWorkbook.2" exception that i get in this sentence?
string finalRangeStr = "A" + (sheet.FirstRow + 3).ToString() + ":F" + sheet.LastRow.ToString();
workbook.DataSorter.SortColumns.Add(0, OrderBy.Ascending);
workbook.DataSorter.Sort(sheet.Range[finalRangeStr]);
Maybe finalRangeStr is too big? Should I change finalRangeStr and use two int indexes?
Thanks in advance!