SheetName Property

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

  • Posted 8 September 2017, 2:20 pm EST

    Hello,


    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

    Hello,

    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.

    e.g. 

    FpSpread1.Sheets(0).SheetName = " "

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

     

    Thanks,

     

Need extra support?

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

Learn More

Forum Channels