SheetName Property

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

  • Posted 8 September 2017, 2:20 pm EST


    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.

    Koustubh More.

  • Replied 8 September 2017, 2:20 pm EST


    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.


    FpSpread1.Sheets(0).SheetName = " "

    FpSpread1.Sheets(0).SheetName = ""    ' this is not allowed.




Need extra support?

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

Learn More

Forum Channels