Posted 17 July 2018, 5:48 am ESTHi Team,
We are migrating our project from VB6.0 to VB.NET 4.7 .
We are updating Spread .NET V11 from Spread COM 2.5.
But there are many changes in the code when we upgrading SPread .NET 11.
Spread properties has been changed and I want to know the Spread .NET 11 Properties of Spread COM 2.5
I already gone through below URL , But I couldn't find the properties which I want update in the code.
Spread1.ActiveSheet.ActiveRowIndex = 1
Spread1.ActiveSheet.ActiveRowIndex2 = i
Spread1.ActiveSheet.ActiveColumnIndex = 1
Spread1.ActiveSheet.ActiveColumnIndex2 = Spread1.ActiveSheet.ColumnCount
Spread1.BlockMode = True
Spread1.SortBy = 0 'sort by cols
Spread1.SortBy = 0 'sort by rows
Spread1.set_SortKey(1, 2) 'name column
Spread1.set_SortKeyOrder(1, 1) 'ascending key 1 order