• Print |
• E-mail  |
• Bookmark

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

A fix for this issue for Add-In for Microsoft Office 2.1 is available at: