#Openoffice calc help print gridlines update#

Specifies whether to expand references when inserting columns or rows adjacent to the reference range. The format will also apply to all new values inserted within this range.Р”В®xpand references when new columns/rows are inserted To see the affected range, press Ctrl+* (multiplication sign on the number pad). However, cells that already have a special format will not be modified by this function. If, for example, an inserted cell has the bold attribute, this attribute will also apply to empty adjacent cells. Specifies whether to automatically apply the formatting attributes of an inserted cell to empty adjacent cells.

Specifies that pressing Enter puts the selected cell into edit mode. If this option is not selected, pressing Enter completes data entry for a cell but does not move the cursor. If this option is selected, you can also choose the direction the cursor moves: up, down, left, or right. Specifies that pressing Enter moves the cursor to another cell. You might want to avoid updating links when opening documents if they often contain many charts or linked graphics that would slow down loading.

#Openoffice calc help print gridlines update#

Regardless of this setting, you can manually update links at any time. Selecting general options for Calc Metrics sectionР”В¬hoose the unit of measurement used in spreadsheets and the default tab stops distance.Р”В¬hoose whether to update links when opening a document always, only on request, or never.