Issue with cellRange.tag() in Spread 10

Issue with cellRange.tag() in Spread 10

Posted by: saurabh.kaushal on 25 September 2017, 8:03 am EST

• 

  saurabh.kaushal

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 25 September 2017, 8:03 am EST

  Hi,

  We have following lines of code to get the RowInfo from cellRange.tag() but cellRange.tag() returns null value for spread 10.

  var cellRange = activeSheet.getRange(rowNr, -1, 1, -1);
  
  if (cellRange === undefined || cellRange === null) return null;
  
  if (cellRange.tag() === undefined || cellRange.tag() === null)
  
  return null;
  
  return cellRange.tag().SubData;

  Note: The same code returns RowInfo for old spread (spread9).

  Could you please help?

  Thanks,
  
  Saurabh

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 26 September 2017, 5:45 am EST

  Hi Saurabh,

  Cell tag is a property which does not hold any value until you set it explicitly. Please make sure that you have set the Tag for that specific cellrange. Once I set the Tag for the cell range I can access the same anytime and I can set any information in the Cell Tag.

  Please refer to the attached sample applications(both for Spread.Sheets 9 and Spread.Sheets 10) and let me know if you found the behavior with Spread 9 and Spread 10 different.

  I would also appreciate if you could provide me your sample app for SpreadJS 9 where it returns the Row info in cell tag.

  Thanks,
  
  Deepak Sharma
  
  CelltagIssue.zip

• 

  saurabh.kaushal

  • Post Options:
  • Link
    Copy

  Posted 3 October 2017, 4:57 am EST

  Hi Deepak,

  It was fixed by setting the tag.

  Thanks,
  
  Saurabh Kaushal

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 9 October 2017, 1:26 am EST

  Hello,

  We are glad to know that your issue has been resolved.

  Thanks,
  
  Reeva