Removing cell notes

Posted by: ashis on 8 September 2017, 1:14 pm EST

  • Posted 8 September 2017, 1:14 pm EST

    Hi Bob


    I want to remove the notes applied to some cells.If I am setting the notestyle as hidden still the red symbol is there..


    Please help


    Ashis

  • Replied 8 September 2017, 1:14 pm EST

    But 


    <FONT face="Courier New">fpSpread1.CellNoteIndicatorVisible = true; </FONT>


    <FONT face="Courier New">that will apply to whole spread</FONT>


    <FONT face="Courier New">I want for some cells..</FONT>


    <FONT face="Courier New">Anything else...</FONT>


    <FONT face="Courier New">Ashis</FONT>

  • Replied 8 September 2017, 1:14 pm EST

    Not for individual cells other than removing the note.
  • Replied 8 September 2017, 1:14 pm EST

    Ashis -

    You can do the following if it will work for your purposes...

    FpSpread1.ActiveSheet.Cells(1, 1).NoteIndicatorSize = New Size(0, 0)
  • Replied 8 September 2017, 1:14 pm EST

    Thanks Bob


    I changed the color of the NoteIndicator as White (or matching as Backcolor of the cell), so it's not visible now.


    Ashis

  • Replied 8 September 2017, 1:14 pm EST

    Ashis -

    Yes, either of the two ways mentioned will work.
  • Replied 8 September 2017, 1:14 pm EST

    Try setting the CellNoteIndicatorVisible property to hide the indicator.
Need extra support?

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

Learn More

Forum Channels