SheetName Property

Posted by: koustubh on 8 September 2017, 2:20 pm EST

  • Posted 8 September 2017, 2:20 pm EST

    <P>Hello, </P>
    <P>In new release spread sheet(5.0.2005.2008)  SheetName Property has changed it is not taking SheetName as blank or null unlike to previous version. In previous version it is allowing it. I am upgarding my project from old version to new version, Because of this property it is giving me run time error. for this I have updated my code. My Project is huge so can you please give me list of properties which not supports in the new release spread so I can upgrade my Project code to avoide more run time errors.</P>
    <P>Koustubh More.</P>
  • Replied 8 September 2017, 2:20 pm EST

    <p>Hello,</p><p>I don't think if it was ever allowed to set a sheetname to null.I have tested with Spread v5,v4and v3.If you don't want a name to be shown in sheet tab you may set it to a blank space but not null.</p><p>e.g. </p><p>FpSpread1.Sheets(0).SheetName = " " <br></p><p>FpSpread1.Sheets(0).SheetName = ""    ' this is not allowed.</p><p> </p><p>Thanks,</p><p>  <br></p>
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels