Excel does not have a similar feature that unifies formatting options with other programs in the MS Office suite.Ĭalc strictly follows the cell format you specified.
The styles in the Styles and Formatting floating window in Calc are consistent with other programs. Calc will generate a “#NAME?” error if you use a comma in place of a semi-colon. The Calc equivalnet, called parameters, uses semicolons. The arguments in Excel uses semicolons to separate parameters in a function. More advanced Calc users can go directly to a more stripped-down Function List. It also displays a tree view of the formula structure which is helpful when composing complex formulas. However Calc’s advantage is that it lists the required fields and errors before you insert a function into a cell. Like Excel, Calc users can use a search field. Calc, however, opens its function wizard directly when the user clicks on the Function Wizard icon. After the search, Excel opens the Functions Argument dialog. Excel users search for the proper function by using natural language queries. You can even view several spreadsheets at the same time.īoth programs have a function bar at the top of the editing window that opens on a list of functions. Each Calc window provides menus, toolbars and other features that directly relate to the document in that window. This a strong point for Calc because it gives greater accessibility to information about the active document and it is easier to navigate within an SDI. When you close the parent window, all files are also closed. This is called a Multiple Document Interface (MDI). In Excel, when you open several workbooks, each is displayed within one parent window. This is called a Single Document Interface (SDI). In Calc, when you open several spreadsheets, each spreadsheet opens in its own window. Callouts which appear when the mouse pointer is positioned over the cell are called” comments” in Excel but are referred to as “notes” in Calc. One tabbed sheet in an Excel workbook is a “worksheet “. One tabbed sheet in a Calc spreadsheet is a “sheet”. The entire file is called a “workbook” in Excel, but is referred to as a “spreadsheet ” in Calc. There are, however, some important differences. The page formats for printing are similar and both programs offer themes for formatting whole sheets. Charts, diagrams, graphics, and text art can be inserted into both. This includes basic arithmetic and simple statistics such as averages, medians, and means.
Excel has the advantage of having advanced filters, which allows cells to be arranged according to its format, color, or by some other criteria.Īlmost 80% of the functions are identical. Rows and columns can be shown, hidden or grouped in both. The list-making, sorting and filtering capabilities are comparable. For starters, the user interface, which includes the icons, menus and toolbars are very much alike in appearance and purpose (except for MS Excel 2007).
0 kommentar(er)
