Release Notes
 
Quantrix 1.2

31 March 1995

Introduction

Welcome to the Release Notes for Quantrix version 1.2, Lighthouse Design's multi-dimensional spreadsheet program for NEXTSTEP/OpenStep. 

NOTE: 
PLEASE MAKE SURE TO QUIT THIS EDIT APPLICATION 
BEFORE ATTEMPTING TO INSTALL QUANTRIX

Quantrix v1.2 is an upgrade to version 1.0, and contains a variety of new features and enhancements. These release notes provide only a quick summary of new functionalityPin order to fully understand these and other core concepts behind Quantrix and multi-dimensional spreadsheets, please refer to the the on-line help in the application, or the end-user documentation that came with your purchase.

New Features!

Several new features have been added to version 1.2. 

7 Copy as Graphic
Converts selections in a Quantrix view into EPS graphics. Allows users to copy data from Quantrix, along with formatted item and group names, and paste it as a graphic into other applications (such as Concurrence, or NeXTMail).

7 Sorting
Sorts selected items. Allows users to quickly and easily sort collections of items based upon one or more sort keys selected by mouse clicks. Also supports sorting of items by name.

7 Hiding Items
Hides selected items from view. Allows users to hide one or more row or column items in a view. Resize items to zero height or width to hide, and double-click hidden items to show. 

7 Groupsum(), Groupavg(), etc.
Provides fast and convenient sub-totals and interim calculations. Enhances current summary functions,  allowing users to define sub-total or interim calculations ignored by grand total calculations.

7 Mark Formula/Cells
Graphically associates cells with formulas, and formulas with cells. Allows users to simply click a cell to highlight the formula responsible for determining its value. Similarly, allows users to click a formula to highlight the cells which it calculates.  A preference has been added to enable and disable this behavior by default.

7 dwrite Advertise NO
Allows users or developers to disable the Lighthouse 'Splash' panel in custom applications. Using the dwrite command, allows users to disable the display of the Lighthouse Design splash panel. Simply type, at a command-line:

	myhost> dwrite Quantrix Advertise NO 

...to disable the display.

Additional Functions

The following functions have also been added to the 1.2 release:

D360 
The D360 function computes the difference between two dates, assuming 30 day months.

Arguments 1 d360(startDate, endDate)
startDate 1 any value from 1 (Dec 31, 1899) to 73050 (Dec 31, 2099)
endDate 1 any value from 1 (Dec 31, 1899) to 73050 (Dec 31, 2099)

Examples
d360(1,366) gives 360

GroupAvg 
GroupAvg(anything) is equivalent to avg(summary(anything)).

GroupCount 
GroupCount(anything) is equivalent to count(summary(anything)).

GroupMax 
GroupMax(anything) is equivalent to max(summary(anything)).

GroupMin 
GroupMin(anything) is equivalent to min(summary(anything)).

GroupStd 
GroupStd(anything) is equivalent to std(summary(anything)).

GroupStds 
GroupStds(anything) is equivalent to stds(summary(anything)).

GroupSum 
GroupSum(anything) is equivalent to sum(summary(anything)).

GroupVar
GroupVar(anything) is equivalent to var(summary(anything)).

GroupVars
GroupVars(anything) is equivalent to vars(summary(anything)).

One Final Note

We're constantly collecting new ideas for future releases, and we hope you'll take a moment to send us your comments and feedback. If you have access to electronic mail, just click Suggestion from the Info menu item, and fill out the suggestion form using NeXT Mail. You can also fax your suggestions, or print them to hard copy and mail them to us. We're looking forward to hearing from you.

Good luck!

Lighthouse Design, Ltd.