B4J Question [SOLVED] JPOI excel formula


Active Member
Licensed User
Longtime User
Hello community,
I have a problem with create a formula with JPOI:

            'NOTE:  "SE" is the italian formula name equivalent IF english formula"
            'If I press ENTER in the formula bar, the formula works!

            'this formula doesn't work (excel error:  #NAME?)
            row.CreateCellFormula(5, $"SE(A1=1,"ugual","disegual")"$)    
           'this formula work
            row.CreateCellFormula(6, $"C${i + 3} * D${i + 3}"$)

thank you for suggestion
Last edited: