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.Use the Alt+Tab shortcut keys to cycle through the open documents.ĭrag and drop works slightly differently in Calc than it does in Excel:.Close the current document to access other open documents.Select a document from your desktop’s Panel or Taskbar to activate it.Use the Restore Down button on the Title Bar to minimize the active document and reveal other open documents.From the Window menu, select the document you want to become active.When more than one document is open, you can switch between the active document and other open documents in several ways: Each Calc window provides menus, toolbars and other features that directly relate to the document open in that window. Two of Calc’s strong points are the accessibility of information about the active document and the ease of navigation of an SDI. When you close the parent window, all files are also closed. Excel uses a Multiple Document Interface (MDI) where all open documents are displayed within one parent window. This means that each document has its own window in which only one document is displayed at a time. Table below summarizes some terminology differences between Calc and Excel.Īll of the chapters in this guide and in the Calc Guide use the AOo Calc terminology.Ĭallouts in cells which appear when the mouse pointer is positioned over the cellĬalc uses a Single Document Interface (SDI).

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

Openoffice calc paste values