Problem Note 61953: Formula cells might be blank in exported spreadsheets
 |  |  |  |  |
In SAS® Risk and Finance Workbench (formerly known as SAS® Stress Testing Workbench), you might see unexpected missing values for some cells when you export worksheets.
There are no errors or warnings during the export.
This issue occurs under the following conditions:
- The cell contains a cross-reference formula to a worksheet whose name contains a hyphen (-).
- You use the SST_EXPORT_SHEET_DATA macro to export worksheets.
As a workaround, remove the hyphen from the worksheet name or replace it with another character, such as an underscore (_).
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#61953A 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#61953| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2018-03-29 14:32:33 |
| Date Created: | 2018-03-11 16:19:05 |