Re: [libreoffice-users] Re: Downloads impossible and latest version of Firefox not recognized by captcha, connclusion: service level zero

2016-10-10 Thread Virgil Arrington
For what it's worth, I just downloaded LO 5.1.5.2 from the official 
download page and installed it on my Windows 10 system and all worked 
just fine.

Virgil


On 10/10/2016 10:56 AM, Pedro wrote:
> Hi Jurriaan
>
> You can get any version you like from
> http://downloadarchive.documentfoundation.org/libreoffice/old/
>
> or simply the latest at
> http://downloadarchive.documentfoundation.org/libreoffice/old/latest/win/
>
> These files are guaranteed to be in working conditions. If you can not get a
> working file from this server then you need to look for the problem
> somewhere else (maybe your antivirus?)
>
> I suggest that you use a download manager such as the FLOSS Free Download
> Manager (http://www.freedownloadmanager.org/) to make sure your download is
> 100% complete.
>
> Hope this helps!
>
>
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Downloads-impossible-and-latest-version-of-Firefox-not-recognized-by-captcha-connclusion-service-levo-tp4196366p4196467.html
> Sent from the Users mailing list archive at Nabble.com.
>


-- 
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] Exporting a PDF file with fill in fields

2016-10-10 Thread Ken Springer

I've just posted a message about document protection.

After I've got the document protection the way I wish, how do I export 
that document as a PDF and retain the ability to have the fill in fields?



--
Ken
Mac OS X 10.11.6
Firefox 48.0.1
Thunderbird 45.3.0
"My brain is like lightning, a quick flash
 and it's gone!"


--
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] Document protection

2016-10-10 Thread Ken Springer

Windows 7 Ultimate
LO 5.1.5.2

I've created a document with a simple table.  In one column, each cell 
contains a fill in field.


I want to protect the entire document from changes *except* the fields.

How can I do this?  I haven't found a way up to now.

Incidentally, the help file for cell protection does not match the program.


--
Ken
Mac OS X 10.11.6
Firefox 48.0.1
Thunderbird 45.3.0
"My brain is like lightning, a quick flash
 and it's gone!"


--
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] loading a database with images

2016-10-10 Thread Gary Dale

On 10/10/16 05:29 PM, Gary Dale wrote:

On 10/10/16 05:05 PM, Gary Dale wrote:

On 10/10/16 03:38 PM, Robert Großkopf wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Gary,

SELECT "place"

You have forgotten: ,
SELECT "place", ...

CASE WHEN "place" = 0 THEN 'image0.png' WHEN "place" = 1 THEN
'image1.png' WHEN "place" = 2 THEN 'image2.png' WHEN "place" = 3
THEN 'image3.png' WHEN "place" >= 4 THEN 'image4.png' END "ribbon"
FROM "Results"

With ' ' will be input text. It isn't an image, which could be shown.
Save the images by a form in a separate table "images".
You will get the image you want, if you start a subselect for it.

SELECT "place",
CASE WHEN "place" = 0 THEN (SELECT "image" FROM "image" WHERE "ID" = 0)
WHEN "place" = 1 THEN (SELECT "image" FROM "image" WHERE "ID" = 1)
WHEN "place" = 2 THEN (SELECT "image" FROM "image" WHERE "ID" = 2)
WHEN "place" = 3 THEN (SELECT "image" FROM "image" WHERE "ID" = 3)
WHEN "place" >= 4 THEN (SELECT "image" FROM "image" WHERE "ID" = 4)
END AS "ribbon"
FROM "Results"

Regards

Robert


Having an issue with my form. I was able to dump the ID data into it 
from a spreadsheet (paste into the table) but the table seems to be 
read only. When I right-click on the image control, nothing happens. 
I also have an extra field which provides a text translation of what 
the image says and I can't modify it either.


I was following a video by TheFrugalComputerGuy.com -

LibreOffice Base (15) Embedding a Picture and things went pretty much 
as per his video in the very short bit about actually adding the 
control, but it doesn't let me edit.


There's probably something about Forms that I'm missing


Actually, it looks like any table I add is read only... The original 
table in the database allows me to add and change records, but new 
tables that I add don't.


Go it. The old primary key problem. Base insists that it create one and 
call it ID instead of using another name.


--
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] loading a database with images

2016-10-10 Thread Gary Dale

On 10/10/16 05:05 PM, Gary Dale wrote:

On 10/10/16 03:38 PM, Robert Großkopf wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Gary,

SELECT "place"

You have forgotten: ,
SELECT "place", ...

CASE WHEN "place" = 0 THEN 'image0.png' WHEN "place" = 1 THEN
'image1.png' WHEN "place" = 2 THEN 'image2.png' WHEN "place" = 3
THEN 'image3.png' WHEN "place" >= 4 THEN 'image4.png' END "ribbon"
FROM "Results"

With ' ' will be input text. It isn't an image, which could be shown.
Save the images by a form in a separate table "images".
You will get the image you want, if you start a subselect for it.

SELECT "place",
CASE WHEN "place" = 0 THEN (SELECT "image" FROM "image" WHERE "ID" = 0)
WHEN "place" = 1 THEN (SELECT "image" FROM "image" WHERE "ID" = 1)
WHEN "place" = 2 THEN (SELECT "image" FROM "image" WHERE "ID" = 2)
WHEN "place" = 3 THEN (SELECT "image" FROM "image" WHERE "ID" = 3)
WHEN "place" >= 4 THEN (SELECT "image" FROM "image" WHERE "ID" = 4)
END AS "ribbon"
FROM "Results"

Regards

Robert


Having an issue with my form. I was able to dump the ID data into it 
from a spreadsheet (paste into the table) but the table seems to be 
read only. When I right-click on the image control, nothing happens. I 
also have an extra field which provides a text translation of what the 
image says and I can't modify it either.


I was following a video by TheFrugalComputerGuy.com -

LibreOffice Base (15) Embedding a Picture and things went pretty much 
as per his video in the very short bit about actually adding the 
control, but it doesn't let me edit.


There's probably something about Forms that I'm missing


Actually, it looks like any table I add is read only... The original 
table in the database allows me to add and change records, but new 
tables that I add don't.



--
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] loading a database with images

2016-10-10 Thread Gary Dale

On 10/10/16 03:38 PM, Robert Großkopf wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Gary,

SELECT "place"

You have forgotten: ,
SELECT "place", ...

CASE WHEN "place" = 0 THEN 'image0.png' WHEN "place" = 1 THEN
'image1.png' WHEN "place" = 2 THEN 'image2.png' WHEN "place" = 3
THEN 'image3.png' WHEN "place" >= 4 THEN 'image4.png' END "ribbon"
FROM "Results"

With ' ' will be input text. It isn't an image, which could be shown.
Save the images by a form in a separate table "images".
You will get the image you want, if you start a subselect for it.

SELECT "place",
CASE WHEN "place" = 0 THEN (SELECT "image" FROM "image" WHERE "ID" = 0)
WHEN "place" = 1 THEN (SELECT "image" FROM "image" WHERE "ID" = 1)
WHEN "place" = 2 THEN (SELECT "image" FROM "image" WHERE "ID" = 2)
WHEN "place" = 3 THEN (SELECT "image" FROM "image" WHERE "ID" = 3)
WHEN "place" >= 4 THEN (SELECT "image" FROM "image" WHERE "ID" = 4)
END AS "ribbon"
FROM "Results"

Regards

Robert


Having an issue with my form. I was able to dump the ID data into it 
from a spreadsheet (paste into the table) but the table seems to be read 
only. When I right-click on the image control, nothing happens. I also 
have an extra field which provides a text translation of what the image 
says and I can't modify it either.


I was following a video by TheFrugalComputerGuy.com -

LibreOffice Base (15) Embedding a Picture and things went pretty much as 
per his video in the very short bit about actually adding the control, 
but it doesn't let me edit.


There's probably something about Forms that I'm missing


--
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] loading a database with images

2016-10-10 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Gary,
> 
> SELECT "place"
You have forgotten: ,
SELECT "place", ...
> CASE WHEN "place" = 0 THEN 'image0.png' WHEN "place" = 1 THEN
> 'image1.png' WHEN "place" = 2 THEN 'image2.png' WHEN "place" = 3
> THEN 'image3.png' WHEN "place" >= 4 THEN 'image4.png' END "ribbon" 
> FROM "Results"

With ' ' will be input text. It isn't an image, which could be shown.
Save the images by a form in a separate table "images".
You will get the image you want, if you start a subselect for it.

SELECT "place",
CASE WHEN "place" = 0 THEN (SELECT "image" FROM "image" WHERE "ID" = 0)
WHEN "place" = 1 THEN (SELECT "image" FROM "image" WHERE "ID" = 1)
WHEN "place" = 2 THEN (SELECT "image" FROM "image" WHERE "ID" = 2)
WHEN "place" = 3 THEN (SELECT "image" FROM "image" WHERE "ID" = 3)
WHEN "place" >= 4 THEN (SELECT "image" FROM "image" WHERE "ID" = 4)
END AS "ribbon"
FROM "Results"

Regards

Robert
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJX++4ZAAoJELDKYwaoS9AI+QEP/jUfg1Cwf7YdC7IikOt+xEWo
dWFdiRMCpP8suxymm6CIZ+gAWaC8HiokAIn9M3ynGdw+Pq86SQhO2yGOkYIYO8LW
LAO2LRT0gToOdjJgGB2g8+qYZmF5tV8Tr8z7sli9TrL8h0Rs1cKkS490JrmOS38M
6/xkqAEFk5zC+n70rpZRq2qmnJ/kZ+OgATu9Qmf2ojnC4ItR46vKny3z6Z1mXCHU
VT9DHagE0+kykFOgARffmugfvKNPHZNknaYuuF9LOig0ah6uK/+MhnB5Lp4gE8G6
H2p06RFSnKy6e4gw16Z+KB/5E/wLO5RQE2UKeP5npKLJuUG+N5gpMRJvuF50jwsr
MBNsLzMmZnSuh24CLclsOOAJ1jDf6aC6LJf2R18NK91R9vCihpixBJ3S7BNRF+/f
ZrMYVgKkaE1F+o56rEvPk4RYJUvtZb+hHZUf/jgfA1NU2S1FNLAtj+oB1xFVPuD+
0KSKM3ML4n2vmS/IBuDS1XcoGYC/zU9uA4ugTsPqhQA+bmfZJGKKFwlqIux3PKUz
Vq+I7JvxzLgjJZ+tNWZ0bcuq4+5vs5ffMLXxCdeVPIm37PnIVAvPsic2ErdcKnDc
6ykrhS2vpU+rFi0fD+BFZedgB+YHFaUFWrQbZz1cdeKuzHAwk4SKiYsq5SzijI0l
gsnZ266aXuWu5cwYOVjz
=U3qe
-END PGP SIGNATURE-

-- 
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] loading a database with images

2016-10-10 Thread Gary Dale

On 10/10/16 02:56 PM, Gary Dale wrote:
I have a database with a large enough number of records that I don't 
want to do this manually. I would like to have query do it instead. 
Everything I've found through searches seems to want to do it manually 
by creating a form.


I have a small number of images (5), one of which will be added to the 
database based on the content of another field.


What I was thinking was something along the lines of (extra fields 
omitted)


SELECT "place"
  CASE WHEN "place" = 0 THEN 'image0.png'
 WHEN "place" = 1 THEN 'image1.png'
 WHEN "place" = 2 THEN 'image2.png'
 WHEN "place" = 3 THEN 'image3.png'
 WHEN "place" >= 4 THEN 'image4.png'
  END "ribbon"
FROM "Results"

However I have two issues with that. The first is that the "Ribbon" 
field probably won't contain the image from the current directory but 
will instead just contain the text. The other is that Base complains 
about a SQL syntax error when I try to save it.


Can anyone help me move forward on this?


OK, missing comma after the first field explains the syntax error. But 
as expected, I'm getting the file name rather than the actual file in 
the query result.


--
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] loading a database with images

2016-10-10 Thread Gary Dale
I have a database with a large enough number of records that I don't 
want to do this manually. I would like to have query do it instead. 
Everything I've found through searches seems to want to do it manually 
by creating a form.


I have a small number of images (5), one of which will be added to the 
database based on the content of another field.


What I was thinking was something along the lines of (extra fields omitted)

SELECT "place"
  CASE WHEN "place" = 0 THEN 'image0.png'
 WHEN "place" = 1 THEN 'image1.png'
 WHEN "place" = 2 THEN 'image2.png'
 WHEN "place" = 3 THEN 'image3.png'
 WHEN "place" >= 4 THEN 'image4.png'
  END "ribbon"
FROM "Results"

However I have two issues with that. The first is that the "Ribbon" 
field probably won't contain the image from the current directory but 
will instead just contain the text. The other is that Base complains 
about a SQL syntax error when I try to save it.


Can anyone help me move forward on this?


--
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: Downloads impossible and latest version of Firefox not recognized by captcha, connclusion: service level zero

2016-10-10 Thread Pedro
Hi Jurriaan

You can get any version you like from
http://downloadarchive.documentfoundation.org/libreoffice/old/

or simply the latest at
http://downloadarchive.documentfoundation.org/libreoffice/old/latest/win/

These files are guaranteed to be in working conditions. If you can not get a
working file from this server then you need to look for the problem
somewhere else (maybe your antivirus?)

I suggest that you use a download manager such as the FLOSS Free Download
Manager (http://www.freedownloadmanager.org/) to make sure your download is
100% complete.

Hope this helps!



--
View this message in context: 
http://nabble.documentfoundation.org/Downloads-impossible-and-latest-version-of-Firefox-not-recognized-by-captcha-connclusion-service-levo-tp4196366p4196467.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Downloads impossible and latest version of Firefox not recognized by captcha, connclusion: service level zero

2016-10-10 Thread Tanstaafl
The problem is can not be with LibreOffice in general - if it was, this
list would be aflame with complaints.

I have been downloading MSI's since the very first Libreoffice release,
and have never had a problem.

Maybe you are being directed to a mirror that has bad MSI files?

Another likely culprit is either an Antivirus program or a firewall or
other security filtering device interfering with the download.

But the fact is, if the MSI's hosted on the download mirrors were bad, I
wouldn't be installing 5.2.2 on our workstations here right now.

I repeat, I have NEVER had a bad MSI, and the same goes for most of the
people here.


On 10/9/2016 12:23 PM, Jurriaan Nijkerk  wrote:
> Hi there,
> 
> I'd like to file serious complaints about Libre Office.
> 
> A. The downloads
>   We've been users for several years of Open Office. When Libre Office 
> started as a fork, we decided it was a wise thing to go on with Libre 
> Office. We don't had any complaint about it until version 5.1.5 It 
> was'nt possible to download a proper MSI file. We tried different 
> mirrors, like Nluug.nl, Ut.twente.nl, mirrors.supportex.net and 
> tu.chemnitz.de . All downloads were corrupted.
> 
> We tried this with machines from two private networks, about  6 laptops 
> and 4 workstations. With Vista 32 , win7 32 and 64, with win10 32 and 64.
> 
> After this we tried 5.2.2 with the same result.: statements like "this 
> is not a valid msi file", corrut installation file  or an halfway cut 
> off installationprocedure. We tried to upgrade five times since the 
> release of 5.2.2 on juli 28.
> 
> We asked for help, the aswers came: Something like "you don't have the 
> appropiate drivers or maybe an update of Win10 or bullshit like that.
> 
> So  we installed version 5.1.4.2 again, a version  without those 
> kindergartenbugs.
> 
> We're not the only people who experienced the bug, there are more who 
> have encountered this one.
> 
> B.
> The community login.
> I tried again to log in on the Q and A site of the community. And then, 
> the captcha widget didn't work. The program told us to use an updated 
> browser. Very intelligent, maybe someone can tell me where to get a 
> newer version of Firefox 49.0.1 ?
> 
> My question is: How about quality control? Because if all stays the same 
> we, and without any doubt a lot other users, will look for an alternative.
> 
> Imho, it would  be a shame if this doesn't change. There's a lot of 
> volontary work done, done by the people of the community, wich will go 
> through the drain. I would call this respectless...
> 
> 
> grtz,
> 
> 
> 


-- 
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] Downloads impossible and latest version of Firefox not recognized by captcha, connclusion: service level zero

2016-10-10 Thread Kruno

09.10.2016 u 18:23, Jurriaan Nijkerk je napisao/la:



After this we tried 5.2.2 with the same result.: statements like "this 
is not a valid msi file", corrut installation file  or an halfway cut 
off installationprocedure. We tried to upgrade five times since the 
release of 5.2.2 on juli 28.


I experienced similar problem: wasn't able to download complete 
installation file from mirror that website was offering me by default. 
Download would stop at 6 megabytes.


I have two computers with GNU/Linux and I needed two different 
installation packages. Once I was able to download LibreOffice by 
manually changing mirror. Next time I had to download via torrent 
because no mirror was working.


That is for 5.1.5, haven't tried since.

Kruno


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