Number of actions that can be undone via Edit/Undo‑Redo. Valid range: <2, 200> Default: 20

Notes:

• Very high undo levels + large copy/paste operations may significantly increase memory usage.
• Drag‑drop copying counts as two actions; minimum undo level is 2.

Number of cyclic copy “slots”. Valid range: <1, 16> Default: 1

To paste older items, click the arrow next to Paste:

Select which formula namespace should be used when saving newly created ODS files:

• Excel 2010/2013 (default)
• OpenFormula
• Google Docs

Existing ODS files retain their notation unless changed via Save As.

Using the correct namespace is important — unsupported namespaces may cause formulas to be removed and replaced with values when opened in other applications.

If on, GS-Calc identifies the style of newly entered data and adjusts formatting accordingly. Default: On

If on, the system Date Picker control appears when editing date cells. See: editing and filling cells. Default: On

If on, date strings convert only in cells formatted as Date, Time, or Date/Time. Default: Off

If on, formulas edited in cells use syntax coloring (via the Scintilla project). Default: Off

Controls whether absolute references like $A$1 update when copying or inserting/deleting rows/columns. Default: Off

Controls whether relative references like A1 update when copying or inserting/deleting rows/columns. Default: On

Hides markers for formulas, drop‑down lists, comments, circular references (>1), and truncated text. Default: On

If on, a progress bar is displayed. Default: On

Displays formulas instead of their results. Default: Off

Changes the cell reference notation. See: Cell references. Must use the current notation when entering formulas. Internally, A1 notation is always used. Default: Off (A1)

Adds a third “undeterminate” state for formatting buttons when a selection contains mixed formatting. Default: Off

Note:

May significantly slow down selecting very large ranges.

If on, after opening a text or xBase file, all non‑empty columns are automatically resized to fit their contents.

The resizing respects the limits defined in settings.xml:

• <AutoFitMin> — minimum width (default: 20 px)
• <AutoFitMax> — maximum width (default: 640 px)

Both values may be modified within the range <2; 2000>.

Note:

May slow down opening very large text or xBase files.

Default: Off

If on, the Chart dialog closes when switching worksheets. Leaving it open is useful when the chart is in one sheet and its data in another. Default: Off

Controls whether and how text longer than the cell width is truncated. Default: Allow if adjoining cells are empty

Controls whether GS‑Base scrolls back to the selection origin. If off, click the address in the toolbar to return. Default: No action

Controls how GS‑Base reacts to a single wheel movement:

• scroll lines
• scroll pages

Default: Scroll lines

Controls scrolling after finishing cell editing. Default: No action

Specifies the folder shown first in the Open File dialog after launching GS-Calc.

Period of inactivity after which GS-Calc automatically saves all open workbooks. Default: Never

Period of inactivity after which GS-Calc automatically closes all open workbooks. Modified workbooks are saved before closing. Default: Never

Dialog box transparency. Valid range: <10, 100> Default: 100%

Specifies the default font name. Default: Arial

Number of circular reference iterations. Level ≥ 2 displays circular markers. Use “Inspect Cells” → “Add” to list circular formulas. Valid range: <1, 255> Default: 1

If on, formulas update in background processes. Updated results appear only after completion. No partial updates are possible.

Editing cell data restarts the update cycle; formatting does not.

The status bar shows progress and number of active processes.

Background updating requires more memory. Default: On

If on, referenced workbooks remain open until the referencing workbook closes. If off, referenced workbooks open and close repeatedly during recalculation. Default: On

Number of CPUs/threads used for updating formulas, auto‑fitting widths, and some editing actions.

Using more threads than available cores does not improve performance.

This value applies to workbooks whose individual “Number of CPUs” setting is “Default”. Default: 2

Priority of update threads (Windows priority classes). High priorities may hamper other system processes.

Applies to workbooks whose individual “Threads priority” is “Default”. Default: 2

Recalculates the entire workbook after each cell edit.

Applies to workbooks whose individual “Update Mode” is “Default”. Default: On

Optimizes calculations assuming formulas use both built‑in functions and references.

Applies to workbooks whose individual “Update Optimization Options” are “Default”. Default: On

Optimizes calculations assuming worksheets contain short linked cell groups.

Applies to workbooks whose individual “Update Optimization Options” are “Default”. Default: On

Recalculates cells from right to left and bottom to top (reverse of default order).

Applies to workbooks whose individual “Update Optimization Options” are “Default”. Default: Off