XESS 5.0 Spreadsheet Features

The XESS Environment

• Supported on most Linux, UNIX, VMS, and Windows NT systems
• Standard Motif Graphical User Interface
• Main menu bar with pulldown sub-menus, icon toolbar, sheet tabs, and pop-up menus
• Industry-standard spreadsheet orientation
• Mouse or keyboard actions
• Copy to and from Clipboard
• Multiple workbooks can be active simultaneously
• Maximum 4,096 columns, 9,999,999 rows, and 4095 sheets in a workbook
• Cells/ranges referenced by address or name
• Undo previous operation - multi-level undo and redo
• Advanced Help system with internal HTML viewer, help on, search, and context-sensitive help

Input/Output Options

• Spreadsheets stored as encoded text for easy mailing/sharing
• Excel and Lotus spreadsheets directly supported (read and write). Up to Excel 97/2000 and WK4.
• Text import/export with filtering
• PostScript (with color) printing of spreadsheet and graphs
• Text printing
• HTML input and output
• LaTeX output
• Copy and paste between active spreadsheets and with other applications

Formatting the Display

• Full WYSIWYG user interface
• Colors for foreground/background, highlight, titles, etc.
• Background patterns and cell borders
• Cell formats (hex, dollars, scientific, user-defined, etc.)
• Fonts, sizes, and styles
• International character support
• Horizontal cell content alignment -- left, right, center, or center over selection
• Vertical cell content alignment - top, center, bottom
• Cells contents rotated with up/down placement
• Multi-line text with word wrap
• Auto-fit column and row sizes
• Hidden rows and columns
• Simplified date entry
• Cell notes

Data Manipulation

• Copy/move formulas or values to other spreadsheets maintaining formulas and formats
• Transpose rows to columns with move and copy
• Search by textual, numeric, or Boolean expressions
• General Search and Replace tool
• Sort in ascending or descending order on up to 5 keys
• User control of collating options
• Goal-seeking
• Data Extract tool
• Multi-variable multi-constraint Solver tool
• Named Ranges

XESS Calculations

• Unique high-performance calculation engine
• Arithmetic, conditional, Boolean operations
• C language or standard spreadsheet operators
• Double-precision calculation
• Iterative calculations
• Cell linking between worksheets and workbooks
• Dynamic inter-workbook links, even with Excel and Lotus
• Workbook consolidation and external referencing
• Matrix operations
• Formula constraint checking
• Over 350 functions

Mathematical Functions

• Sum, product, absolute value
• Logarithm with base 10, base 2, base e
• Square root, square root of a sum of squares
• Uniform and Gaussian random numbers
• Nth degree polynomial
• Sigmoid function
• Gamma and log gamma functions
• Visual sum
• Interpolations
• Matrix determinant and dot product
• Exponential function
• Trig and Hyperbolic trig functions
• Complex arithmentic and functions

Financial Functions

• Extensive financial functions
• Depreciations
• Present and future values
• Investment, annuity, and security functions
• Treasury bills and various coupons
• Interest rates and internal rates of return
• Yield calculations
• Specialized date calculations

Statistical Functions

• Maximum, minimum, median, mode, sum
• Standard deviation of population or sample
• Variance of a population or sample
• T and F distributions
• Paired and unpaired t tests
• Sum and mean of squares
• Geometric and harmonic means
• Correlations and multiple regressions
• Conditional statistical functions
• Distributions and cumulative distributions

Matrix Functions

• Matrix multiply and inverse
• Eigenvalues
• Fourier transforms and inverses
• Linear equation solving
• Correlation matrices
• Curve fitting

String Functions

• Complete suite of functions for string manipulation and conversions including regular expressions

Other Functions

• Date and time functions
• Indirect cell reference functions
• Table look-ups within sheet and on external sheets
• External alarms and controls
• Logic and digital logic functions
• Plus many more

Graphs and Charts

• Surface, scatter, line, pie, X-Y, high-low, box, candle-stick, contour, polar, histogram, area, bar, stacked-bar, and combination graphs
• Multiple graphs in independent windows or on sheet with data
• Automatic updating when data changes
• Multiple data ranges
• Dynamic graph annotation
• 3D graph rotation
• Graph shading and coloring

Overlay Editor

• Edit and draw objects on spreadsheet
• Annotate charts
• Drawings saved with workbook

Optional xsBasic Macro Facility

• Object-oriented version of BASIC language
• Create dialog boxes, menus, and buttons
• Implement new functions for use within spreadsheet
• Provide procedures for spreadsheet events
• Process data files external to the spreadsheet
• Automate repetitive operations
• Macro editor, recorder, and symbolic debugger

Optional Software Developers Kit (SDK)

• Connections API for external languages
• Network-enabled integration with other applications