Can we set smart marker and formula in one cell? Let me give you an example. I’m getting all the rows from the database which has the “Price” column. I’m also getting “Total” of the price column from the database. So I have two data tables in one dataset. One has all the rows and other has Total. I have setup the smart markers in the excel template and use Workbookdesigner to process the data source. Everything works fine till here. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Now I open the generated excel file and change the value of one the price row. The total will not change because there is NO formula setup in Total cell.
So how can I setup the formula and the Smart Marker in the same cell?