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
Forums Home / Spread / Spread for WinForms
Posted by: haianh on 8 September 2017, 6:26 am EST
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
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
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?