//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; worksheet.Range["B1"].Formula = "=A1"; //config range B1's FormulaHidden property. worksheet.Range["B1"].FormulaHidden = true; //protect worksheet, range B1's formula will not show in exported xlsx file. worksheet.Protection = true; // Save to an excel file workbook.Save("SetRangeFormulaHidden.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) worksheet.Range!B1.Formula = "=A1" 'config range B1's FormulaHidden property. worksheet.Range!B1.FormulaHidden = True 'protect worksheet, range B1's formula will not show in exported xlsx file. worksheet.Protection = True ' save to an excel file workbook.Save("SetRangeFormulaHidden.xlsx")