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