[libreoffice-users] Re: libsdlo.so - SliTaz GNU/Linux - avahi
Here is the work-around I use in order to run LibreOffice 6.0.6 on my Linux system which does not have Avahi. This fixes the problem with Draw and Impress not starting. I have not tested it with 6.1 but it probably works. 1. Place the following single line in a file "libavahi-client.c": int avahi_client_new(void) { return 0; } 2. Place the following single line in a file "libavahi-common.c": int avahi_threaded_poll_new(void) { return 0; } 3. Compile the two files into shared libraries by typing the following at shell prompts (or place them into a script or Makefile): gcc -c libavahi-client.c libavahi-common.c gcc -shared -o libavahi-client.so.3 libavahi-client.o gcc -shared -o libavahi-common.so.3 libavahi-common.o 4. Copy those 2 shared libraries into the LibreOffice program directory. The path below is for 6.0.x installation using the downloads from the LibreOffice site. Adapt it to your system as necessary. This probably needs to be done as root (but there are alternatives such as using a different directory and the LD_LIBRARY_PATH environment variable). cp libavahi-*.so.3 /opt/libreoffice6.0/program/ That's it. Draw and Impress should work fine now, with one exception: do not try to use Impress remote control. That's the only thing that really does require Avahi. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Re: libsdlo.so - SliTaz GNU/Linux - avahi
Hi, Thank you for your answers. But no solutions... lj, could you explain the 'hack' methode you used ? -- Cédric Radosavljevic Le ven. 12 oct. 2018 à 05:06, lj a écrit : > Cédric Radosavljevic wrote: > > Hello, > > > > My OS is SliTaz GNU/Linux (rolling - 32 bits) and my laptop is an old > > Asus Eee PC 900. > > > > I installed LibreOffice 6.1 (Package manager ==> get-LibreOffice ==> > > Terminal ==> get-LibreOffice). > > > > Installation OK (after 40 min). > > > > No problems with LibreOffice Writer, Calc, Math, Base. > > > > But 2 problems: > > > > 1/ > > LibreOffice Impress doesn't start (and no error message). > > > > 2/ > > Error message for LibreOffice Draw: > > > --- > > Component cannot be loaded, possibly broken or incomplete installation. > > Full error message: > > > > loading component library > > failed. > > > --- > > > > Here I found an explication for this problem: > > https://bugs.documentfoundation.org/show_bug.cgi?id=119408 > > > > There is a dependency to 'avahi' on recent LibreOffice versions but no > > package 'avahi' available on SliTaz. > > > > Anyone a solution? > > ... > > > Hi, I'm the author of that bug report. I have a 'hackish' trick I used in > order to run LibreOffice 6.0.6 on my Linux system which does not have > Avahi. > It involves compiling two 1-line C programs to make fake shared libraries. > It works with 6.0.x and I expect it would work with 6.1.x too but I haven't > tested it. Would anyone like me to post instructions? > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Summing currency fields in base
Perhaps you need to begin over as far as you fields are concerned. First of all, you only need two fields in the table: Fee1 and Fee2. You also need a primary key which is listed first. Fee1 and fee2 need to be given the properties you want for them. The primary key has to have "entry required" selected. I prefer it to also have this property: INTEGER. Save the table. When I did this, I named the table, Currency, and the primary key, ID. Second, create a query in SQL View. Use this SQL statement: SELECT "ID", "Fee1", "Fee2", "Fee1" + "Fee2" AS "Total" FROM "Currency" Save the query giving it a name other than Currency. (You can not have a table and query with the same name.) Running the query, the ID field has . You can not enter values for Fee1 and Fee2. Typing after entering values for Fee1 and Fee2 will place the sum in the Total column. Now you can either use the Form wizard to create a form from the query or use Girvin's suggestion for connecting your present form to the query. Dan On 10/13/2018 07:07 AM, Adam Fenn wrote: On 11 Oct 2018, at 23:39, Girvin Herr wrote: I am not sure where you are wanting this total. I want it in the same form as fee1 and fee2. First, you need to create a query, I'm familiar with this. Then you need to have your form attach itself to the query rather than the table. You do this by opening the form in "Edit" mode and selecting the "Form" icon. At this time, you should have a popup called "Form Properties". Select the "Data" tab and in the "Content type" list select "Query". Then select your new query in the "Content" list. Then you can add the new "Total" field to your form. When I try to add the field using the Add Field icon LO crashes without fail. Is there a way around this? Thank you for your help Girvin. On 10/11/18 11:39 AM, Adam Fenn wrote: I have three currency fields - 'Fee1', 'Fee2' and 'Total'. How do I add fee1 and fee2 together and put the result automatically into the Total field? TIA Adam. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Summing currency fields in base
> On 11 Oct 2018, at 23:39, Girvin Herr wrote: > > I am not sure where you are wanting this total. I want it in the same form as fee1 and fee2. > First, you need to create a query, I'm familiar with this. > Then you need to have your form attach itself to the query rather than the > table. You do this by opening the form in "Edit" mode and selecting the > "Form" icon. At this time, you should have a popup called "Form Properties". > Select the "Data" tab and in the "Content type" list select "Query". Then > select your new query in the "Content" list. Then you can add the new "Total" > field to your form. When I try to add the field using the Add Field icon LO crashes without fail. Is there a way around this? Thank you for your help Girvin. > On 10/11/18 11:39 AM, Adam Fenn wrote: >> I have three currency fields - 'Fee1', 'Fee2' and 'Total'. How do I add >> fee1 and fee2 together and put the result automatically into the Total field? >> >> TIA >> Adam. > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy