Invoking Plan Maker Formulae From Basic Maker

Post Reply
Mennochio
Posts: 14
Joined: Tue May 26, 2020 6:20 pm

Invoking Plan Maker Formulae From Basic Maker

Post by Mennochio »

How do I invoke formulae from Plan Maker in Basic Maker code?
For example, "=DECIMALS(1.235)" in a cell of Plan Maker yields 0.235.
But n =DECIMALS(1.235) in Basic Maker results in "Sub or function not defined: DECIMALS"

Thanks.
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 3172
Joined: Wed Mar 11, 2020 5:31 pm

Re: Invoking Plan Maker Formulae From Basic Maker

Post by SuperTech »

Thanks for posting your problem. You can use Formula property of object range or cells in this case.

Code: Select all

pm.Range("a2").formula="=DECIMALS(1.235)"
OR

Code: Select all

pm.cells(2,1).formula="=DECIMALS(1.235)"
You can refer to our user manual for complete details here.
Mennochio
Posts: 14
Joined: Tue May 26, 2020 6:20 pm

Re: Invoking Plan Maker Formulae From Basic Maker

Post by Mennochio »

Thanks. :D
Post Reply

Return to “BasicMaker 2021 for Windows”