SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 15003: Clicking Range Selector button in Add-in for Microsoft Office causes exception message

DetailsHotfixAboutRate It
When you use the Add-in for Microsoft Office, if you filter local SAS
data by using the filter tool and the resulting data exceeds the
LocalProvider's buffer, you will first see that the result records will
show -1 in the preview screen. If you then select OK to apply the filter
and click the range selector tool (1-5000) to see how many records there
are, an exception message appears:

   '1' is not a valid value for 'Value'.
   Value should be between 'Minimum' and Maximum'.
   at System.Windows.Forms.NumericUpDown.set_Value(Decimal value)
   at SAS.OfficeAddin.DataSeekForm..ctor in
   c:\dotnet\OfficeAddin\Source\addIn\DataSeekForm.cs line 36
   at SAS.OfficeAddin.ExcelAddin.ChangeVisibleSasData in ExcelAddin.cs
line
   4499

A fix for this issue is available at:

   http://www.sas.com/techsup/download/hotfix/amo131.html#015003


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Add-in for Microsoft OfficeMicrosoft Windows XP Professional1.31.3.1
Microsoft Windows Server 2003 Datacenter Edition1.31.3.1
Microsoft Windows Server 2003 Standard Edition1.31.3.1
Microsoft Windows Server 2003 Enterprise Edition1.31.3.1
Microsoft Windows 2000 Server1.31.3.1
Microsoft Windows 2000 Advanced Server1.31.3.1
Microsoft Windows 2000 Datacenter Server1.31.3.1
Microsoft Windows 2000 Professional1.31.3.1
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.