Handling Excel Formulas

If you have a new question you’d like our support staff to post a response to, please visit our customer community, Data Security Insiders, to pose the question in our Discussion Boards. We have a thread “Ask Our Tech Experts” that our support team monitors on a regular basis, or you can start a new discussion where other GoAnywhere users and support staff can weigh in. Log in or create your new account at https://insiders.helpsystems.com/sign_in.

If you need an immediate response, please create a support ticket or contact our support team by email at [email protected].
2 posts Page 1 of 1


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?


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

Post by Support_Dan » Mon Apr 17, 2017 1:40 pm

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