I'm not a programmer but I've been using spreadsheets for a long time, including Lotus, which went through a number of changes. I hope that reading this does not take too long, if my suggestion has no merit.
Rather than loading the program with various alternative formula expressions, formula conversion or translator utilities could be considered. In support of that suggestion I offer the following: 1. Autocorrect and similar functions already exist. How about a function that recognises obsolete formula expressions and offers the new expressions in their place? 2. File conversion already exists. When I converted my main Lotus spreadsheet to MS Excel (using "Save As" in Lotus) so that I could open it in OpenOffice, a lot of formulas were translated into language I had never used or even encountered. Some formulas were not translated. They stood out, of course, because they were converted to text. 3. I know a specific translator is possible because when Lotus changed a lot of their old macro programming language (way before LotusScript was adopted, I'm talking about macro commands written into the spreadsheet itself), the new program version came with a macro translator. It translated, at the user's request, macro commands in the spreadsheet into commands using the new expressions. A log could be provided showing the location of formulas which could not be translated. Hope this may be worthwhile even though it's from a "layman". Send instant messages to your online friends http://au.messenger.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
