< Documentation‎ | BASIC Guide
OpenOffice SpreadSheets is an application included in the OpenOffice Suite from The Apache Software Organization. The Suite also includes Writer, which is the word processing application of the software; Impress, the presentation application; Draw, a drawing utility; Math, an equation editor; and Base, a database management system for desktops. OpenOffice SpreadSheets is an application included in the OpenOffice Suite from The Apache Software Organization. The Suite also includes Writer, which is the word processing application of the software; Impress, the presentation application; Draw, a drawing utility; Math, an equation editor; and Base, a database management system for desktops.
- The Structure of Spreadsheets
- OpenOffice is open-source office software suite used for word processing, spreadsheets, presentations, graphics, and databases. Open-source software is free for users to download, modify, copy and distribute.
- Sep 03, 2020 Spreadsheets are used for What-if calculations. Change one number in a spreadsheet and all the calculations in a large spreadsheet will re-calculate, will automatically change. With this wiki learn how to use OpenOffice Calc to learn your way around this powerful (and free) software.
- The primary advantage of using Apache OpenOffice as a productivity suite comes from the cost. OpenOffice is open source software that is free to download and free to use. It includes word processing, spreadsheet, presentation, vector graphic editing and database management components.
The document object of a spreadsheet is based on the com.sun.star.sheet.SpreadsheetDocument service. Each of these documents may contain several spreadsheets. In this guide, a table-based document or spreadsheet document is the entire document, whereas a spreadsheet (or sheet for short) is a sheet (table) in the document.
VBA : Different terminology for spreadsheets and their content is used in VBA and Apache OpenOffice Basic. Whereas the document object in VBA is called a Workbook and its individual pages Worksheets, they are called SpreadsheetDocument and Sheet in Apache OpenOffice Basic. |
Avee player for mac.
Spreadsheets
You can access the individual sheets of a spreadsheet document through the Sheets list.
The following examples show you how to access a sheet either through its number or its name.
Example 1: access by means of the number (numbering begins with 0)
ThisComponent returns the currently active document. The expression Doc.Sheets(0) is a Basic simplification of the API call : Doc.getSheets.getByIndex(0) |
Erdas imagine 2016 software manual. Example 2: access by means of the name
In the first example, the sheet is accessed by its number (counting begins at 0). In the second example, the sheet is accessed by its name and the getByName method.
The Sheet object that is obtained by the getByName method supports the com.sun.star.sheet.Spreadsheet service. In addition to providing several interfaces for editing the content, this service provides the following properties:
- IsVisible (Boolean)
- value True if the spreadsheet is visible.
- PageStyle (String)
- name of the page template for the spreadsheet.
Renaming Sheets
A sheet provides methods
getName
and setName
to read and modify its name. Basic can handle both methods like a property Name
. Here we rename the first sheet of the spreadsheet document.![Openoffice Spreadsheet Openoffice Spreadsheet](https://a.fsdn.com/con/app/proj/openofficeorg.mirror/screenshots/calc.png)
Creating and Deleting Sheets
The Sheets container of a spreadsheet document is also used to create and delete individual sheets. The following example uses the hasByName method to check if a sheet called MySheet exists. If it does, the method determines a corresponding object reference by using the getByName method and then saves the reference in a variable in Sheet. If the corresponding sheet does not exist, it is created by the createInstance call and inserted in the spreadsheet document by the insertByName method.
The hasByName, getByName and insertByName methods are obtained from the com.sun.star.container.XNameContainer interface as described in Introduction to the API.
The interface com.sun.star.sheet.Spreadsheets provides a better method to create a new sheet:
insertNewByName
.It inserts a new sheet with the name specified by the first argument, at the position specified by the second argument.The same interface provides methods
moveByName
and copyByName
. Install ubuntu software center in kali linux download.Openoffice Calc Download
The com.sun.star.container.XNameContainer interface provides a method to remove a sheet of a given name:
Content on this page is licensed under the Public Documentation License (PDL). |
How To Wrap Text In Openoffice Spreadsheet
Retrieved from 'https://wiki.openoffice.org/w/index.php?title=Documentation/BASIC_Guide/Structure_of_Spreadsheets&oldid=239900'