Sheet.removeRange(selection.RangeAddress, .CellDeleteMode.UP) Sheet.insertCells(target, .CellInsertMode.DOWN) Target = CreateUnoStruct(".CellRangeAddress") Sheet.moveRange(target.CellAddress, source.RangeAddress) Target_row = sheet.getCellRangeByName("A20") 'First column Target_column = sheet.getCellRangeByName("H1") 'First row You can copy columns or rows, but make sure that the cell target it's the first cell. pyRange(target.CellAddress, source.RangeAddress) Source = sheet.getCellRangeByName("A1:B3") Ranges = rango1.queryIntersection(rango2.RangeAddress) Range2 = sheet.getCellRangeByName("G8:N17") Range1 = sheet.getCellRangeByName("B2:I11") Ranges = selection.queryRowDifferences(source.CellAddress) Ranges = selection.quer圜olumnDifferences(source.CellAddress) Source = selection.getCellByPosition(0, 0) Ranges = selection.queryFormulaCells(.FormulaResult.ERROR) Ranges = selection.quer圜ontentCells(.CellFlags.STRING) Tip: All next methods, always get a group range (ScCellRangesObj) Names.addNewByName("NewData", "$A$1:$B$7", cell.CellAddress, flag)Īrgument expand (True) or not (False) the range selection. Range = sheet.getCellRangeByName("Address") Selection = ThisComponent.CurrentSelectionĬAUTION: Current selection can be many things. Range = sheet.getCellRangeByName("D5:F10") Group.removeRangeAddress(range2.RangeAddress) Ranges = Array(range1.RangeAddress, range2.RangeAddress, range3.RangeAddress) Group.addRangeAddress(range3.RangeAddress, False) Group.addRangeAddress(range2.RangeAddress, False) Group.addRangeAddress(range1.RangeAddress, False) Range3 = sheet.getCellRangeByName("H15:J20") Range2 = sheet.getCellRangeByName("D5:F10") Range1 = sheet.getCellRangeByName("A1:B2") Group = doc.createInstance(".SheetCellRanges") Range = sheet.getCellRangeByName("B2:C5") Range = sheet.getCellRangeByPosition(start_column, start_row, end_column, end_row) Range = sheet.getCellRangeByName("B5:D10") Sheet = Ĭell = sheet.getCellByPosition(column, row)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |