Starting column/row index

Starting column/row index

Posted by: lalvarez1 on 2 April 2018, 11:27 pm EST

• 

  lalvarez1

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 2 April 2018, 11:27 pm EST

  Hi,

  I’m in the process of evaluating your product as a possible solution to converting a Visual Basic 6.0 that uses FPSpread application into a Visual basic 2017 WPF application. The VB 6.0 application addressed FPSpread columns/rows starting at 1, 1 (treating the header column and row as 0, 0). I’m considering SpreadNET 11.0 WPF as a possible solution and continue my 30-day evaluation. Is there a way to modify the starting index from 0, 0 to 1, 1? This will prevent modifications to other areas that use 1, 1 as a column/row starting index.

  Thank you,
  
  Luis Alvarez

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 4 April 2018, 2:22 am EST

  Hi Luis,

  You can change the number or letter displayed in the first column header in this sheet using StartingColumnNumber property. However this will be only used for display purpose and the underlying column index for the first column will always be 0. I don’t find a way to change that.

  Thanks,
  
  Deepak Sharma

• 

  lalvarez1

  • Post Options:
  • Link
    Copy

  Posted 12 April 2018, 2:52 am EST

  Deepak,

  Thanks for your response. I found a work around.