Help! About MergeArea

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
ryanmi
Posts: 1
Joined: Sat Jul 19, 2008 1:41 am

Help! About MergeArea

Post by ryanmi »

Welcome beginner. Please answer all of the questions below which may provide information necessary to answer your question.
-----------------------------------------------------------------------------------------------------------
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
        .....
This code can run properly with MS Excel.
But in OpenOffice, CurrCell doesn't have MergeArea.

Waiting for your input
OOo 2.4.X on Ms Windows XP
Post Reply