-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Did you by chance took a look here?
Tom
http://codesnippets.services.openoffice.org/Calc/Calc.CellMerger.snip babar wrote: | Hi list, | | I'm looking for a way to merge cells in a spreadsheet document. | | I've tried this (other stuffs) but without any success :/ | | Sub mergeCells(sheetIndex, rowIndex) | Dim oSheet as object, oCells as object, oRange as object | Dim oCellRange as new com.sun.star.table.CellRangeAddress | oCellRange.sheet = sheetIndex | oCellRange.startColumn = 0 | oCellRange.endColumn = 2 | oCellRange.startRow = rowIndex | oCellRange.endRow = rowIndex | oSheet = thisComponent.Sheets.getByIndex(sheetIndex) | oRange = | oSheet.SheetCellRanges.SheetCellRangeContainer.addRangeAddress(oCellRange, | true) | 'oCells = oCharts(0).setRanges(oCellRange) | 'oCells.merge(true) | End Sub | | THanks for your help, regards | Mathias | | --------------------------------------------------------------------- | To unsubscribe, e-mail: [EMAIL PROTECTED] | For additional commands, e-mail: [EMAIL PROTECTED] | |
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD4DBQFCPDSkkVPeOFLgZFIRApjcAJjZyP9tTskc4QGpPAhvUYTV9QNbAKCyqAzC ObgegVhMNdAUr2fZjWLJkQ== =PUnG -----END PGP SIGNATURE-----
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]