Problem Note 41216: Cell formatting is removed after refreshing when output parameters are specified in the SAS® Add-In for Microsoft Office
 |  |  |  |  |
When running the SAS Add-In for Microsoft Office with Microsoft Excel, formatting is not retained when using the new stored process feature Output Parameters.
When you first run the stored process and pick a cell location for the output parameter result, any cell formatting (such as color and currency) is maintained. However, if you subsequently choose to refresh the stored process, all cell formatting is removed.
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 Add-in for Microsoft Office | Windows Vista for x64 | 4.3 | 4.305 | 9.2 TS2M2 | 9.2 TS2M2 |
| Windows Vista | 4.3 | 4.305 | 9.2 TS2M2 | 9.2 TS2M2 | ||
| Windows 7 Ultimate x64 | 4.3 | 4.305 | 9.2 TS2M2 | 9.2 TS2M2 | ||
| Windows 7 Ultimate 32 bit | 4.3 | 4.305 | 9.2 TS2M2 | 9.2 TS2M2 | ||
| Windows 7 Professional x64 | 4.3 | 4.305 | 9.2 TS2M2 | 9.2 TS2M2 | ||
| Windows 7 Professional 32 bit | 4.3 | 4.305 | 9.2 TS2M2 | 9.2 TS2M2 | ||
| Windows 7 Home Premium x64 | 4.3 | 4.305 | 9.2 TS2M2 | 9.2 TS2M2 | ||
| Windows 7 Home Premium 32 bit | 4.3 | 4.305 | 9.2 TS2M2 | 9.2 TS2M2 | ||
| Windows 7 Enterprise x64 | 4.3 | 4.305 | 9.2 TS2M2 | 9.2 TS2M2 | ||
| Windows 7 Enterprise 32 bit | 4.3 | 4.305 | 9.2 TS2M2 | 9.2 TS2M2 | ||
| Microsoft Windows XP Professional | 4.3 | 4.305 | 9.2 TS2M2 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2008 for x64 | 4.3 | 4.305 | 9.2 TS2M2 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2008 | 4.3 | 4.305 | 9.2 TS2M2 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 for x64 | 4.3 | 4.305 | 9.2 TS2M2 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.3 | 4.305 | 9.2 TS2M2 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 4.305 | 9.2 TS2M2 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 4.305 | 9.2 TS2M2 | 9.2 TS2M2 | ||
| Microsoft® Windows® for x64 | 4.3 | 4.305 | 9.2 TS2M2 | 9.2 TS2M2 | ||
A fix for this issue for SAS Add-in for Microsoft Office 4.305 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/C46.html#41216A fix for this issue for SAS Add-in for Microsoft Office 4.3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D19.html#41216| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2010-10-27 09:47:06 |
| Date Created: | 2010-10-12 14:29:21 |