Page 1 of 1

Handling Excel Formulas

Posted: Mon Apr 17, 2017 8:23 am
by howard02
I have a GO Anywhere MFT Project that produces an Excel spreadsheet. Several of the columns contain dates/times of events. Included in the spreadsheet are additional columns containing formulas written to calculate the differences between various dates/times contained in the other columns.

However, when the resulting spreadsheet is opened, the columns containing the formulas show only the text formulas; the desired calculated values are not displayed. I have to edit the first formula of each column and accept the edit; after that the calculated value shows. Then I double-click the lower-right corner of the cell, which forces the calculations for the remainder of the column. Once the values show, I have to change the column format to hh:mm.

I want to change my project to:
  • Force the formulas to calculate when the spreadsheet is composed
    Format the time difference columns to hh:mm
In other words, I want the Excel spreadsheet produced by Go Anywhere MFT to be a finished product not requiring any modification by its recipients. Is this possible?

Re: Handling Excel Formulas

Posted: Mon Apr 17, 2017 1:40 pm
by Support_Dan
Howard02,

Are you using a Template to produce this excel file? Can you please attach your project XML file so that we can see exactly what you are trying to do so that we are clear. Thanks.