Hidden content in cell

Hidden content in cell

Posted by: haianh on 8 September 2017, 6:26 am EST

• 

  haianh

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 September 2017, 6:26 am EST

  Hi
  
  I want to hide content same link :http://chandoo.org/wp/2009/06/05/hide-cell/
  
  Can The spread 10.0 J winform support this function? Show me example please.

  Thanks

• 

  deepaksharma14

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 6:26 am EST

  Hello,

  You can set the forecolor of cell’s text to Transparent to hide the cell content. For example:

  [vb]FpSpread1.ActiveSheet.Cells(1,1).Text=“Hidden Value”
  
  FpSpread1.ActiveSheet.Cells(1,1).ForeColor = Color.Transparent[/vb]

  Thanks,
  
  Deepak Sharma

• 

  patrik

  • Post Options:
  • Link
    Copy

  Posted 14 February 2018, 6:26 pm EST

  Hi

  This is working perfect if the cell is not negative and have color red.(I have the cell as number cell that show red when number are negative)

  is there someway to hide this red cell?