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:
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