I have to implement formula as one column in excel sheet

Sita Mahalakshmi

Hi All

I am working with Excel Addin.I am using Vsto 2013 and excel 2016 version as tools for the development.

I have to implement formula as one column in excel sheet.

Here we want to get the formula from the frontend using c#.

The problem here is that i am unable to get the formula at the particular cell where i gave some formula, rather than it is showing all the cells in the formula format only.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sita Mahalakshmi9y ago
Hi

we have to enter the formula manually for the cell, after entering the formula for the cell and when I select that particular cell, in the formula bar it is showing only the result but not the formula and the consequent formula is getting applied to all the other rows of the column, the other cells are showing the formula, but not for the cell in which the formula is entered.

you can find below image for reference

0
Madhanmohan Devarajan9y ago
While saving the excel workbook from C# VSTO, please check whether you have used the below highlighted atttribute values.

Range rnge = ObjWorkSheet.Range["C1"];
rnge.Formula = "=SUM(C2:C4)";
String formula = rnge.Formula; //retrieve the formula successfully
rnge.FormulaHidden = false;
workSheet.Unprotect();

ObjWorkBook.SaveAs(filePath, AccessMode: XlSaveAsAccessMode.xlShared);

Note: Please mark as accepted answer, if the above answer is useful for you.
0