Re: [libreoffice-users] Re: LibreOffice Download

2016-01-04 Thread Virgil Arrington 
For what it's worth, I had downloaded the "fresh" branch a few weeks 
ago. I think it was version 5.0.3 (or 4). I experienced daily crashes 
with it. I got so frustrated that I completely uninstalled it and went 
back to the trusty "still" version. My current plan is to not go near 
version 5 until I find that version 4 fails to complete my work.


I would recommend that the download cite default to the "still" branch. 
If I had been a complete noob and had this experience with the default 
"fresh" branch, I'd be looking for a different solution altogether.


Virgil

On 01/04/2016 02:17 PM, Tom Davies wrote:

Hi :)
This mailing list usually recommends the "Still" branch rather than
the "Fresh" branch.

The "Still" branch has usually had enough "Service Packs" to fix
almost any problems that people may have had with the "Fresh" branch.
  The "Fresh" branch is the default download offered on the official
website.  It helps the least geeky people and complete noobs to get
the version with the newest features and the most problems.  The
"Still" branch has all the features almost anyone is ever likely to
need, it is extremely robust and reliable - so we give people the
other version because it's more interesting and flashy.

However the "Fresh" branch has just had it's 4th "Service Pack" and so
it's about due to be named the new "Still" branch.  It's about the
time that many of us on this mailing list move our clients and
"mission critical" machines onto this branch and start getting excited
about the prospect of having an entirely new branch to try out.

Good luck and regards from
Tom :)




--
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] Re: LibreOffice Download

2016-01-04 Thread Tom Davies 
Hi :)
This mailing list usually recommends the "Still" branch rather than
the "Fresh" branch.

The "Still" branch has usually had enough "Service Packs" to fix
almost any problems that people may have had with the "Fresh" branch.
 The "Fresh" branch is the default download offered on the official
website.  It helps the least geeky people and complete noobs to get
the version with the newest features and the most problems.  The
"Still" branch has all the features almost anyone is ever likely to
need, it is extremely robust and reliable - so we give people the
other version because it's more interesting and flashy.

However the "Fresh" branch has just had it's 4th "Service Pack" and so
it's about due to be named the new "Still" branch.  It's about the
time that many of us on this mailing list move our clients and
"mission critical" machines onto this branch and start getting excited
about the prospect of having an entirely new branch to try out.

Good luck and regards from
Tom :)






On 4 January 2016 at 12:53, william drescher  wrote:
> On 1/4/2016 6:11 AM, Shakir, Salman (External) wrote:
>>
>> Dear Sir/Madam,
>>
>> I want to ask about the downloading procedure. Is it necessary to download
>> it with Torrent because in some countries use of Torrent is not allowed. So
>> kindly help me in this regard.
>>
>> Best Regards
>> Salman Shakir
>>
>
> you can download directly from
> http://www.libreoffice.org/download/libreoffice-fresh/
>
>
>
> --
> 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] LibreOffice Download

2016-01-04 Thread Shakir, Salman (External) 
Dear Sir/Madam,

I want to ask about the downloading procedure. Is it necessary to download it 
with Torrent because in some countries use of Torrent is not allowed. So kindly 
help me in this regard.

Best Regards
Salman Shakir

-- 
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] Re: LOBase Query - Left or Right Join?

2016-01-04 Thread Don Parris 
On Sat, Jan 2, 2016 at 4:36 AM, Luuk  wrote:

>
>
> On 01-01-16 22:08, Paul Steyn wrote:
>
>> Hi Don,
>> 
>
>

> You are absolutely right, but the *syntax* is different in LO 
>>
> see link i posted earlier
>
>
>
>
> Still trying to work out the OUTER JOIN syntax apparently.  I tried a
simpler outer join statement:
SELECT
"tCoreType"."type" "Type", "tCoreCategory"."category" "Category"
FROM {oj "tCoreType" "ctype" LEFT OUTER JOIN "tCoreCategory" "ccat"
  ON "ctype"."type_id" = "ccat"."type_id"}


This gives me the following error:
SQL Status: S0022
Error code: -28

Column not found: tCoreType.type in statement [SELECT "tCoreType"."type"
"Type", "tCoreCategory"."category" "Category" FROM  "tCoreType" "ctype"
LEFT OUTER JOIN "tCoreCategory" "ccat" ON "ctype"."type_id" =
"ccat"."type_id"  ]

The column "type" is most certainly one of the columns in the specified
table.  No matter what order or how I try to enter this, it just comes up
with an error message.  Any ideas?  I really would like to learn how to
make this work.

-- 
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate
http://dcparris.net/ 

GPG Key ID: F5E179BE

-- 
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] PDF scripting from LibreOffice

2016-01-04 Thread Daniel A. Rodriguez 
Hi,

is it possible to create a PDF form which performs mathematical calculations?








Comunidad LibreOffice Argentina
www.libreoffice.org.ar

-- 
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] Re: LibreOffice Download

2016-01-04 Thread Tim---Kracked_P_P---webmaster 


Virgil;
What system are you using that gives you the daily crashes?

I agree with Tom that soon the current 5.0.x line will be turned into 
the "still" version line.  I am running both 4.x.x and 5.0.x between my 
different dual booting Win10 partitions and my Ubuntu 14.xx/15.xx 
partitions and single OS systems.


I have not experienced any crashing, except for some very large and 
complex files.  Maybe I do not use my LO version[s] as much as you do, 
but I am not getting your type of crashing.


So it could be something in your system that may not like LO, or it may 
just be that there is a corruption in the config files.  If I remember 
correctly, 4.x and 5.x use different config file folders.


Yes, I still recommend 4.x to people, but since that like is coming to 
its end, I will have to decide if 5.0.x is ready "enough" for me to 
point clients and family to it.


Tim L.




On 01/04/2016 03:39 PM, Virgil Arrington wrote:
For what it's worth, I had downloaded the "fresh" branch a few weeks 
ago. I think it was version 5.0.3 (or 4). I experienced daily crashes 
with it. I got so frustrated that I completely uninstalled it and went 
back to the trusty "still" version. My current plan is to not go near 
version 5 until I find that version 4 fails to complete my work.


I would recommend that the download cite default to the "still" 
branch. If I had been a complete noob and had this experience with the 
default "fresh" branch, I'd be looking for a different solution 
altogether.


Virgil

On 01/04/2016 02:17 PM, Tom Davies wrote:

Hi :)
This mailing list usually recommends the "Still" branch rather than
the "Fresh" branch.

The "Still" branch has usually had enough "Service Packs" to fix
almost any problems that people may have had with the "Fresh" branch.
  The "Fresh" branch is the default download offered on the official
website.  It helps the least geeky people and complete noobs to get
the version with the newest features and the most problems.  The
"Still" branch has all the features almost anyone is ever likely to
need, it is extremely robust and reliable - so we give people the
other version because it's more interesting and flashy.

However the "Fresh" branch has just had it's 4th "Service Pack" and so
it's about due to be named the new "Still" branch.  It's about the
time that many of us on this mailing list move our clients and
"mission critical" machines onto this branch and start getting excited
about the prospect of having an entirely new branch to try out.

Good luck and regards from
Tom :)







--
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] BaseForms: transferring contents of data fields to the database table

2016-01-04 Thread Egbert Eissing 
I have a main form and a sub form. 
The main form holds one single record, the sub form contains multiple records 
related to the record in the main form. 
Both forms are holding alphanumeric and also pure numeric data. 
I wrote a macro to evaluate and calculate the numeric data in the sub form and 
deposit the results in fields of the main form. 

Now my problem: The numbers placed in the main form fields by means of the 
macro are not recognized by the back end MySQL database. These simply are not 
transferred, whatever I do. (If I write some figures in manually, the same are 
being transferred without problem.) What can I do to work around this problem? 
Is there any kind of trick that makes the form believe that the automatically 
generated data have been put in by hand and treated accordingly? I am sure 
there must be a solution to this. 
Thanks for any help. 

-- 
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] Re: LibreOffice Download

2016-01-04 Thread Tim Lungstrom 


Virgil;
What system are you using that gives you the daily crashes?

I agree with Tom that soon the current 5.0.x line will be turned into 
the "still" version line.  I am running both 4.x.x and 5.0.x between my 
different dual booting Win10 partitions and my Ubuntu 14.xx/15.xx 
partitions and single OS systems.


I have not experienced any crashing, except for some very large and 
complex files.  Maybe I do not use my LO version[s] as much as you do, 
but I am not getting your type of crashing.


So it could be something in your system that may not like LO, or it may 
just be that there is a corruption in the config files.  If I remember 
correctly, 4.x and 5.x use different config file folders.


Yes, I still recommend 4.x to people, but since that like is coming to 
its end, I will have to decide if 5.0.x is ready "enough" for me to 
point clients and family to it.


Tim L.


On 01/04/2016 03:39 PM, Virgil Arrington wrote:
For what it's worth, I had downloaded the "fresh" branch a few weeks 
ago. I think it was version 5.0.3 (or 4). I experienced daily crashes 
with it. I got so frustrated that I completely uninstalled it and went 
back to the trusty "still" version. My current plan is to not go near 
version 5 until I find that version 4 fails to complete my work.


I would recommend that the download cite default to the "still" 
branch. If I had been a complete noob and had this experience with the 
default "fresh" branch, I'd be looking for a different solution 
altogether.


Virgil

On 01/04/2016 02:17 PM, Tom Davies wrote:

Hi :)
This mailing list usually recommends the "Still" branch rather than
the "Fresh" branch.

The "Still" branch has usually had enough "Service Packs" to fix
almost any problems that people may have had with the "Fresh" branch.
  The "Fresh" branch is the default download offered on the official
website.  It helps the least geeky people and complete noobs to get
the version with the newest features and the most problems.  The
"Still" branch has all the features almost anyone is ever likely to
need, it is extremely robust and reliable - so we give people the
other version because it's more interesting and flashy.

However the "Fresh" branch has just had it's 4th "Service Pack" and so
it's about due to be named the new "Still" branch.  It's about the
time that many of us on this mailing list move our clients and
"mission critical" machines onto this branch and start getting excited
about the prospect of having an entirely new branch to try out.

Good luck and regards from
Tom :)







--
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] Re: LibreOffice Download

2016-01-04 Thread Virgil Arrington 

Tim,

I'm using Ubuntu 14.04 LTS with the Unity DE. I honestly don't recall 
the actual things I was doing when it crashed, other than I was using 
Writer (which I use 95% of the time). If I recall, it happened a lot 
when I had multiple files open, and it nearly always happened when I 
tried to open an ".odt" file directly from "Files," the Ubuntu file 
manager, rather than going through the LO "Open File" dialogs.


Before uninstalling, I did some online searching and found many others 
who were experiencing frequent crashing with 5.0.x. I just figured it 
wasn't yet ready for prime time.


As for config files, when I installed 5.0.x, it recognized my custom 
settings and templates from 4.4.x, so it must have imported at least 
some of them.


At any rate, I'm generally happy with 4.4.7.2.

Virgil



On 01/04/2016 07:19 PM, Tim---Kracked_P_P---webmaster wrote:


Virgil;
What system are you using that gives you the daily crashes?

I agree with Tom that soon the current 5.0.x line will be turned into 
the "still" version line.  I am running both 4.x.x and 5.0.x between 
my different dual booting Win10 partitions and my Ubuntu 14.xx/15.xx 
partitions and single OS systems.


I have not experienced any crashing, except for some very large and 
complex files.  Maybe I do not use my LO version[s] as much as you do, 
but I am not getting your type of crashing.


So it could be something in your system that may not like LO, or it 
may just be that there is a corruption in the config files.  If I 
remember correctly, 4.x and 5.x use different config file folders.


Yes, I still recommend 4.x to people, but since that like is coming to 
its end, I will have to decide if 5.0.x is ready "enough" for me to 
point clients and family to it.


Tim L.




On 01/04/2016 03:39 PM, Virgil Arrington wrote:
For what it's worth, I had downloaded the "fresh" branch a few weeks 
ago. I think it was version 5.0.3 (or 4). I experienced daily crashes 
with it. I got so frustrated that I completely uninstalled it and 
went back to the trusty "still" version. My current plan is to not go 
near version 5 until I find that version 4 fails to complete my work.


I would recommend that the download cite default to the "still" 
branch. If I had been a complete noob and had this experience with 
the default "fresh" branch, I'd be looking for a different solution 
altogether.


Virgil

On 01/04/2016 02:17 PM, Tom Davies wrote:

Hi :)
This mailing list usually recommends the "Still" branch rather than
the "Fresh" branch.

The "Still" branch has usually had enough "Service Packs" to fix
almost any problems that people may have had with the "Fresh" branch.
  The "Fresh" branch is the default download offered on the official
website.  It helps the least geeky people and complete noobs to get
the version with the newest features and the most problems. The
"Still" branch has all the features almost anyone is ever likely to
need, it is extremely robust and reliable - so we give people the
other version because it's more interesting and flashy.

However the "Fresh" branch has just had it's 4th "Service Pack" and so
it's about due to be named the new "Still" branch.  It's about the
time that many of us on this mailing list move our clients and
"mission critical" machines onto this branch and start getting excited
about the prospect of having an entirely new branch to try out.

Good luck and regards from
Tom :)










--
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] Re: Checkbox in table cell (inside of a frame)

2016-01-04 Thread william drescher 

On 12/31/2015 8:15 AM, william drescher wrote:

I have a three col table inside of 3 linked frames.
I would like to add a Checkbox in table cell

I followed the help instructions, but the checkbox icon does not
drag from the form toolbar to the table.

I suspect that I am missing a step.

bill



Thanks Sigrid and Brian

Brian's original post never did show up in my newsgroup feed (gmane).


--
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] Re: LibreOffice Download

2016-01-04 Thread william drescher 

On 1/4/2016 6:11 AM, Shakir, Salman (External) wrote:

Dear Sir/Madam,

I want to ask about the downloading procedure. Is it necessary to download it 
with Torrent because in some countries use of Torrent is not allowed. So kindly 
help me in this regard.

Best Regards
Salman Shakir



you can download directly from
http://www.libreoffice.org/download/libreoffice-fresh/


--
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] Re: Checkbox in table cell (inside of a frame)

2016-01-04 Thread Brian Barker 

At 07:51 04/01/2016 -0500, William Drescher wrote:

Brian's original post never did show up in my newsgroup feed (gmane).


How right you are! Nothing from me has appeared in Gmane since 19 
September 2013. You may have to choose a service which works, without 
censoring replies.


Does anyone know why I am persona non grata? I wonder how many others are ...

Brian Barker 



--
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] Not archived mails at Gmane (was: Re: Checkbox in table cell (inside of a frame))

2016-01-04 Thread Nino Novak 
On 04.01.2016 at 14:49, Brian Barker wrote:
> At 07:51 04/01/2016 -0500, William Drescher wrote:
>> Brian's original post never did show up in my newsgroup feed (gmane).
> 
> How right you are! Nothing from me has appeared in Gmane since 19 September
> 2013. You may have to choose a service which works, without censoring replies.
> 
> Does anyone know why I am persona non grata? I wonder how many others are ...

Strange, in deed.

I just sent a request for explanation to gmane.org, will report their
reaction hopefully soon :)

Nino

-- 
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] Help with the CALC CURRENT() function

2016-01-04 Thread Brian Barker 

At 15:36 03/01/2016 -0500, Rémy Gauthier wrote:
I am using CALC in LO 5.0.3.2 on a Fedora 23 
(formally 22) system. The version of LO I use is 
a version I downloaded from the LO site, not the 
version that installs with Fedora. I had to 
implement something in CALC that looked more or less like this:

F(X) = (X+5)*6 + (((25+(X+5)*6-6) MOD 14)

If X is equal to 25, the result is 183. If I 
place this formula in a cell (where cell A2 
contains 25): =(A2+5)*6+MOD(25+(A2+5)*6-6;14), 
CALC indeed provides 183 as the answer. However, 
the following thing happens when I try to use 
the CURRENT() function in that calculation:


=(A2+5)*6+MOD(25+CURRENT()-6;14): The result provided is 182
=(A2+5)*6+MOD(25-6+CURRENT();14): The result provided is 190
=(A2+5)*6+MOD(CURRENT()+25-6;14): The result provided is 183
=(A2+5)*6+MOD(-6+CURRENT()+25;14): The result provided is 193

It is my understanding that the CURRENT() 
function returns the current value of the 
formula being calculated. In the examples above, 
because the call to CURRENT() is inside the 
MOD(), the value of the formula at that point 
should be the same (180=(25+5)*6 in my example) 
regardless of where CURRENT() is placed since 
the MOD cannot be calculated before the two 
arguments are evaluated. Is there something I am missing?


I suspect this is "by design". The problem, I 
think, is that there is no unique meaning to "the 
current value of the formula being calculated" in 
any but the simplest of cases. If your formula is 
evaluated from left to right, the first part will 
indeed have been determined as 180. But then this 
result will have been held in suspension whilst 
the value of the MOD() function reference - and 
in particular of its first argument - is 
calculated. In your first example, for instance, 
when CURRENT() is encountered, there will be two 
current values, neither of which can be described 
as the value of the formula, namely the 180 and 
now 25 as part of the new calculation. CURRENT() 
clearly uses this new value - the value of the 
sub-expression currently being evaluated - and not the value in suspension.


In the third example, there is no value yet for 
the new sub-expression, and CURRENT() defaults to 
the existing value of 180. I think you like this, 
but I'm not sure it's helpful. You might be amused by examining the effect of

=MOD(CURRENT()+25-6;14)
or just
=CURRENT()

I suspect you need either not to worry about the 
extra calculation done if you repeat (A2+5)*6 
explicitly within your formula or else to 
calculate it separately in a cell and then use a 
reference to that cell twice in your formula. 
Remember that the necessary cell can be in a 
hidden column or row or outside the print range 
or on another sheet, as preferred. CURRENT() is meant for other purposes.


I trust this helps.

Brian Barker


--
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] Not archived mails at Gmane (was: Re: Checkbox in table cell (inside of a frame))

2016-01-04 Thread Nino Novak 
On 04.01.2016 at 14:49, Brian Barker wrote:
> At 07:51 04/01/2016 -0500, William Drescher wrote:
>> Brian's original post never did show up in my newsgroup feed (gmane).
> 
> How right you are! Nothing from me has appeared in Gmane since 19 September
> 2013. You may have to choose a service which works, without censoring replies.
> 
> Does anyone know why I am persona non grata? I wonder how many others are ...

Strange, in deed.

I just sent a request for explanation to gmane.org, will report their
reaction hopefully soon :)

Nino

-- 
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