Problem Note 30580: Long filter in the SAS® Add-in for Microsoft Office might cause an exception after being edited
 |  |  |  |  |
If you create a long filter in the SAS Add-in for Microsoft Office that contains multiple conditions, usually greater than 12, and you modify this filter, you might receive an exception the next time you attempt to edit that filter.
If you attempt to edit the filter via the pulldown SAS → Data Options → Filter, you might recieve an error similar to the following:
Input string was not in a correct format.
If you attempt to edit the filter via the pulldown SAS → Modify, you might receive an exception similar to the following:
System.FormatException: Input string was not in a correct format.
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at SAS.Servers.DatasetFilterTab.Initialize()
at SAS.Servers.DatasetFilterTab.DatasetChanged()
at SAS.Servers.DatasetDetailsBaseTab.set_Dataset(Dataset value)
at SAS.Servers.DatasetDetails..ctor(Dataset dataset, Boolean filterColumns,
VersionManager versionManager, EAvailableTab tabsToShow)
at SAS.OfficeAddin.DataViewItem._UpdateSettings(Boolean showDialog,
EAvailableTab activeTab)
at SAS.OfficeAddin.DataViewItem.UpdateSettings(Boolean showDialog)
at SAS.OfficeAddin.OfficeAddinBase._Refresh(RefreshItem refreshItem,
Boolean bShowDlg)
at SAS.OfficeAddin.ExcelAddin.Refresh(Boolean bShowDlg)
at SAS.OfficeAddin.UIManager.ButtonClickHandler(CommandBarButton sender,
Boolean& bHandled)
Once you receive this exception, you might not be able to get back to your spreadsheet. Please make sure you save your spreadsheet prior to editing your filter to ensure you don't lose your work.
The only circumvention is to make your filter with less than 12 conditions.
Select 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 | Microsoft Windows Server 2003 Standard Edition | 2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows NT Workstation | 2.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Professional | 2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Server | 2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft® Windows® for x64 | 2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Advanced Server | 2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Datacenter Server | 2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Windows Vista | 2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||