Problem Note 62035: The cross-reference formula might be displayed as "#NAME?" in an uploaded spreadsheet and the "ERROR...ControllerExceptionHandler..." occurs
 |  |  |  |  |
In SAS® Risk and Finance Workbench, the cross-reference formula might be displayed as #NAME? when you upload a spreadsheet that contains cross-references. When you encounter this issue, errors similar to the following occur:
ERROR com.sas.stress.rest.controller.ControllerExceptionHandler - Generic exception handling for request:
<http: path-name>/SASRiskandFinanceWorkbench/rest/projects/22/upload
org.apache.poi.ss.formula.FormulaParseException: Parse error near char 5 ''' in specified formula 'SUM(#'REF'!)'. Expected unquoted identifier
at org.apache.poi.ss.formula.FormulaParser.expected(FormulaParser.java:219)
at org.apache.poi.ss.formula.FormulaParser.parseUnquotedIdentifier(FormulaParser.java:1349)
<http: path-name>/SASRiskandFinanceWorkbench/rest/projects/22/upload
org.apache.poi.ss.formula.FormulaParseException: Parse error near char 5 ''' in specified formula 'SUM(#'REF'!)'. Expected unquoted identifier
at org.apache.poi.ss.formula.FormulaParser.expected(FormulaParser.java:219)
at org.apache.poi.ss.formula.FormulaParser.parseUnquotedIdentifier(FormulaParser.java:1349)
This issue occurs because, in some cases, the spreadsheet does not handle the cross-sheet references as single-quote delineated, which is the expectation. In such cases, the formula is displayed as #NAME? because the user interface cannot evaluate the formula properly.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Risk and Finance Workbench | Microsoft® Windows® for x64 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 |
| Linux for x64 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
A fix for this issue for SAS Risk and Finance Workbench 3.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C5N.html#62035A fix for this issue for SAS Risk and Finance Workbench 2.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A4G.html#62035
In SAS® Risk and Finance Workbench, the cross-reference formula might be displayed as "#NAME?" when you upload a spreadsheet that contains cross-references.
| Type: | Problem Note |
| Priority: | medium |
| Topic: | Analytics ==> Financial Analysis |
| Date Modified: | 2018-03-29 14:37:16 |
| Date Created: | 2018-03-22 16:47:58 |