Apply formula in listobject cell manually excel shows value

Nihar Sai

I have a requirement that "A table should be displayed in excel with the data downloaded from database with 12 columns".

These 12 columns will have the data.

when a user gives the formula manually (i.e., in excel UI) in any of the cells that is covered by list-object, the formula is getting calculated and the value is displayed.

when i select that particular cell for checking what formula is applied, the cell is showing only the value in the formula bar but not the applied formula.

I am using the list-object to bind the data to excel.

Please help me with this Issue.

3 Replies

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

Manikam Manikam7y ago
Hello

Did you resolve this issue?

I have the same problem

Any solution?
0
Nihar Sai9y ago
Hi Pradeep

Thanks for the reply.

the excel worksheet is created dynamically to which I am binding the data.

Description:
I am getting the data from the database and binding the data to the excel using the listobject.

once the data is displayed in the excel sheet.

I have to enter the formula manually as ex: =K15+k16, in any of the cell that is covered by listobject.

The formula is getting applied and the calculated value is also getting displayed, but when I select the same cell where i have given the formula to see the formula applied, at that time I am unable to see the formula in the formula bar, instead it is showing only the calculated value.

I have to see the formula applied.
0
Pradeep Shet9y ago
HI Nihar,

Is that excel created dynamically from c# . Converting List to excel will not add formulaes directly. Plz ellaborate more to understand exactly your problem.
0