Ask Your Question
0

Using Calc Formula Function with Macro

asked 2015-02-14 15:29:42 +0200

LaurentOlive gravatar image

Dear LibreOffice Community,

I wrote a calc macro like: Cell.Formula = "=MIN(B4, B5)" Im my cell, the formula is correct : "=MIN(B4, B5)". But the value is Err:508 If I edit the formula, remove a character and put it back. The value is computed correctly. There is the Bug 59916. It looks like to be my problem. What should I do to make it working? Thank you.

LibreOffice Version: 4.3.3.2 Build ID: 430m0(Build:2) OS: Ubuntu 14.10

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2015-02-14 16:42:32 +0200

pierre-yves samyn gravatar image

Hi - Can I assume from your name that your environment is not English?

Your macro should use the argument separator according to Tools> Options> Calc> Formula> Separators> Function.

For example, in French the semicolon.

thiscomponent.currentselection.formula="=MIN(B4; B5)"
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-02-14 15:29:42 +0200

Seen: 1,584 times

Last updated: Feb 14 '15