Nihar Sai

Nihar Sai

  • NA
  • 41
  • 1.1k

Apply formula in listobject cell manually excel shows value

Apr 11 2017 3:37 AM
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.

 
 

Attachment: New_folder.zip

Answers (3)