Accessing via code to Name of the Sheet not the SheetName Propertie

Posted by: jars on 8 September 2017, 2:18 pm EST

  • Posted 8 September 2017, 2:18 pm EST

    <p>Hi,</p><p>In the propertie SheetName I get the name of the sheet that the user see, but I want to access via code to the propertie "NAME"  in the Category "DESIGN".</p><p> </p><p>Thanks. <br></p>
  • Replied 8 September 2017, 2:18 pm EST

    <p>Hello,</p><p>Using should be able to get SheetName using code also by accessing the same "SheetName" property.</p><p>dim sheetname as new String <br></p><p>sheetname= fpspread1.Sheets(0).SheetName</p><p>msgbox(sheetname)</p><p>I hope it will help you.</p><p>Thanks, <br></p>
  • Replied 8 September 2017, 2:18 pm EST

    <p>Hi,</p><p> Thanks but I don't want the SheetName but Name, if you select one of the sheet added, <span id="result_box" class="short_text"><span>you look under the category "Design"you can see the NAME property, </span></span><span id="result_box" class="medium_text"><span>which
    is different from the property SHEETNAME under Appereance category.</span></span></p><p> </p><p>Thanks. <br></p>
  • Replied 8 September 2017, 2:18 pm EST

    <p>Hello,</p><p>"fpspread1_Sheet1" is the name of spread's sheetview collection object.I don't find a way to access the name through code.If you want to change the name of this object you may assign it to any other sheetview object. </p><p>e.g.</p><p>        Dim Fp_Sheet1 As FarPoint.Win.Spread.SheetView<br>        Fp_Sheet1 = FpSpread1_Sheet1<br>        Fp_Sheet1.Columns.Count = 14</p><p><br>Thanks,</p><p> </p><p> </p>
  • Replied 8 September 2017, 2:18 pm EST

    <P>Jars,</P>
    <P>The "(Name)", "GenerateMember", and "Modifiers" properties under the "Design" category in the property grid are not real properties that can be accessed at run time.  These are psuedo properties added to the property grid by the design time environment.  These psuedo properties are used at design time to tell the design time environment how to generate code (ex. Windows From Designer generated code in the Form1.Designer.cs file).</P>
  • Replied 8 September 2017, 2:18 pm EST

    <p>Hi,</p><p> Now I understand, <span id="result_box" class="short_text"><span>I appreciate your answers. The topic can be closed. <img src="/emoticons/emotion-2.gif" alt="Big Smile" /><br></span></span></p><p> </p><p>Thanks.<br></p>
Need extra support?

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

Learn More

Forum Channels