Apply formula in listobject cell manually excel shows value

Question

Hi 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.

Nihar Sai · Answer

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.

Pradeep Shet · Answer

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.