Short: Spreadsheet, V2.1b,OS 3.0+, 68000 CPU 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 | | 68000 CPU or higher | | (a version for 68020 CPU + 68881 FPU 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 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.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) Changes since version 2.04 - error message if loading a project which contains a worksheet which is part of another loaded project. Removing of the worksheet from the project which is being loaded. So no more danger of a crash. - short help of iconbar now localized - bug fixed in links to other worksheets by name in formulas (\Name.): If the name contains the special characters operators, brackets and # then the name can be set between " (\"Name".). So no error will occur. - links to other worksheets by name in formulas can contain a path now. The name (incl. path) must then set between " (\"Path/Name".). Then the worksheet is searched only in the memory and at the specified place. - text series (a special form of arithmetic series) implemented. The possible text series can be defined by the user. - drawing the charts the resolution and aspect ratio are taken into account completely: length of lines (ticks and subticks, some symbols with previously constant size) thickness of lines (all lines drawn with Draw and DrawEllipse), text height, text width (using FontTags of DiskFont.library v37/39). - the size of elements in the chart now optional depends on the horizontal resolution (as until now) or the width of the window - thickness of lines in chart now selectable (separate for different lines) size of symbols in chart now selectable - bug fixed: Edit/Change deleted cells (long lives undo!) if the cells had contained formulas and only values should been changed - bug fixed: Edit/Changed changed formulas wrong in case of * or / - in texts of charts you can now use simple mathematical expressions ("Formelsatz"): fraction, sub-/superscript, math. symbols and greek letters, textstyles italic and bold - with %n you can now set the position of the factor of the axis lettering in the axis names (in 1000, in Mio, in billion, in 1E+012, ...). Factors in scientific notation are printed now superscript (10^{12} instead 1E+012, ^{ and } certainly not printed and 12 superscript). »in« not printed if %n is used. - work around for inability of the printer.device to print a hardcopy from a CyberGraphX screen, so that you now can print out a chart from a CyberGraphX screen - routine to save a chart as graphics (IFF-ILBM) cybergraphx compatible (but only 8 bit!) rewrited, so that you now can save a chart as graphics (IFF-ILBM) from a CyberGraphX screen (true also for copying into clipboard). - many other bug fixes and improvements (complete list is in the archive) Changes since version from 5-Jan-97: - some bugs fixed (list is in the archive) Changes since version 2.03b - bug in V2.03 fixed: Iconify works again (enforcer-hits/guru/ "hanging" fixed) - xy-charts: x-axis labels have same type (number, date, time, month, weekday) as cells with x-values (e.g. monthnames instead of numbers at x-axis). Format of cells with type date or time is partly used. - setting for view: zero-values are not shown (ignored by celltype text, date and time). Also cellformat to set this for each cell (ignored only by celltype text). - Worksheet/Open, Chart/Load (Chart-Manager) and gadget Load (Worksheet-Manager): Multiselection (and loading) of files in filerequester. - curvechart (and 3d-areachart): empty cells (celltype=text; value=0 AND value of cell is hidden in actual view) and/or cells of value zero can be ignored: gadgets emty and zeros in Chart-Attributes - support of GadgetHelp (Intuition.library V39): there is a shorthelp for the gadgets of the gadgetbar shown, if the mousepointer is over one of the gadgets. Pressing help opens the (context sensitive and asynchrone) online-help (with a longer helptext). - some other things and bugs fixed (complete list is in the archive) Changes since version 2.03: - serious bug fixed: Extras/Export/Range has overwrited the original File, if xpk wasn't used :-( - bug in v2.03 fixed: If SimpleRefresh the worksheet wasn't printed at start automatically. The command Define Worksheet (and reverse) didn't refresh the worksheet. - bug in v2.03 fixed: Extras/Export/Text didn't work because of the new printing features :-( - FPU exceptions are now disabled (because of runtimeerrors if FPU exists -not 68040!- and I couldn't find them lacking a real FPU) - bug fixed: If complete row/column at bottom/right worksheet border removed, undo didn't work. - some minor bugs fixed - some enforcer hits fixed Changes since version 2.0b: - needs AmigaOS 3.0, uses memory pools, shared pens, ... - rows/cols may be fixed at border - undo now with several steps - rows/cols may be alone absolute: A!1! instead of A1! - better print out - using locale.library, english catalog file - better graphics accelorator support - asynchrone and context sensitive online help with amigaguide.library - and a lot of more, a detailed list is in the archive Changes since version 2.0: - runtime-error while creating a circle-chart with senseless values (sum=0, negative values) catched. Occured only with FPU (not 68040 CPU). - Tooltype SMARTREFRESH in program-icon to enable SmartRefresh for Worksheet-Windows. Speed up the Refresh but needs more memory. - Tooltype PALETTEWINDOW in program-icon to change gadgetbar to palette-window. - Possibility to delete format-pattern which are needed for autoformat removed. Changes since version 1.9d: - many commands work now more logical - most requesters are asynchron - better way to select a range, multiselect ranges - new look for worksheet-window - more mouse-commands in worksheet, e.g. drag&drop - more commands for comfort - rangenames linked with cells - a lot new settings - better »projects«, 3D-worksheets - format-pattern and autoformat-command - search and replace - SDF-Import/Export - uses XPK for packing/encryption - uses clipboard.device, public-screens - bug fixes and a lot of more A more detailed list is in the archiv. It is too long to list here.