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.
If you need a quicker response, please create a support ticket via the customer portal my.goanywhere.com or contact our support team by email at [email protected].
If you need a quicker response, please create a support ticket via the customer portal my.goanywhere.com or contact our support team by email at [email protected].
2 posts
Page 1 of 1
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:
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
- Posts: 9
- Joined: Fri Dec 02, 2016 1:39 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.
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