Microsoft KB Archive/135004

= XL7: Quattro Pro Array Constant Formulas Not Converted =

PSS ID Number: 135004

Article Last Modified on 10/22/2000

-

The information in this article applies to:


 * Microsoft Excel for Windows 95 7.0

-



This article was previously published under Q135004





SYMPTOMS
When you open a Quattro Pro for Windows document in Microsoft Excel, and you use the Quattro Pro for Windows file filter, if you have formulas with array constants in them, these formulas will not be imported and the value of the formula will be displayed in the cell. You do not receive an alert message or cell note indicating that the formula was not imported.



CAUSE
Quattro Pro for Windows can use formulas with arrays built in, such as the following:

@SUM({1,2,3})

This formula sums the values 1, 2, and 3 with a result of 6. The Quattro Pro for Windows file filter is not designed to recognize these formulas.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords: KB135004

Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2004 Microsoft Corporation. All rights reserved.