Cell Contents

Opens a submenu with commands to calculate tables and activate AutoInput.

To access this function...

Recalculate

Recalculates the current sheet manually. Use this command to update all calculations in the document if you have deselected the automatic recalculation function, and also to update the NOW() function.

AutoCalculate

Automatically recalculates all formulas in the document.

AutoInput

Switches the AutoInput function on and off, which automatically completes entries, based on other entries in the same column. The column is scanned up to a maximum of 2000 cells or 200 different strings.

Index

recalculating,all formulas in sheets

formulas, recalculating manually

cell contents, recalculating

calculating, auto calculating sheets

AutoCalculate function in sheets

correcting sheets automatically

formulas,AutoCalculate function

cell contents,AutoCalculate function

entering entries with AutoInput function

capital letters,AutoInput function

This help text is published from the OpenOffice-Help files under the Public Documentation License 1.0.