Settings, View tab

<< Click to Display Table of Contents >>

Settings, View tab

On the View tab in the dialog box of the ribbon command File | Options options_icon, you can make some settings for the appearance of spreadsheets on the screen:

Markers

Here, you can change the appearance of the small triangles that are displayed in cells that contain a comment or are protected.

Color of comment markers

Here, you can change the color of the small triangle that is displayed inside cells that contain a comment.

Color of protection markers

Here, you can change the color of the small triangle that is displayed in all cells that are not protected when sheet protection is enabled.

Size

This option allows you to change the size of these markers.

Snapping

Here, you can configure the available aids for positioning objects (text frames, picture frames, etc.) with your mouse:

Snap to cells

This option is disabled by default. Thus, you can move objects freely with the mouse.
If you enable this option and try to change the position of an object with your mouse, however, the object jumps from one table cell to the next.
Enabling or disabling this function temporarily: If the option Snap to cells is enabled, you can temporarily disable it at any time by pressing and holding down the Alt key while moving an object with the mouse. The reverse is also possible: If the option is disabled, it can be temporarily enabled with the Alt key while moving.

Snap to other objects

When this option is enabled, the software automatically creates "magic" guides for the edges of each object in the current worksheet. These guides make it a lot easier to position objects perfectly aligned and evenly distributed.
These "magic" guides are usually invisible. They only become visible when you drag an object near such a guide with the mouse. As soon as the guide appears, the object automatically snaps to it. Something similar happens when you resize an object with your mouse.
Some examples of such guides:
If you drag an object to a position where it is roughly left-aligned with another object, a guide will automatically appear representing the left edge of the other object. If you let your object snap to it, it will be exactly left-aligned with the existing object.
The same applies to the right edge of objects.
If you drag an object to a position where it is roughly centered with another object, a guide will automatically appear representing the center of the object. If you let your object snap to it, it will be aligned exactly centered with the other object.
If you drag an object to a position below two other objects, you will also see a horizontal guide at the position where this third object would have exactly the same relative distance as the other two objects. (The three objects would then be distributed evenly.)
All of this works in both directions (horizontally and vertically) – for example, a magic guide is generated for the top and bottom edges of each object.
Tip: If you hold down the Alt key while moving the object, you can temporarily disable the option Snap to other objects that is generally enabled.

Snap tolerance

Here, you can change the tolerance for the option Snap to other objects. The higher the set value, the quicker a moving object will snap to one of the "magical" guides for existing objects.
The default value is a distance of 8 pixels.

Paint grid behind cells

When you enable this option, the gray gridlines displayed between the table cells are painted in the background of the cells (and no longer in the foreground). As a result, the gridlines will no longer be visible for cell ranges that have a colored background.

Cell marker

Here, you can change the color and line width of the cell frame (the dark frame that indicates the currently active cell in a worksheet).

cell_frame_detailed_a

Worksheet tabs

The worksheet register at the bottom of the document window displays tabs for each worksheet in the current document.

This option allows you to change the font size used to display the worksheet name on these tabs.

Highlight (only available in SoftMaker Office NX Home and NX Universal)

Highlight current column and row: If you enable this option, the column and row for the currently selected cell are highlighted in color. This gives you a better idea of where the selected cell is currently located on the worksheet.

Note: The highlighting only appears if a single cell is selected and not if several cells are selected.

You can change the color of the highlighting by using the dropdown below.