conditional expression in spreadsheet

[garya]

Probably something stupid, but I can't get the following to work as an expression in a spreadsheet (Mdl, NumWells_A,B are cell aliases):

Code: Select all

= (Mdl == 4) ? NumWells_A : NumWells_B

Do relationals not work in spreadsheets in v 0.18?
If not, do they work in 0.19?

OS: FreeBSD 11.3-RELEASE-p12
Word size of OS: 64-bit
Word size of FreeCAD: 64-bit
Version: 0.18.0.18.4
Build type: Release
Python version: 3.7.8
Qt version: 5.14.2
Coin version: 4.0.0
OCC version: 7.4.0.beta
Locale: C/Default (C)

Thanks,
Gary

[drmacro]

see example in this file: https://github.com/macdroid53/MyShares/ ... anup.FCStd

[chrisb]

It works here in 0.19 if I omit the brackets around the condition.

[garya]

Thanks both for the replies. It appears the parens around the expression screw things up.
I will make a note in the docs.

[chrisb]

There is a pull request concerning expressions from realthunder in the queue, which may fix this. Can somebody who has his branch installed please test this?

[Syres]

There is a pull request concerning expressions from realthunder in the queue, which may fix this. Can somebody who has his branch installed please test this?

I've tested with ExprCompleter branch and it works with the brackets omitted:

Code: Select all

=Mdl == 4 ? NumWells_A : NumWells_B

OS: Windows 7 SP 1 (6.1)
Word size of OS: 64-bit
Word size of FreeCAD: 64-bit
Version: 0.19.21652 +28 (Git)
Build type: Release
Branch: ExprCompleter
Hash: a1c4e0c86da1058a8e39f3d67df704ecde654708
Python version: 3.6.8
Qt version: 5.12.1
Coin version: 4.0.0a
OCC version: 7.3.0
Locale: English/United Kingdom (en_GB)

[garya]

I've tested with ExprCompleter branch and it works with the brackets omitted:

Code: Select all

=Mdl == 4 ? NumWells_A : NumWells_B

The issue is not without the quotes; it's *with* the quotes