Page 285 - Trackpad IT-402_Class-IX
P. 285
Subject: To show formulas in OpenOffice Calc
Step 1: Click on Tools menu from the menu bar.
Step 2: Click on 'Options...' from the options. The 'Options - ....' dialog box appears.
Step 3: Now, double-click on OpenOffice Calc and select the View.
Step 4: Select the Formulas checkbox from the Display section.
Step 5: Click on the OK button. Now, the formula is visible in place of result. You can uncheck the
Formulas check box to get the result back.
FIND AND REPLACE
In a spreadsheet, you can find text, formulas, and styles by using Find & Replace dialog box. To open Find & Replace
dialog box, select Find & Replace option from the Edit menu.
You can navigate from one result to the next using Find, or you can highlight all matching cells at once using Find All,
then apply another format or replace the cell. contents by other content.
Text or numbers in cells may have been entered directly or maybe the result of a calculation. The search method
depends on the type of data you are searching for.
By default, Calc searches the current sheet. To search through all sheets of the document, click on More Options, then
select the Search in all sheets option.
Cells can contain text or numbers that were entered directly as in a text document. But cells can also contain text or
numbers as the result of a calculation.
Electronic Spreadsheet 285

