yuhuihu / excellibrary

Automatically exported from code.google.com/p/excellibrary
0 stars 0 forks source link

Creating a spread sheet formula column #82

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
I have been using ExcelLibrary for both creating a spread sheet from a DataSet 
and creating a DataSet from a spread sheet.  Thanks you for making this dll 
available.

I have a requirement now to have a formula in the spread sheet that I create 
from a DataSet.  I have tried putting in a DataTable column

 ‘=(D1+D2)’ and ‘=SUM(D1+D2)’.

These are not recognised in the spread sheet initially as a formula.  If you 
edit each formula cell it then recognises the cell as a formula.

Is there a way when turning a DataSet into a spread sheet to create a formula 
column?

Regards
Stephen

Original issue reported on code.google.com by sbedf...@bigpond.net.au on 9 Mar 2011 at 5:17

GoogleCodeExporter commented 9 years ago
Were you able to resolve this issue?

Original comment by chan...@guestswanted.com on 18 Apr 2011 at 9:46

GoogleCodeExporter commented 9 years ago
Any updates on how to accomplish this?

Original comment by ianp...@gmail.com on 27 Mar 2012 at 6:57

GoogleCodeExporter commented 9 years ago
formulars display as text in exported sheet. need to do replace '=' with '=' to 
activate the cells as formular.

Original comment by dhji...@gmail.com on 7 Sep 2012 at 8:04