What is the equivalent property for Index(spread 3) in spread 8

What is the equivalent property for Index(spread 3) in spread 8

Posted by: adarshab039 on 13 September 2018, 4:18 am EST

• 

  adarshab039

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 13 September 2018, 4:18 am EST

  Spread 3 COM had Index property and I am looking for equivalent property in spread version 8.

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 13 September 2018, 3:11 pm EST

  Hello,

  You can use Control.ControlCollection.GetChildIndex & Control.ControlCollection.SetChildIndex in Spread.Net for equivalent of Spread 3 COM’s index property.

  Please go through these documentation links for the same:-
  
  http://help.grapecity.com/spread/SpreadNet11/WF/webframe.html#spwin-comprops.html
  
  http://help.grapecity.com/spread/SpreadNet11/WF/webframe.html#spwin-comequivalents.html

  Hope it helps.

  Thanks,
  
  Reeva

• 

  adarshab039

  • Post Options:
  • Link
    Copy

  Posted 15 September 2018, 2:31 am EST

  Hi Would you please let me know how implement the same. The below mentioned implementation sounds correct to you?

  Dim child As Control
  
  sprIn As AxFPSpreadADO.AxfpSpread
  
  sprIn.Controls.GetChildIndex(child)

  Please let me know if I am wrong

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 16 September 2018, 3:36 pm EST

  Hello,

  You want to implement the index property of Spread COM version 3 in Spread COM version 8 or Spread .Net version 8. Please specify the platform. We will answer your issue accordingly.

  Thanks,
  
  Reeva

• 

  adarshab039

  • Post Options:
  • Link
    Copy

  Posted 18 September 2018, 12:45 am EST

  Would anyone please reply, I want to implement using Spread COM version 8.

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 18 September 2018, 6:37 pm EST

  Hello,

  Since you are trying to use Spread COM 8 in .Net Winforms application. Hence, you cannot use index property as Index property works for COM controls in ActiveX environment i.e. VB6 and not for COM components in .Net environment.

  And even GetChildIndex() method won’t work here because it is meant for controls .Net technology.

  Further it is also not advisable to use Spread COM in .Net managed environment. Hence, we request you to switch to Spread.Net for .Net Winforms application.

  You can download the same from this link:-
  
  https://www.grapecity.com/en/download/spreadnet

  Hope it clarifies.

  Thanks,
  
  Reeva

• 

  adarshab039

  • Post Options:
  • Link
    Copy

  Posted 27 September 2018, 8:38 am EST

  Hi Reeva,

  I contacted your support team and they suggested me to use spread 8 for dot net as it is a backward compatibility. Now would you please tell me how to implement index property in spread 8.

  Thanks,
  
  AB

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 27 September 2018, 3:41 pm EST

  Hello,

  Index (standard Visual Basic property) of Spread COM can be implemented in Spread.Net using below mentioned GetChildIndex & SetChildIndex property as stated in first post also:-

  Control.ControlCollection.GetChildIndex
  
  Control.ControlCollection.SetChildIndex

  http://help.grapecity.com/spread/SpreadNet11/WF/webframe.html#spwin-comprops.html

  Hope it helps.

  Thanks,
  
  Reeva