Question

In excel, where can we view the name of an open office calc or microsoft excel document?

Answer 1

This chapter summarizes the differences in use between OpenOffice.org Calc 2.0 and Microsoft Excel (various versions). The information in this chapter builds upon the information given in Chapter General Differences in Use between OpenOffice.org and Microsoft Office.

The Calc interface

The main Calc workspace is shown below.



Terminology

Table 14 summarizes some terminology differences between Calc and Excel.

All of the chapters in this guide and in the Calc Guide use the OOo Calc terminology.

Excel vs. Calc termsObjectExcelCalcIndividual cell (A1)CellCellEntire fileWorkbookSpreadsheetOne tabbed sheet in a workbook (Sheet 1)WorksheetSheetCallouts in cells which appear when the mouse pointer is positioned over the cellCommentsNotes

User interface

Calc uses a Single Document Interface (SDI). This means that each document has its own window in which only one document is displayed at a time. Excel uses a Multiple Document Interface (MDI) where all open documents are displayed within one parent window. When you close the parent window, all files are also closed.

Two of Calc’s strong points are the accessibility of information about the active document and the ease of navigation of an SDI. Each Calc window provides menus, toolbars and other features that directly relate to the document open in that window.

When more than one OpenOffice.org document is open, you can switch between the active document and other open documents in several ways:

From the Window menu, select the document you want to become active.Use the Restore Down button on the Title Bar to minimize the active document and reveal other open documents.Select a document from your desktop’s Panel or Taskbar to activate it.Close the current document to access other open documents.Use the Alt+Tab shortcut keys to cycle through the open documents.

Drag and drop

Drag and drop works slightly differently in Calc than it does in Excel:

In Excel, after you select the cell or range to be moved, you need to position the pointer fairly precisely on the border of the cell or range for drag and drop to be available. In Calc, after selecting the cell or range, you can position the pointer anywhere within the range.In Calc, to drag and drop a single cell, do this:Select the cell.Drag to select at least one additional cell.Drag back so that only the desired cell is selected. Then the cell can be dragged and dropped.In Calc, to leave the source cell or range intact while dragging and dropping (in other words, to create a copy of the source cell or range), first drag in the normal way, then just before dropping, press and hold the Ctrl key, then release the mouse is