Mesa

Mesa 2's Real-Time Feed Capabilities, an Example with Stock Quotes. This example uses a Mesa 2 spreadsheet with two short MScripts and an external REXX script. They work in combination with stock quotes from a free Internet service, in this case Yahoo.

Mesa 2 version 2.3 fixes a few problems and incompatibilities that were found in version 2.2. In addition, several new features were added based on customer requests. These include: * File locking - Mesa 2 now (optionally) will lock files while they are open so other users can not modify the file until you are done with it. * Excel 5.0/95 export filter - Mesa 2 can now export files to Excel 5.0/95 workbooks. * Quattro Pro WB2 import filter - Mesa 2 can now import Quattro Pro WB2 files as well as WB1 files. * Several new formula functions: -IPAYMT/@IPAYMT -IPMT/@IPMT -MAPPEND/@MAPPEND -MATCH/@MATCH -PPAYMT/@PPAYMT -PPMT/@PPMT -SETELEMENT/@SETELEMENT -SUBSTITUTE/@SUBSTITUTE * Several new AddIn functions (see forthcoming AddIn kit) * Enhanced date parsing - Mesa 2 will now try to recognize dates entered in "foreign" formats. For example: 1999/03/17 will now be recognized as a date instead of a string. * EDITCELL MScript function - will force the user to enter data into a cell while the script waits. * LISTWINDOWS MScript function - lists all currently open windows. * Push/Pop selection commands - can be added to menus, toolbars, and keyboard shortcuts. "Push" pushes the current selection onto an internal stack (local to the workbook). You can then go back to that selection by hitting the "Pop" command. * Completely new Real-Time Data Feed system offering new capabilities. -Enhanced FEED formula function to access historical feed data. -New SETFEED formula function for setting values in the feed table from results of calculations in a workbook. -New FEEDTIME formula function for retrieving the time a feed was last updated. -GETMISSINGFEEDS MScript function to get a list of all feeds requested via a FEED call that were not found in the feed table. -GETALLFEEDS MScript function to get a list of all feed values in the feed table. -DELETEFEED MScript function for deleting feeds from the feed table. -GETFEEDTIME MScript function for retrieving the time a feed was last updated. -GETFEEDATTIME MScript function for retrieving an historical value of a feed. -The ability to turn off the Real-Time Data Feed for a particular workbook. * External Control of Mesa 2 - all MScript functions can now be used directly from an external program by prefixing the command with either mesa2 or m2. * GBM support - if the GBM libraries are installed on your computer, Mesa 2 will now use them for importing and exporting images. This allows Mesa 2 to import and export many new image formats including GIF, JPEG, and TIFF. The GBM libraries are available from many OS/2 FTP sites. * Alternate SmartFreeze behavior - matches the behavior of other spreadsheets title locking, but looses some of the enhanced functionality of the Mesa 2 version 2.2 SmartFreeze feature. There are also several important performance improvements designed to make Mesa 2 faster: * Selection Manager - enhanced to reduce the "pulsing" when the selection changes, typing a script, etc... * Recalc range command - smarter processing of nonautomatic recalculation if the recalc order is set to Row or Column. * Cached graph images - when graph caching is turned on (the default) and a recalc/feed/animation/etc... causes the graphs to need to be updated, only the graphs currently visible will be redrawn. * Real-time data feed recalculation - more efficient transfer of data from the feed table to the workbook when multiple FEED() calls are encountered during a recalculation. * Script recorder - several speedups were implemented so that there are fewer performance penalties as the script increases to near the limit in size.

Script to export simple LaTeX table from Mesa 2 spreadsheet. Written for Mesa 2 revision 2.20. Before you run this script you need to select the range of cells you want to export.

This program is designed to remove unneeded information from Mesa files to decrease the size of the file. Smaller files tend to load faster and also tend to use less memory once loaded so there are many reasons to try and get the files smaller. Also, if you have to transfer a file via a slow modem, smaller files are always better.

While there are very few major feature additions in this release, there have been many substantial improvements. These are listed by catagory: * Feature Enhancements * REXX Enhancements * File Filter Enhancements * Function Changes * Sundial Systems