View

Defines which elements of the LibreOffice Calc main window are displayed. You can also show or hide highlighting of values in tables.

To access this command...

From the menu bar:

Open a spreadsheet document, choose - LibreOffice Calc - View.

From the tabbed interface:

Choose Tools - Options - LibreOffice Calc - View.

From the keyboard:

Press Alt+F12 then choose LibreOffice Calc - View.


Display

Select various options for the screen display.

સૂત્રો

Specifies whether to show formulas instead of results in the cells.

શૂન્ય કિંમતો

Specifies whether to show numbers with the value of 0.

Comment indicator

Specifies that a small triangle in the top right corner of the cell indicates that a comment exists. The comment will be shown only when you enable tips under LibreOffice - General in the Options dialog box.

Comment indicator

To display a note permanently, select the Show note command from the cell's context menu.

You can type and edit comments with the Insert - Comment command. Comments that are permanently displayed can be edited by clicking the comment box. Click the Navigator and under the Comments entry you can view all comments in the current document. By double clicking a comment in Navigator, the cursor will jump to the corresponding cell containing the comment.

Comment authorship

If this box is checked, the author of the comment and the date and time at which the comment was made will appear in the comment window, when you mouse over a comment.

The comment author name appears as it appears in the First Name and Last Name fields in the User Data dialog. If those fields are blank, the author name appears as "Unknown Author". Updating the user data only affects comments made after the update.

Formula indicator and hint

Draws a blue triangle in the bottom-left corner of a cell that contains a formula. When pointing over the blue triangle, the formula is shown in a tool tip even if a different cell is selected.

Formula indicator

કિંમત પ્રકાશિત થાય છે

Mark the Value highlighting box to show the cell contents in different colors, depending on type. Text cells are formatted in black, formulas in green, number cells in blue, and protected cells are shown with light grey background, no matter how their display is formatted.

warning

When this command is active, any colors assigned in the document will not be displayed until the function is deactivated.


Column/Row highlighting

When this command is active, the column and row of a selected cell is highlighted. If multiple cells are selected, only the column and row of the first cell is highlighted.

Column/Row highlighting

Edit cell highlighting

When this command is active, the background of a cell is highlighted when it is in edit mode.

Edit cell highlight

એન્કર

Specifies whether the anchor icon is displayed when an inserted object, such as a graphic, is selected.

Image anchor

સંદર્ભો રંગમાં બતાવો

Specifies that each reference is highlighted in color in the formula. The cell range is also enclosed by a colored border as soon as the cell containing the reference is selected for editing.

References in color

દેખીતી મદદો

Specifies which lines are displayed.

જાળી રેખાઓ

Specifies when grid lines will be displayed. Default is to display grid lines only on cells that do not have a background color. You can choose to also display grid lines on cells with background color, or to hide them. For printing, choose Format - Page Style - Sheet and mark the Grid check box.

Pointer

Specifies whether LibreOffice Calc displays the pointer in the system default style, or the style which matches the icon theme.

Themed

Shows the pointer as defined by the icon theme, typically as a fat cross.

Themed cursor

System

Shows the pointer as the system default, typically as an arrow.

System cursor

પાના વિરામચિહ્નો

Specifies whether to view the page breaks within a defined print area.

Helplines While Moving

Specifies whether to view guides when moving drawings, frames, graphics and other objects. These guides help you align objects.

વસ્તુઓ

Defines whether to display or hide objects, or use placeholders, for up to three object groups.

Objects/Images

Defines if objects and graphics are shown or hidden.

આલેખ

Defines if charts in your document are shown or hidden.

ચિત્રકામ વસ્તુઓ

Defines if drawing objects in your document are shown or hidden.

વિન્ડો

Specifies whether some Help elements will or will not appear in the table.

હરોળ/સ્તંભ શીર્ષકો

Specifies whether to display row and column headers.

Horizontal scrollbar

Specifies whether to display a horizontal scrollbar at the bottom of the document window.

Vertical scrollbar

Specifies whether to display a vertical scrollbar at the right of the document window.

શીટ ટેબ

Specifies whether to display the sheet tabs at the bottom of the spreadsheet document. If this box is not checked, you will only be able to switch between the sheets through the .

બાહ્યરેખા ચિહ્નો

If you have defined an , the Outline symbols option specifies whether to view the outline symbols at the border of the sheet.

Summary on search

If this box is checked, a Search Results window appears when you choose Find All in the Find Bar. The Search Results box states the number of matching search results and lists:

Unchecking the Show this dialog box in the Search Results window disables this feature.

Zoom

સુમેળ અક્ષો

If checked, all sheets are shown with the same zoom factor. If not checked, each sheet can have its own zoom factor.

Please support us!