Unlike in the InsertCells method, a parameter for performing automatic moves is not provided in the moveRange method. The cell contents in the target range are always overwritten by the moveRange method. Row (long) number of the addressed row (numbering begins with 0). Sheet (short) number of the spreadsheet (numbering begins with 0).Ĭolumn (long) number of the addressed column (numbering begins with 0). The CellAddress structure provides the following values: In addition to the CellRangeAdress structure, the moveRange method expects a .CellAddress structure to define the origin of the move's target region. moveRange (CellAddress, CellRangeAddress ) CellRangeAddress Dim CellAddress As New com. The following example moves the B2:C3 range so that the range starts at position A6:ĭim Doc As Object Dim Sheet As Object Dim CellRangeAddress As New com. The XRangeMovement interface provides two additional methods for moving ( moveRange) or copying ( copyRange) cell ranges. ROWS the rows after the insert position are moved upwards.ĬOLUMNS the columns after the insert position are moved to the left. LEFT the cells at and to the right of the insert position are moved to the left. UP the cells at and below the insert position are moved upwards. NONE the current values remain in their current position. The type of removal is defined by one of the following values from the .CellDeleteMode enumeration: This example removes the B2:C3 cell range from the sheet and then shifts the underlying cells up by two rows. removeRange(CellRangeAddress, .CellDeleteMode.UP) This method deletes the range that is defined in the CellRangeAddress structure from the sheet. The removeRange method is the counterpart to the insertCells method. ROWS the rows after the insert position are moved downwards.ĬOLUMNS the columns after the insert position are moved to the right. RIGHT the cells at and to the right of the insert position are moved to the right. NONE the current values remain in their present position.ĭOWN the cells at and under the insert position are moved downwards.

The CellInsertMode enumeration recognizes the following values: The second parameter of insertCells contains a value of the .CellInsertMode enumeration and defines what is to be done with the values that are located in front of the insert position. The completed CellRangeAddress structure must be passed as the first parameter to the insertCells method. StartRow (long) first row in the cell range (numbering begins with 0).ĮndColumn (long) final column in the cell range (numbering begins with 0).ĮndRow (long) final row in the cell range (numbering begins with 0). StartColumn (long) first column in the cell range (numbering begins with 0). Sheet (short) number of the sheet (numbering begins with 0). The following values are included in this structure: To define the cell range that you want to insert, use the .CellRangeAddress structure. Any existing values in the specified cell range are moved below the range. This example inserts a cells range that is two rows by two columns in size into the second column and row (each bear the number 1) of the first sheet (number 0) in the spreadsheet. The insertCell method is used to insert cells into a sheet.ĭim Doc As Object Dim Sheet As Object Dim CellRangeAddress As New com.

The interface ( .XCellRangeMovement) is available through the spreadsheet object and provides four methods for modifying cell content. In addition to directly modifying cell content, Apache OpenOffice Calc also provides an interface that allows you to insert, delete, copy, or merge cells. Inserting, Deleting, Copying and Moving Cells The Cell.Type property returns a value for the .CellContentType enumeration which identifies the contents type of a cell.

FORMULA MsgBox 'Content: Formula' End Select Dim Doc As Object Dim Sheet As Object Dim Cell As ObjectĬell.

Libreoffice basic data types