-----------------------------------------------------------------------------------------------------------
Which version of OpenOffice.org are you using?
2.4
What Operating System (version) are you using?
windows xp
What is your question or comment?
How can i get the MergeArea from a cell in spreadsheet?
Code: Select all
Set SrcRg = ActiveSheet.UsedRange
For Each CurrRow In SrcRg.Rows
CurrTextStr = ListSep
For Each CurrCell In CurrRow.Cells
If (CurrCell.Text = "" And CurrCell.Column = 1 And (Not CurrCell.MergeCells)) Then
.....
ElseIf (CurrCell.MergeCells And CurrCell.MergeArea.Rows.Count = 1) Then
.....
But in OpenOffice, CurrCell doesn't have MergeArea.
Waiting for your input