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

[Gary Dale]

I can browse to a spreadsheet directly without first attaching it to a 
database, but that's just a kludge. LibreOffice creates the base file 
when you select the spreadsheet, which brings me back to the same problem.



On 27/04/16 07:24 PM, Bruce Hohl wrote:

Reportedly, as of LO 5.1 you can create a mail merge without a Base file -
reference this: http://vmiklos.hu/blog/mail-merge-embedding.html  You might
try to recreate your Certificate mail merge without the Base file being
careful to select cell formats for your data that work with Writer.  (If
you have good spreadsheet skills you could likely get the job done entirely
in Calc.)

On Wed, Apr 27, 2016 at 6:18 PM, Gary Dale  wrote:


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 > 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+unsubscr...@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+unsubscr...@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+unsubscr...@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

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

[Bruce Hohl]

Reportedly, as of LO 5.1 you can create a mail merge without a Base file -
reference this: http://vmiklos.hu/blog/mail-merge-embedding.html  You might
try to recreate your Certificate mail merge without the Base file being
careful to select cell formats for your data that work with Writer.  (If
you have good spreadsheet skills you could likely get the job done entirely
in Calc.)

On Wed, Apr 27, 2016 at 6:18 PM, Gary Dale  wrote:

> 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 > > 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+unsubscr...@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+unsubscr...@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+unsubscr...@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

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

[Gary Dale]

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 > 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+unsubscr...@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+unsubscr...@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

[libreoffice-users] Number comparisons in conditional text

[Gary Dale]

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+unsubscr...@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

Re: [libreoffice-users] Ubuntu 16.04 and LibreOffice

[Tim---Kracked_P_P---webmaster]

I do not use the PPA for LibreOffice.  I prefer to "manually" download 
whichever version of LO I want, when I want, for my laptops and desktops 
- Ubuntu and Windows.


Yes, some with Ubuntu 16.04LTS will want to use a PPA, but my question 
is if Ubuntu 16.04 would update LO and other packages sometime between 
now and 2021 when the support will stop.


As for a different reply, Ubuntu 16.04 was installed on my spare laptop 
and did not change LO 5.0.x to 5.1.x.  This is the first time that 
installing Ubuntu did not change the LibreOffice install if it was 
different.  Most of the time, it seems that I have a version of LO newer 
than what the OS has and I will have to reinstall a newer version of LO 
after the OS removed it for a previous version.  This was the first time 
that Ubuntu did not change LO to a different version.


On 04/26/2016 08:45 PM, Bruce Hohl wrote:

At some point during the life of 16.04 you may want to move to a newer
version of LO.
See this link for information on how to accomplish that.
https://launchpad.net/~libreoffice/+archive/ubuntu/ppa

On Tue, Apr 26, 2016 at 7:34 PM, Tim Lloyd  wrote:


Running Fedora with Gnome classic so no real correlation but...stoopid
question...do you have LO & firefox running in the same workspace? EG. I
have FF running in workspace 1 and LO in workspace 4. So when I need to
switch between the 2 apps I change workspaces. Just wondering if the
problem occurs if you have to switch workspaces?

Cheers



On 27/04/16 09:26, Tim---Kracked_P_P---webmaster wrote:


I am currently running 64-bit Ubuntu 16.04LTS [with MATE desktop] on 2
laptops.  I am currently have issues with my install of LO 5.1.2.2 version
with areas in the "menu taskbars" graying out when I switch to its window
from a window like Firefox or other package that I am running.

I did not have this running Ubuntu 15.10.

I also wonder which version of LibreOffice Ubuntu 16.04 includes. I have
found that, in the past, no matter which LO version I have installed the
upgrading of Ubuntu removes my install and installs the one they have in
their repository. This did not happen this time, since my spare laptop had
LO 5.0.x and still has it.  The laptop I am typing from now has 5.1.2.2,
which I installed before I upgraded to Ubuntu 16.04.

So which version is included with the newest version of Ubuntu?

Since 16.04LTS will be supported through 2021, according to a e-news
report, will there be any "push" by LO/TDF to keep Ubuntu's repository
updated to the current LO versions from now till 2021 when this long term
supported Ubuntu OS will no longer be supported by Ubuntu's creators.





--
To unsubscribe e-mail to: users+unsubscr...@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+unsubscr...@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

Re: [libreoffice-users] Ubuntu 16.04 and LibreOffice

[Tim---Kracked_P_P---webmaster]

NO, I do not use more than one workspace.  Last time I did, I forgot 
about an opened package on the second or third workspace and reopened it 
in the first workspace.


Gnome Classic?  Well, I liked the look of the default Gnome desktop for 
Ubuntu 10.04.  When I switched to 12.04LTS, I chose MATE since it looked 
most like what I preferred to use.


On 04/26/2016 07:34 PM, Tim Lloyd wrote:
Running Fedora with Gnome classic so no real correlation but...stoopid 
question...do you have LO & firefox running in the same workspace? EG. 
I have FF running in workspace 1 and LO in workspace 4. So when I need 
to switch between the 2 apps I change workspaces. Just wondering if 
the problem occurs if you have to switch workspaces?


Cheers


On 27/04/16 09:26, Tim---Kracked_P_P---webmaster wrote:


I am currently running 64-bit Ubuntu 16.04LTS [with MATE desktop] on 
2 laptops.  I am currently have issues with my install of LO 5.1.2.2 
version with areas in the "menu taskbars" graying out when I switch 
to its window from a window like Firefox or other package that I am 
running.


I did not have this running Ubuntu 15.10.

I also wonder which version of LibreOffice Ubuntu 16.04 includes. I 
have found that, in the past, no matter which LO version I have 
installed the upgrading of Ubuntu removes my install and installs the 
one they have in their repository. This did not happen this time, 
since my spare laptop had LO 5.0.x and still has it.  The laptop I am 
typing from now has 5.1.2.2, which I installed before I upgraded to 
Ubuntu 16.04.


So which version is included with the newest version of Ubuntu?

Since 16.04LTS will be supported through 2021, according to a e-news 
report, will there be any "push" by LO/TDF to keep Ubuntu's 
repository updated to the current LO versions from now till 2021 when 
this long term supported Ubuntu OS will no longer be supported by 
Ubuntu's creators.










--
To unsubscribe e-mail to: users+unsubscr...@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