QFWorks 1.1.2 Release Notes 4/2/2001 Copyright 1996-2001, PelicanWare, Inc. All Rights Reserved. Please note that this release is an upgrade version. A prior version of QF Works must have been installed and run or this version will not install. The "QFNewtWorks:donv" icon will need to be deleted from the extensions folder in the extras drawer before installing this upgrade. Compatibility Warning ===================== QuickFigure Works 1.1.2 shares a data format with QF Works 1.1.1 which is slightly different from that used by prior versions. If you install QuickFigure Works 1.1.2, it will be able to read worksheets created by version 1.0.x. However, QuickFigure Works 1.0.x will not be able to read worksheets created or modified by QuickFigure Works 1.1.2. Note that this also applies to worksheets which are beamed from a Newton running QuickFigure Works 1.1.1 to Newtons running prior versions. Changes from QF Works 1.1.1 ========================== Bug Fixes --------- 1. Fixed Y2K bug where dates in format mm/dd/yy were interpreted incorrectly. 2. Buttons now resize properly in formula list editor after undo. 3. Fixed a bug with selections beyond column Z (selecting from lower left to upper right or vice versa). 4. Selections are no longer lost when scrolling so that the selection is off screen. 5. Pressing the "Home" button in the Jump To Cell slip with label locking on now works. Changes from QF Works 1.0.1 =========================== New features ------------ Cell Borders. Hide Gridlines. Scrollbar feedback slip. Resizeable input line. "Set Column Width" now operates on multiple columns. Tapping on a cell when the caret is in the input slip (and you are not editing a formula) enters the data in the input line and switches the focus. Print Selected Cells. Many performance optimizations. Mixed text and numbers can now be entered without using a leading apostrophe. For instance, you can now enter "1997 earnings" in a cell, rather than having to enter "'1997 earnings". When entering data in percentage format (i.e. "45%"), the number of decimal places to display is now automatically detected from the value entered, rather than always being set to 2. Bug Fixes --------- Updated pi constant to be 3.14159265358979. Decimal numbers in formulas no longer need to be preceded with a "0" (for example, "=.65*D5" is now valid). Selection slip can now be used to select cells from bottom to top and right to left. Label locking now stays enabled after closing/reopening worksheet. Selecting from lower-left to top-right and top-right to lower-left now works. Protection state is now saved when QF is closed. Number and Date formatting are no longer heap-dependent (you can now format large areas of the worksheet). Keep in mind that if you do format large areas of the worksheet, you will end up using significantly more storage space than you would by only formatting the cells you actually use. MaxRange() function now works properly when the largest number in a range is negative. Var() function now ignores empty cells, rather than treating them as "0". Changes from QF Works 1.0 ========================= Increased bottom margin on printed pages. Find before/on/after dates now works properly. Scrubbing label cells while label locking is enabled is now prevented. Negative numbers in 0,000 format are now displayed correctly. Improved recalculation performance with new recalc algorithm. Added new VLookupR and HLookupR functions which support inexact matches. For example: =VLookupR(3.5,A9:E11,2,true) =HLookupR(2,A1:B9,2,false) The VLookupR and HLookupR functions work exactly as in Excel. The old VLookup and HLookup functions are still usable, as always. Added eAnd and eOr ("Excel And" and "Excel Or" functions) to complement the eIf ("Excel If") function. For example: :eAnd(A1<2,A3>6) :eOr(A1=5,A3>10) :eIf(:eAnd(A1<3,A2>8),3,5) Added optimization to improve scrolling speed in large worksheets. Added RND function ("round") to allow rounding to a specific number of digits. For example: =RND(4.5555666,2) Known Bugs and Discrepancies ============================ 1. When multiplying large integers within a formula, Works will return the wrong result if the answer is greater than 536,870,912, due to an overflow situation. This will not happen to real numbers, so if a work around is needed, add a decimal point and zero to the number you are multiplying to make it a real number. Values in cells are always treated as real numbers, so this is only an issue in a formula. For instance, the following formula: =123456789*10 would result in an incorrect result. However, =123456789.0*10 would give the proper result. If the value 123456789 were entered into cell C2 and then =C2*10 were entered into another cell, the value would be correct (since values in cells are always treated as real numbers). Feedback and Comments ===================== Please send feedback and comments to: Internet: support@pelicanware.com US Mail: PelicanWare, Inc. 610 SW Broadway Suite 606 Portland, OR 97204