Excel formula error

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

T_Bekker

Posts: 8
Joined: Fri Aug 10, 2012 11:55 am

Post by T_Bekker » Fri Mar 15, 2013 3:44 pm
I am trying to convert a data file to Excel, using a template that contains the following formula.

=IF(ISERR(FIND("_W2_",CELL("filename",A1),1)),"Year-To-Date","Year-End") & ", Calendar Year "&TEXT(A5,"0000")

During the Convert to Excel step, the GA job ends with errors (see below). I tried using a simple math formula, and that worked. I then tried this formala:

="As of " & TEXT(DATE(A5,MONTH(NOW()),1),"mmmm dd, yyyy")

GA generated similar errors, regarding the TEXT function. Are formulas not supported when using Excel templates?

03/15/13 1:02:06 PM INFO Executing task 'writeExcel 2.0 (Convert to Excel)'
03/15/13 1:02:25 PM INFO Finished task 'writeExcel 2.0 (Convert to Excel)'
03/15/13 1:02:25 PM ERROR Error evaluating cell HSPPNS1!A2
03/15/13 1:02:25 PM INFO Finished project 'HR - Pension Summary'
03/15/13 1:02:25 PM ERROR [8099 - Convert to Excel] An unexpected error occurred.
Error evaluating cell HSPPNS1!A2
:
Caused by: org.apache.poi.ss.formula.eval.NotImplementedException: Error evaluating cell HSPPNS1!A2
:
Caused by: org.apache.poi.ss.formula.eval.NotImplementedException: CELL
at org.apache.poi.hssf.record.formula.functions.NotImplementedFunction.evaluate(NotImplementedFunction.java:42)
at org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132)
at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:437)
at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:260)
1 post Page 1 of 1