libreoffice basic - inserting conditional format

 Dear Lady/Sir,

My apologies to bother you with such insignificant thing. But I found nothing so far at internet to explain my mistake.
I learned VBA by my self. This means I don't have too much knowledge about programming.

Usually I make spreadsheets in Excel. But for now on, I'll have to use libreoffice as well.
I need to create a spreadsheet with conditional format. Lots of cells (over 300) with, at least 2 conditional formulas.

So I search lots at internet and found how to do it with libreoffice basic.
But something is wrong. Please look at example code below:

Sub Test
    Dim mCond (2) As New com.sun.star.beans.PropertyValue
    Dim oEntrys As Variant
    Dim oExtension as object
    Dim oDoc as object

    oDoc = ThisComponent

    oExtension = oDoc.getSheets().getByName("Test1").getCellRangeByPosition(0,5,0,5) 'A6

    oEntrys = oExtension.getPropertyValue("ConditionalFormat")

    mCond(0).Name = "Operator"
    mCond(0).Value = com.sun.star.sheet.ConditionOperator.FORMULA
    mCond(1).Name = "Formula1"
    mCond(1).Value = "OR(B6>1;B6<7)"
    mCond(2).Name = "StyleName"
    mCond(2).Value = "Result"

    oEntrys.clear()
    oEntrys.addNew(mCond())
    oExtension.setPropertyValue("ConditionalFormat", oEntrys)
End Sub

So far, so good.

The formula, as you see, seems right and functional. But when I execute de script, in cell A5
the formula appears as "OR(B11>1;B11<7)" (print screen attached).

In original script I used a line counter like this: "OR(B" & LineCounter & ">1;B" & LineCounter & "<7)".
The LineCounter starts at 6. When I watched the result in cell, I do not understand why 6 become 11.

So I used a string var 'Auxiliar' to mount and watch the result with step by step execution of script.
The formula value in 'Auxiliar' was right, just like in example code above.

I was using libreoffice 3.3.3. I thought maybe there was a bug at this version. I Uninstall it and install version 4.0.3.
Same thing happend.

I'm still searching (about 30 days so far) and found nothing!

Please, could tell me where is my mistake? 

José Ramos
joseramos@bb.com.br

Attachment: Imagem.jpg
Description: JPEG image