Posted 10 September 2017, 10:56 am EST
I want to format the negative value in cell. I need to enclose the value in brackets, removing negative sign. I use the code -
gcActiveSheet.Rows[iRCnt].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.CustomMode, "0_);(0)");
But, its formatting some cells and not all. As per my observation, the direct values are not getting formatted & only the values with formula are getting affected with the code.