Handling Excel Formulas

Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
2 posts Page 1 of 1

howard02

Posts: 1
Joined: Thu Apr 13, 2017 11:01 am

Post by howard02 » Mon Apr 17, 2017 8:23 am
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?

Support_Dan

Posts: 9
Joined: Fri Dec 02, 2016 1:39 pm

Post by Support_Dan » Mon Apr 17, 2017 1:40 pm
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.
2 posts Page 1 of 1