Toggle Commands

Xspread has several optional settings which operate like toggle switches. Each switch has two settings. The toggle commands change the settings of the selected switch to its opposite setting without forcing you to go through the slash (/) command tree to set or reset them.

All of the toggle commands are of the form ˆ To, where ``o'' represents a letter that stands for the option that you want to toggle. The settings of all toggle options are saved with the worksheet when it is written into a worksheet file. The toggle options are:

a Automatic / Manual Recalculation.

If automatic recalculation is set, every change to the spreadsheet will cause the spreadsheet to be recalculated. If manual recalculation is set, xspread does not recalculate the spreadsheet unless you explicitly issue a recalculation command (@).

e External Function Execution.

If external functions are enabled, xspread calls them whenever the screen is updated. If external functions are disabled, any external functions that are referenced are not called during screen updates. If external functions are referenced in the worksheet and they are disabled, xspread prints a warning each time that the screen is updated. The result from @ext() is the value from the previous call, if any, or else a null string.

n Quick Numeric Entry.

If set, you can start numeric entry with any digit, a plus sign, or a minus sign. If not set, you must start numeric entry with an equals sign.

t Top Line Display.

If set, the top line of the worksheet window displays the name and value of the current cell. If not set, the top line is blank.

x Encryption.

If set, worksheet files are encrypted when xspread saves them using the /File Put command and xspread assumes that worksheets that it reads using the /File Get command are encrypted. If not set, xspread does not encrypt files with /File Put nor does it decrypt files with /File Get.

$ Dollar Prescale.

If set, numeric amounts are automatically scaled by .01 when you enter them into cells. This allows users to avoid typing the decimal points in monetary amounts. If not set, numeric amounts are not scaled.

r Newline action.

Toggle between no action, move down after entry and move right after entry.

z Set newline action limits.

The limits are set to the current row and column (for r and z see also set rowlimit=n, collimit=n).