Problem Note 63294: The user interface (UI) does not support the specified worksheet column formats
 |  |  |  |  |
In SAS® Risk and Finance Workbench, the UI does not support the formats specified for the columns.
There are no errors or warnings.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After you apply the hot fix, the LI_KEYS for the columns and rows drive the formats shown in the UI.
- The default format is NUMERIC with scale=1 and precision=2.
- If the LI_KEY row has a default format and the LI_KEY column has a default format, it does not matter if the row or column takes precedence.
- If the column is NOT DEFAULT and the row is DEFAULT, the column takes precedence.
- If the row is NOT DEFAULT and the column is DEFAULT, the row takes precedence.
- If the row and column are both NOT DEFAULT, the column takes precedence.
The UI and the download of worksheets both comply with this strategy.
Note: The sheet log formatting is no longer available after you apply the fix.
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 | 3.1 | 9.4 TS1M5 | ||
| Linux for x64 | 3.1 | 9.4 TS1M5 | ||||
A fix for this issue for SAS Risk and Finance Workbench 3.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D4L.html#63294A 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#63294
In SAS® Risk and Finance Workbench, the UI does not support the formats specified for the columns.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Analytics ==> Financial Analysis |
| Date Modified: | 2018-12-10 11:36:43 |
| Date Created: | 2018-11-28 16:00:15 |