{S:X;X;0;2;Differences between PipeDream and Resultz}
{S:X;X;0;3;Resultz is not PipeDream. Resultz has been designed from scratch to be (i) the most advanced spreadsheet program available for RISC OS and (ii) completely integrated into the Fireworkz family. Many Resultz users will have used PipeDream. This document introduces the features of Resultz which will be new to PipeDream users. Most of what is said will also apply to users of other spreadsheet programs.}
{S:X;X;0;5;Page layout. Resultz page layout facilities go far beyond any other spreadsheet program available on the Archimedes, or Windows or Macintosh. }
{S:X;X;0;6;The spreadsheet window is page-based and completely WYSIWYG. Just like a DTP system you see the pages exactly as they will print. You can have multiple views and scaled views. Columns are split across pages so that you can see exactly what will appear on each page. The Paper dialogue box enables you to match your paper size on screen to the printer driver settings with a single click, or you can specify your own paper sizes. You can work in either portrait or landscape on screen\\\; landscape probably enables that last column to fit!}
{S:X;X;0;7;We believe that Resultz is unique in enabling you to change column widths at any point down the spreadsheet. Usually spreadsheets constrain you to using the same set of column widths at the bottom of the document as you used at the top. There is no such constraint in Resultz. Plenty of examples using this are provided in the spreadsheets on this disc.}
{S:X;X;0;9;User interface. The user interface has been designed to be as simple and direct as possible. The button bar at the top of the window gives access to the most frequently used commands. }
{S:X;X;0;10;The status line provides interactive help about Resultz and your spreadsheets. Descriptions of all Resultz' functions and their parameters are provided.}
{S:X;X;0;11;Formula line. Function entry is much slicker than PipeDream: if you enter the function from the function selector you get automatic parameter help and pasting. When entering cell references and ranges in the formula line, they are given a soft selection so that clicking several times overrides the previous references, but typing will insert after the references. Try it, it's easier to use than to describe!}
{S:X;X;0;12;Auto sum enables you to create totals with just a click on the button. Other RISC OS spreadsheet programs merely use the auto sum button to insert an empty sum() on the formula line. Resultz will do that if you wish, but if you make a selection of cells with blank cells in the last row or column, then a click on the auto sum button will create the complete sum() formula, including cell references, and insert it into the cell.}
{S:X;X;0;13;The style editor enables you to make styles which can be applied at any level from a single character up to the whole document. Unlike in other spreadsheet programs, they can also be layered, just like in Wordz and Impression. Styles can contain a wide range of attributes, from font sizes and colours to grid styles, horizontal and vertical justification. Styles can be used to predefine areas of the sheet. You can specify that cells should become either text cells or number cells when you type data into them, or that a column should be left-aligned or in a different font.}
{S:X;X;0;14;Styles are a very important and powerful feature of Resultz. Using them will enable you to build better looking documents more quickly.}
{S:X;X;0;15;Protection is provided as a style attribute. It is probably best used by setting up a style containing just protection and applying it to cells. You may want to add a background colour to the style in order to see the protected areas.}
{S:X;X;0;16;Number/date formats can be specified as part of a style. You can provide styles specifying different numbers of decimal places, or a percentage style, or even roman numerals.}
{S:X;X;0;17;Gridlines of different thicknesses, line styles and colours can be drawn around cells using the Box command.}
{S:X;X;0;18;Templates are files from which you can start new documents. The Save Template command will place your document in the templates directory (!Resultz.User.Templates). When you click on the Resultz icon a menu of templates appears for you to select. You can also use Save Template to save out styles to copy into other documents.}
{S:X;X;0;19;When creating a chart, it is automatically placed inside your spreadsheet document. So saving and printing the spreadsheet saves and prints the chart too, with no extra work. This makes it much easier to manage charts in Resultz than in any other RISC OS spreadsheet program. Examples of charts are provided in the charts directory.}
{S:X;X;0;21;New functions}
{S:X;X;0;22;age subtracts one date from another and returns the result as a date. This is useful for calculating someone's age in terms of years and months.}
{S:X;X;0;23;bin counts the frequencies of classes of data. The output can be used as the input to a histogram and an example of this is given in the Charts directory of the examples disc.}
{S:X;X;0;24;counta counts the number of elements in an array or range}
{S:X;X;0;25;dayname returns a string of the dayname, the day being given as a number. eg dayname(weekday(today))}
{S:X;X;0;26;flip turns an array upside down}
{S:X;X;0;27;formula_text returns as a string the formula in another cell. This can be used to annotate spreadsheets, to show what formulae were used to produce the results. It is a way of printing both the results and the formula at the same time.}
{S:X;X;0;28;listcount takes an array or range of data and produces a list of all the unique elements plus their frequencies. An extension takes values for each element and adds the values together. }
{S:X;X;0;29;median returns the median value of a range or array}
{S:X;X;0;30;monthname: as dayname. eg monthname(month(today))}
{S:X;X;0;31;page returns the page number (x or y) of a cell}
{S:X;X;0;32;pages returns the number of pages (x or y) in the document}
{S:X;X;0;33;rank returns an array of rankings from an input array}
{S:X;X;0;34;sort sorts an array on a given column}
{S:X;X;0;35;spearman calculates the Spearman correlation co-efficient from two ranked arrays. The arrays can be ranked using the rank function.}
{S:X;X;0;36;text takes a number and a number format (identical to those in style editor) and returns a string of the formatted number}
{S:X;X;0;38;Function enhancements}
{S:X;X;0;39;lookup has been extended. An optional fourth parameter set to 1 provides two extra types of information to be returned: (i) all occurrences which match the key are returned, rather than simply the first, (ii) for each match a whole record can be returned, rather than just a simple value.}
{S:X;X;0;40;set_value has been extended. Optional third and fourth parameters specify an offset in an array. This enables you to write to a single element in an array.}
