Re: LibreOffice Basic Programming Hardware and Software Linux and Unix by rubberman There is a lot of useful documentation on the LibreOffice web site. I would suggest you go there first: www.libreoffice.org Re: JRE for LibreOffice Hardware and Software Linux and Unix by dwlamb …never said I was not in favour of upgrading to LibreOffice 5. This is not an issue whether upgrading to …the most recent version has bearing. LibreOffice 5 like LibreOffice 4 still requires JRE or JDK to work which… have not reached that milestone yet. I upgraded to LibreOffice 5 and am still getting the same message after going… Microsoft Excel and LibreOffice of linux Programming Software Development by zelrick …,,.. etc.. So I was trying to do it in LibreOffice the LibreOffice Basic I have a hard time to understand things like… for some videos and tutorial but maybe only few using LibreOffice Basic Thank you and God Bless -zelrick Connecting to Mariadb with Libreoffice Hardware and Software Linux and Unix by dwlamb I am trying to establish a connection between LibreOffice (5.4.6.2) and Mariadb (10.1.29)/mysql.…-java-2.3.0/) * JRE is installed and enabled under LibreOffice Tools > Options > Advanced * in that Advanced tab, … and youtube tutorials, the next steps are to connect via LibreOffice Base. Using the wizard: * Connect to an existing database `… How to connect to LibreOffice database? Programming Software Development by WDrago … anything on the web about how to connect to a LibreOffice database. I am currently using the following code to connect… like to know how to change it to work with LibreOffice. [CODE]String strConnect = "jdbc:odbc:DRIVER=Microsoft Access Driver… Re: Microsoft Excel and LibreOffice of linux Programming Software Development by rubberman Your example of summing a rance of columns or rows should work with LibreOffice Calc just like it does with Excel. Have you tried that? Re: Microsoft Excel and LibreOffice of linux Programming Software Development by Stuugie I would say that you need to get acquainted with Libre Calc's IDE. There's a lot of information out there on the internets. Try starting with the basics, which you can find from Libre help - [here](https://help.libreoffice.org/Basic/Integrated_Development_Environment_IDE). JRE for LibreOffice Hardware and Software Linux and Unix by dwlamb … am trying to create databases in Ubuntu 14.04 running LibreOffice 4.4.3 and can not due to not connecting…/jvm/java-8-oracle/bin/javac 1081 manual mode From LibreOffice Menu Tools -> Options -> Advanced the following is chosen… Re: Connecting to Mariadb with Libreoffice Hardware and Software Linux and Unix by dwlamb I found a solution to this challenge [here](https://ask.libreoffice.org/en/question/79010/how-do-i-set-up-a-jdbc-connector-for-mariadb-or-mysql-in-base/) It was necessary to downgrade to the MariaDB 1.5 JDBC connector Re: How to connect to LibreOffice database? Programming Software Development by peter_budo LibraOffice hasn't got any database, but does provide front-end suite, Base, that let you connect to different databases. You better check the features [URL="http://www.libreoffice.org/features/"]here[/URL] Re: How to connect to LibreOffice database? Programming Software Development by WDrago … for the reply, Peter. Here's the problem: I used LibreOffice Base to create a small, 3 table database for my… Re: How to connect to LibreOffice database? Programming Software Development by WDrago I should have been more specific. I'm pretty new to databases and LibreOffice, so I didn't know how to ask the question correctly. -Bill Re: JRE for LibreOffice Hardware and Software Linux and Unix by rproffitt Isn't version 5 of LibreOffice out? Also, doesn't it take more than JDK? Some SQL? MySQL? Just pulling from memory here, did not google this. Re: JRE for LibreOffice Hardware and Software Linux and Unix by rubberman I have libreoffice 5.1.6.2 on my Mint system. Works fine with the default Java runtime. No JRE required. Re: how do i install libreoffice in Vector 7 Hardware and Software Linux and Unix by cereal … can download the **.deb** or **.rpm** file from [LibreOffice website](http://www.libreoffice.org/download/?nodetect) and convert it with **deb2tgz** or….tgz Or check in http://slackbuilds.org/ there may be Libreoffice. Bye. Re: how do i install libreoffice in Vector 7 Hardware and Software Linux and Unix by mike_2000_17 > Or check in http://slackbuilds.org/ there may be Libreoffice. Indeed, [there is](http://slackbuilds.org/repository/14.0/office/libreoffice/). If all else fails, you can always compile it from [sources](http://www.libreoffice.org/download/?type=src). LibreOffice Basic Programming Hardware and Software Linux and Unix by zelrick Hello Linux Users, I'm a new user of Linux Can someone help me out how to add code to the button that I created? and how I code in here? For example: C2:J2 will be add How I will code it in the button I created? Thank you and God Bless -zelrick Re: LibreOffice Basic Programming Hardware and Software Linux and Unix by rubberman Do you know how to program in Java? Re: LibreOffice Basic Programming Hardware and Software Linux and Unix by zelrick Hello Sir Rubberman To be honest sir I don't know how to program java but in our school we have tackle using blueJ and eclipse but now not that familiar on using java Re: Microsoft Excel and LibreOffice of linux Programming Software Development by zelrick Hello Sir Rubberman, If putting in 1 cell? yes sir but want to try it in codes like in VBA for future development of one click then all done. I have many columns and rows to do that so I want to do one click and no more manual typing of formula+cell column and row. Thank you and God Bless -zelrick Re: Connecting to Mariadb with Libreoffice Hardware and Software Linux and Unix by rproffitt I haven't done this in years but https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-usagenotes-connect-drivermanager.html had me installing the JDK rather than the JRE. I haven't looked into this for a very long time. Re: Connecting to Mariadb with Libreoffice Hardware and Software Linux and Unix by dwlamb From [https://mariadb.com/kb/en/library/about-mariadb-connector-j/](https://mariadb.com/kb/en/library/about-mariadb-connector-j/) item 4 under the Table of Contents, Requirements. There is only mention of Java. Also, I have found that although Mariadb is a fork of MySQL and is supposedly 100% compatible, for O/JDBC use don't mix-up the two. … Re: Connecting to Mariadb with Libreoffice Hardware and Software Linux and Unix by rproffitt Java Database Connectivity (JDBC). I think we don't have to cover whether or not Java is involved. I was hoping it was the old issue I ran into long ago where it didn't work at the time with the JRE but did with the JDK. Some folk lost a lot of time over that small distinction. If it doesn't apply today, that's OK. My intent was to share … Re: Connecting to Mariadb with Libreoffice Hardware and Software Linux and Unix by RuhiAngel I need to give a shot JDBC, and use it to interface with my localhost MariaDB* server. I figure the Datasource URL ought to be set to either mysql://localhost:3306/or mysql://localhost:3306/mysql. Are Datasource URL and JDBC driver class two elective approaches to set up JDBC? Re: Connecting to Mariadb with Libreoffice Hardware and Software Linux and Unix by Russell18 Thank you Re: Connecting to Mariadb with Libreoffice Hardware and Software Linux and Unix by tejal_1 That was quite uderstanding. Re: How to connect to LibreOffice database? Programming Software Development by WDrago Never mind. The solution is ridiculous. I'll use MySQL instead. Check out what a pain this is: [URL="http://digiassn.blogspot.com/2006/07/java-creating-jdbc-connection-to.html"]http://digiassn.blogspot.com/2006/07/java-creating-jdbc-connection-to.html[/URL] Re: How to connect to LibreOffice database? Programming Software Development by peter_budo You should have mentioned that you want to connect with ODB file. It would have been different matter... Re: JRE for LibreOffice Hardware and Software Linux and Unix by dwlamb Doesn't matter if it is LO 4 or 5. Java of some form is required. At the least, Java is required to use the internal database engine of LO. I am not trying to connect through a JDBC or ODBC to a MySQL database. I would need to resolve this anyway if I was connecting to an external database. Still looking and hoping for help. Re: JRE for LibreOffice Hardware and Software Linux and Unix by rproffitt OK, so you get the latest LO and watch the tutorial at https://www.youtube.com/watch?v=jWU0WdMJ2Kw What happens when you bring up that first dialog box? I have to admit that I did run into a person that refused to update LO. They were stuck in limbo for months searching for help.