Thanks a lot, again :-)
Regards, mathias
Tom Schindl wrote:
-----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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
