Stack Overflow
Stack Overflow

Questions tagged [libreoffice-base]

Libreoffice Base is a standalone database/form application which allows you to manage data organized into tables.

Libreoffice Base is a standalone database/form application which allows you to manage data organized into tables.

The official documentation can be found on the Libreoffice documentation page

177 questions
1
vote
2 answers

Import images into libreoffice base database without using a form to manually import individual images

I have a LibreOffice Calc spreadsheet that contains the following fields to generate student admit card. Roll number Name Semester Passport sized photograph and other fields.. The 4th field contains the absolute path of the images. How can I print…
Somnath Rakshit
  • 555
  • 1
  • 6
  • 17
1
vote
3 answers

nested ORDER BY in SQL statement in LibreOffice Base

In LibreOffice Base I want to, as reduced example, query the following: SELECT * FROM ( SELECT "ROWname" FROM "TABULARname" ORDER BY "ROWname" ); The Error statement is: Cannot be in ORDER BY clause in statement…
DoJo
  • 13
  • 2
1
vote
1 answer

Updating database table with macro using data from form

I have a form in Libreoffice Base which is connected to the "Songs" table (basicaly db of music) and what I want to do is everytime I check/uncheck the CheckBox on that form I want the field "Played" of every record with the same name and Author as…
Grzegorz Zieliński
  • 17
  • 1
  • 6
1
vote
0 answers

libre office subversion keyword formatting

I save my Libre Office documents in fodt format and store them in Subversion (SVN). I have set svn keyword properties on the file. The $Revision:$ tag is correctly replaced by eg. $Revision: 2000$ after a commit. Now the $Revision: 2000$ text is not…
Dinne
  • 11
  • 1
1
vote
1 answer

LibreOffice Basic get Elements from form

I'm trying to get value from textfield on the form. sub Test(oEv) oForm = oEv.Source.Model.Parent textBox = oForm.getByName("Description") MsgBox textBox.Text end sub There is an Exception: "Type: com.sun.star.container.NoSuchElementException" on…
Kiryl Tkach
  • 3,118
  • 5
  • 20
  • 36
1
vote
1 answer

Libre Office Base error while creating new DB

I have Libre Office 4.3, recently installed 5.1 (thought it would help). On top of that I have java oracle 7 and 1.8.0 java openjdk. Whenever I try to create a new db via the db wizard, in all cases i get the same errors: The connection to the data…
Anamed
  • 109
  • 1
  • 1
  • 8
1
vote
1 answer

LibreOffice Base JDBC connection to Hive returns “Method not supported” when executing valid select statement

I'm trying to get LibreOffice's Base v5.1.4.2, running on Ubuntu v16.04 to connect to a Hive v1.2.1 database via JDBC. I added the following jars, downloaded from Maven Central, to LibreOffice's classpath ('Tools -> LibreOffice -> Advanced -> Class…
Alex Woolford
  • 4,433
  • 11
  • 47
  • 80
1
vote
0 answers

LibreOffice Base Form Error with PostgreSQL Autogenerated UUID Primary Key

I have a PostgreSQL 9.5 back-end and with LibreOffice Base v 5.1.3.2 (x64) I am trying to create some data entry forms for various tables all with 1:many relationships. These tables all have UUID auto generated primary-keys. LibreOffice does not…
Phillip Allen
  • 11
  • 2
1
vote
1 answer

Graded Assignment [Zaption] Database

Most specifically, I'm having trouble returning from LibreOffice Base [HSQLdb] a list of grades organized by (1) class, (2) assignment, (3) student's last name. I want this output so I can run a script to copy the grades from the database to an…
M. Gruben-Trejo
  • 126
  • 9
1
vote
1 answer

Get database from LibreOffice Base with python

I would like to make a Database editable with LibreOffice Base and usable with python. I can't find a way with the normal HSQLDB as it requires Java (I would as less as possible dependencies) and the same thing with SQLite3 as it requires the…
Lumachina
  • 51
  • 1
  • 8
1
vote
1 answer

How do I go to Design View after directly editing SQL in LibreOffice Base

I'm toying with the idea of migrating an office from Access 97 to LibreOffice 5. The problem is that the people in the office use the Designer in Access for Queries. They have made it clear that they won't learn SQL and as such as the IT I have to…
Kayot
  • 582
  • 2
  • 20
1
vote
1 answer

OpenOffice / LibreOffice Base SQL Group By

I have a small LibreOffice database with customer data and invoices. Each invoice consists of n items. Customers: ********************** * ID * Name * Adress * ********************** * 0 * N1 * A1 * * 1 * N2 * A2…
Thomas Sablik
  • 16,127
  • 7
  • 34
  • 62
1
vote
1 answer

Possible to change PostgreSQL table design using LibreOffice Base?

I read that LibreOffice Base has a native Postgres driver, so I thought that might be a good way to play around with the database structure, creating new tables, altering and dropping existing ones etc. Almost everything seems to work fine. I can…
vic
  • 292
  • 3
  • 14
1
vote
1 answer

Create field constraint based on another table field in LibreOffice Base

I have 3 tables, "Courses"(id, start_date), "Subscriptions"(id, assistant_id, course_id, date) and "Assistants"(id, registration_date). Subscriptions reference Courses and Assistants with foreign keys as you see. I need to add CHECK constraint that…
I Hafid
  • 373
  • 2
  • 13
1
vote
2 answers

Merge information to one line

I have a big spreadsheet with a lot of values such as 'phone, mail, mobile and so on but the application where I get this from gives me only one of those values per line. For example: if one one contact has three ways to communicate it produces…
mokkin
  • 13
  • 3
1 2 3
…
11 12