This is only possible if the reference range, where the column or row is inserted, originally spanned at least two cells in the desired direction.Įxample: If the range A1:B1 is referenced in a formula and you insert a new column after column B, the reference is expanded to A1:C1.
![openoffice calc help print gridlines openoffice calc help print gridlines](https://calendartricks.com/wp-content/uploads/2021/OpenOffice-page-settings.png)
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.
![openoffice calc help print gridlines openoffice calc help print gridlines](https://image.slidesharecdn.com/ismaelitera-191110103027/85/assignment-in-it-era-1-320.jpg)
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.