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
   280   281   282   283   284   285   286   287   288   289   290