How Transition Formula Entry Affects Behavior in MS Excel
Retired KB Content Disclaimer
The Transition Formula Entry option allows you to open Lotus 1-2-3files without losing or changing information. Note that whenever aLotus 1-2-3 file is opened in Microsoft Excel, these options areautomatically turned on.
When Transition Formula Entry is selected, Microsoft Excel convertsformulas entered with Lotus 1-2-3 release 2.2 syntax to MicrosoftExcel syntax and makes names defined in Microsoft Excel behave asdefined names behave in Lotus 1-2-3.
In addition, if the Transition Formula Evaluation check box isselected, when Microsoft Excel evaluates formulas, text strings areconverted to 0, Boolean expressions are converted to 0 or 1, anddatabase criteria are converted according to the rules used in Lotus1-2-3.
ID d'article : 141764 - Dernière mise à jour : 08/17/2005 18:18:57 - Révision : 1.3
- kbinfo kbualink97 KB141764