Short: Spreadsheet, V2.2e,OS 3.0+, needs FPU Author: tpassow@physik.uni-bremen.de (Thorsten Passow) Uploader: tpassow@physik.uni-bremen.de (Thorsten Passow) Type: biz/misc ------------------------------------------------------ | This is the archive which contains the version for | | 68020 CPU and 68881 FPU or higher | | (a version for 68000 CPU is available) | ------------------------------------------------------ A short manual in english is now in the archive! StarAm Plan is an easy to use but powerful spreadsheet program. It is shareware, not crippled. Some features are: - several sheets at one time in memory with different windows open - commands to edit,e.g.: fill range, create series, change range by +-*/, sort range, change row/column, powerfull cut/copy/paste, undo, search&replace, drag&rop - 121 stastistic, financial, mathem., date, time, boolean, text, format and other functions to use in cells. - user-defined functions, variables and cell-/rangenames - A lot of formatsettings for cells, e.g.: alignment, suffix, prefix, cell-type (text,number,date,time,percent,...), date/time-format, protection, textstyle, borders, textcolor, decimals, sign, hide zero - format-pattern and autoformat - A lot of charts with a lot of settings, e.g.: 3d-bar, 3d-line, 3d-area, errorbars, regression curves, logarithmic axis, polarcoordinates, functionplotter, several charts in one system of coordinates - in texts of worksheets and charts you can now use simple mathematical expressions ("Formelsatz"): fraction, sub-/superscript, math. symbols and greek letters, textstyles italic and bold - Settings for screenmode, font, colors, icon, autosave, ... - uses appicon, toolsmenu, appwindow, OS 3.0-look and AGA, graphics accelerators, clipboard.device, public-screens, xpk-libraries, memory pools, shared pens, amigaguide.library, gadgethelp, ... - most requesters are asynchron - projects and 3D-worksheets - localized, german, english and italian available - a lot of more Changes since version 2.2b - bug fixed: bars were to thick, if histgram part of a chart - cell-types are used for formating of x-axis labels if chart type histogram - 29.02.2000 bug fixed - overflow runtime error which occurs during editing of very large ranges fixed - printing in landscape mode of charts from CGFX screens now possible - bug fixed: endless loop if x values placed behind y values in the worksheet (only real xy chart) - number format of the chart axes (x, y, y2) now (partly) configurable using format patterns - if printing worksheet in mode quality, print margins are now settable in StarAm Plan - printing of the worksheet in landscape mode (which is not possible) is not permitted any more. Changes since version 2.2 - bug fixed: ranges are shown only in the view, where they have been marked now - bug fixed: crash if more than one view of a worksheet open and a new row/column above/left of the first row/column was inserted. - using »true« xy-charts, the x-values may be unsorted and occur more than once. The condition for "false" xy-charts needn't to be fullfilled by »true« xy-charts any more. - using xy-charts no maximum number of data depending on window size any longer - bug fixed: crash if marking ranges above a certain row/column (INTEGER instead of LONGINT used:-( - SDF import: if the seperator is a space, several spaces are interpreted as one seperator - some other minor improvements and fixed bugs (complete list is in the archive) Changes since version 2.1b - bug in installer script fixed: free RAM wasn't checked correctly - considerable less memory consumption of the worksheets now activated: i.e. 52 kbyte (175 cells -> 300 byte per cell) - you can now use simple mathematical expressions ("Formelsatz") in all texts in the chart and the sheet! In the sheet this feature must be activated. - output of texts (screen and printer) won't be cut anymore if the text is longer than the width of the column, so no need to break the text into the next cells (Ctrl/Return)! »Center Row« works without breaking the text into the following cells, too. It can be undone with »Format/Alignment« now. - print out in highest quality and complete WYSIWYG now possible (font, colour, cell grid, borders, mathematical expressions) - Cell references are now linked to its cells, i.e. if cells are removed or new inserted, then the references will be changed so that they refer to the new positions of the cells. All references in the complete project are adapted, 3d references too (but not the layer reference). Links to other worksheets by name (e.g. \Name.A1) aren't changed (this is impracticable). - now cells are always calculated in the correct order. - linear/exponential/power regression now uses errorvalues of the y values if desired. Also the y-error-bars are used calculating the regression curves in charts. - some other minor new features and improvements and some bugs fixed (complete list is in the archive) Changes since version 2.1 - Aminet distribution is now identical to disk distribution - Installer script completely rewritten: - localized - checking minimum preconditions - cleaning up after error - active support of installation on floppy disk (size checking and asking for new directory) - PRETEND mode works - all answers in EXPERT mode are safe - some more informations in EXPERT mode - Creating directory in EXPERT mode only if desired - less questions in AVERAGE mode (more automatic copying) - all questions first if possible - icon positions are kept on update (this must be activated manually by deleting some ; because of compatibility) -> perfect installer-script ;-) - enforcer hits, etc. fixed: changing position of cell A1 with command Edit/Sort confused StarAm Plan - Guru fixed: occured when deleting a text series which contains an empty text - some other enforcer hits and minor bugs fixed and some minor improvements (complete list is in the archive) ============================= Archive contents ============================= Original Packed Ratio Date Time Name -------- ------- ----- --------- -------- ------------- 628 278 55.7% 19-Feb-00 21:29:08 StarAm Plan.info 4525 1982 56.1% 19-Feb-00 20:56:10 +Install.doc 432 241 44.2% 19-Feb-00 20:56:10 +Install.doc.info 41811 9689 76.8% 02-Aug-98 15:38:12 +Installieren 5029 2199 56.2% 19-Feb-00 20:55:38 +Installieren.dok 432 245 43.2% 19-Feb-00 20:55:40 +Installieren.dok.info 757 381 49.6% 02-Aug-98 15:38:12 +Installieren.info 53592 33095 38.2% 15-Sep-95 22:59:24 +lha 369043 369043 0.0% 19-Feb-00 19:19:48 +sap.lha 234285 234285 0.0% 19-Feb-00 20:12:14 +sapdoks.lha -------- ------- ----- --------- -------- 710534 651438 8.3% 21-Feb-100 08:07:10 10 files