Re: [libreoffice-users] Number comparisons in conditional text

I've tried it with Debian/Stretch v5.1.2.2.0+ and Windows 7 v5.1.3. If I 
was running anything old or unusual, I would have noted it. The document 
is simple, as is the spreadsheet and the base file that connects them.

I tried changing the numbers to text but Base doesn't seem to allow 
that. It's decided that the columns for age and place are decimal numbers.

So far as I can see, either the number comparisons operate differently 
from the text comparisons (which the documentation doesn't mention) or 
the number comparisons are broken. Normally I'd consider that unlikely, 
but my past experience with printing "form letters" and labels is that 
these areas don't get a lot of attention.


On 27/04/16 03:32 PM, Bruce Hohl wrote:
> Can you give more details of your set-up.  What is in the Writer, Calc 
> and / or Base components of LO.
>
> On Wed, Apr 27, 2016 at 11:44 AM, Gary Dale <garydale@torfree.net 
> <mailto:garydale@torfree.net>> wrote:
>
>     I'm trying to print certificates for a group of athletes and need
>     to have them reflect their standing in the event. The certificate
>     has a number of conditional text fields, such as to translate
>     their gender from M/F to male/female, which are working.
>
>     However the ones that are doing numeric comparisons aren't. The
>     comparison always seems to return "true" so the "then" condition
>     is printed. For example Run Results.Race.place == 1 is the
>     condition but the translation text is always "first place", never
>     empty. Since I have 5 different conditions (first 3 positions,
>     participate, supported), I get a lot of text printed that shouldn't.
>
>     The slightly more complex Run Results.Race.age > 18 AND Run
>     Results.Race.age < 60 always prints adult. At one point I had it
>     print an else (senior) but that branch was never taken even when
>     the age was well past 60.
>
>     I've checked the Run Results.odb file (which links to a
>     spreadsheet) and the age & place fields are both of type decimal.
>
>     What am I doing wrong?
>
>     -- 
>     To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
>     <mailto:users%2Bunsubscribe@global.libreoffice.org>
>     Problems?
>     http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>     Posting guidelines + more:
>     http://wiki.documentfoundation.org/Netiquette
>     List archive: http://listarchives.libreoffice.org/global/users/
>     All messages sent to this list will be publicly archived and
>     cannot be deleted


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted