Multiple Operations Across Rows and Columns
StarOffice allows you to carry out joint multiple operations for columns and rows
in so-called cross-tables. The formula cell has to refer to both the data range
arranged in rows and the one arranged in columns. Select the range defined by
both data ranges and call the multiple operation dialog. Enter the reference to the
formula in the Formula field. The Row field is used to enter the reference to the
first cell of the range arranged in rows, and the Column field the first cell of the
range arranged in columns.
Calculating with Two Variables
Consider columns A and B of the sample table above. You now want to vary not
just the quantity produced annually, but also the selling price, and you are inter-
ested in the profit in each case.
Expand the table. D2 thru D11 contain the numbers 500, 1000 and so on, up to
5000. In E1 through H1 enter the numbers 8, 10, 15 and 20.
= B4*(B1 - B2) - B3
1. Select the range D1:H11.
2. Choose Data - Multiple Operations.
3. With the cursor in the Formulas field, click cell B5.
4. Set the cursor in the Rows field and click cell B1. This means that B1, the selling
price, is the horizontally entered variable (with the values 8, 10, 15 and 20).
5. Set the cursor in the Column field and click in B4. This means that B4, the
quantity, is the vertically entered variable.
6. Close the dialog with OK. You will see the profits in the range E2:H11. In some
cases you must first press F9 to update the table.
240 StarOffice™ 7 User's Guide