KnowledgeBase Archive

An Archive of Early Microsoft KnowledgeBase Articles

View on GitHub

Q98324: BUG: Excel GP Faults When Passing Intersection

Article: Q98324
Product(s): Miscellaneous Software Development Kits
Version(s): 
Operating System(s): 
Keyword(s): 
Last Modified: 12-NOV-1999

-------------------------------------------------------------------------------
The information in this article applies to:

- Microsoft Excel Software Development Kit 
-------------------------------------------------------------------------------

SYMPTOMS
========

Microsoft Excel causes a general protection (GP) fault when attempting to pass
an intersection to a DLL/XLL function registered as data type "R". For example,
consider the following dynamic-link library (DLL) function declaration:

     void __export CALLBACK Test (LPXLOPER lpxl)

Excel causes a GP fault if Test is called with an intersection under the
following circumstances:

- The references joined by the union operator intersect

- The references are passed using defined names

The following call to Test will crash Excel if range1 and range2 intersect:

     =Test(range1 range2)

CAUSE
=====

This is caused by a problem in Excel.

RESOLUTION
==========

There are two possible workarounds for this problem:

- If intersections may be passed to a DLL function, avoid the use of data type
  "R" (XLOPER) if possible. Use data type "P" (OPER) instead and the
  intersection will be passed as an array.

- Implement a "wrapper" macro function. For information on this method, query
  on the following words in the Microsoft Knowledge Base:

  prod(xlsdk) and nonadjacent

STATUS
======

Microsoft has confirmed this to be a problem in Excel version 4.0. We are
researching this problem and will post new information here as soon as it
becomes available.


Additional query words: 4.00 3.10 gp-fault gpf buglist4.00

======================================================================
Keywords          :  
Technology        : kbExcelSearch kbAudDeveloper kbSDKExcelSearch kbSDKSearch
Version           : :

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.