Document properties, Options tab

<< Click to Display Table of Contents >>

Document properties, Options tab

On the Options tab in the dialog box of the ribbon command File | Properties doc_prop_icon, you can make general settings for the current document:

"Text frames" section

Tab width

Determines the tab width for text entered in text frames.

"Cell contents" section

Syntax highlighting

If this option is enabled, cells will be colorized according to their content. Corresponds to the ribbon command View | Syntax highlighting (see Syntax highlighting).

Show formulas

If this option is enabled, cells containing a calculation will display the formula instead of the result. Corresponds to the ribbon command View | Show formulas (see Displaying formulas instead of results).

Protection indicator

If this option is enabled, a green triangle will be displayed in all unprotected cells – when sheet protection is enabled. This makes it easier to see which cells may still be edited. For more information, see also Sheet protection.

Hyphenation

If this option is enabled, automatic hyphenation is performed in all cells where the option Wrap text has been enabled in the dialog box of the command group Home | Alignment group_arrow. For more information, see also Hyphenation.

"Comments" section

Show indicators

If this option is enabled, a red triangle is displayed in all cells that contain a comment (inserted with the command Insert | Comment). For more information, see also Using comments.

Always show comments

Normally, comments are displayed only when you point with your mouse to a cell that contains a comment. If you enable this option, all comments in the current document will be displayed permanently.

"Decimal point after input" section

Move by ... decimals

If this option is enabled, numbers entered in cells will be shifted by the specified number of decimal places.
This is helpful if, for example, many numbers with two decimal places have to be entered. If this option is set to 2 and the number 42 is entered, it will be converted to 0.42. If 234 is entered, it will be converted to 2.34. The decimal points do not have to be entered manually.

"Window" section

Vertical scrollbar

If this option is enabled, a vertical scrollbar is displayed in the document window.

Horizontal scrollbar

If this option is enabled, a horizontal scrollbar is displayed in the document window.

Sheet tabs

If this option is enabled, the worksheet register with tabs for each worksheet is displayed below the document. These tabs can be used for switching between worksheets and creating/managing worksheets.

"Objects" section

Guidelines for text frames

If this option is enabled, non-printing border lines are displayed around text frames. These lines make it easier to determine and change the position/size of text frames.

Show hidden objects

As described in the section Hiding objects, you can hide inserted objects on the screen, that is: make them invisible.
However, if you enable the option Show hidden objects, any object for whose Visible property is disabled become visible on the screen.

Default currency

Use this option to change the default currency of the current document.

Note: Normally, this option should be set to System default. This will cause PlanMaker to use the default currency from your system's country settings.

Setting this option to a different currency has the following consequence:

Whenever PlanMaker automatically applies the Currency number format to a cell (for example, because it uses an arithmetic function that returns a monetary value), the currency chosen here will be used instead of the system's default currency.

Compatibility button

Here, you can make internal settings for compatibility with documents created in older versions of PlanMaker or in Microsoft Excel. These options are set automatically when the document is opened and should not normally be changed.