Hide Cell

Hide Cell

Posted by: patrik on 14 February 2018, 10:54 pm EST

• 

  patrik

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 February 2018, 10:54 pm EST

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

  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?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 15 February 2018, 8:23 pm EST

  Hello,

  In order to achieve the requirement, you need to set the “NegativeRed” property of NumberCellType cell to false. Please refer the following code:

  
    	    NumberCellType numCell = new NumberCellType();
              numCell.NegativeRed = false;
              fpSpread1_Sheet1.Cells[1, 1].CellType = numCell;
              fpSpread1_Sheet1.Cells[1, 1].ForeColor = Color.Transparent;
  
  

  Hope it helps.

  Thanks,
  
  Mohit

• 

  patrik

  • Post Options:
  • Link
    Copy

  Posted 16 February 2018, 8:04 am EST

  Thanks, this help