Excel base 1, SpreadJS base 0: how can I change this in spreadjs?

Excel base 1, SpreadJS base 0: how can I change this in spreadjs?

Posted by: brian.ploe on 5 August 2021, 3:07 pm EST

• 

  brian.ploe

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 5 August 2021, 3:07 pm EST

  I am converting existing Excel sheets with macros, that I did not create, and have discovered that a the macros in vba use base one for row/colreferences whereas SpreadJS uses base 0. Is there a way to tell SpreadJS to use base 1 to make conversion easier? Having to explicitly identify all vba variables and row/col indexes stored as cell values (uhg!) and change them to base 0 increase my chance of missing something or introducing errors.

  Thanks!

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 6 August 2021, 7:14 am EST

  HI Brian,

  We are sorry but this by design. The spreadJS marks the rows, col index from 0. What you could do is create your own util function that convert these indexes according to your need. I hope this clarifies the issue let me know if you have any further queries regarding this case.

  Regards
  
  Avinash