DDSheets.Item[string] returns null in v11

DDSheets.Item[string] returns null in v11

Posted by: snellcb on 7 January 2018, 12:37 pm EST

• 

  snellcb

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 7 January 2018, 12:37 pm EST

  Using ActiveReports.v11, Version=11.2.10750.0, attempts to retrieve a worksheet from a workbook’s DDSheets collection in SpreadBuilder base on sheet name returns null. This worked in v10.1 and prior at least as far back as v6.

  In a case where there is only one sheet in the DDSheets collection, this line of code will return the sheet:

  DDSheet sheet = workbook.Sheets[0];
  

  This line will not, and instead returns null:

  DDSheet sheet = workbook.Sheets[name];
  

  This line (as a quick way to confirm the correct name is being used) will also return null:

  DDSheet worksheet = workbook.Sheets[workbook.Sheets[0].Name]
  

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 8 January 2018, 1:15 am EST

  Hello,

  I am able to replicate the problem at our end. I have escalated this to the development team(tracking id 252458) and will revert you back once have any information from them.

  Thanks
  
  Mohit

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 9 January 2018, 2:44 am EST

  Hello,

  Could you please confirm in which version(11 or 12) you want the fix of this issue?

  Thanks,
  
  Mohit

• 

  snellcb

  • Post Options:
  • Link
    Copy

  Posted 9 January 2018, 4:01 pm EST

  Thanks for the update. We’re using ActiveReports.v11, Version=11.2.10750.0 per my original post.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 10 January 2018, 12:05 am EST

  Thanks for the information

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 11 January 2018, 4:39 am EST

  Hello,

  I am glad to tell you that your issue has been resolved. You could download the hotfix from the following link:
  
  http://cdn.grapecity.com/ActiveReports/ar11/hotfixes/ActiveReports-v11.2.12190.0.msi

  If issue still exists, please feel free to revert back.

  Thanks,
  
  Mohit