Questions tagged [libreoffice-base]

Database front end and management tool of the LibreOffice suite

Filter by
Sorted by
Tagged with
1
vote
0answers
25 views

Open an Access database in LibreOffice Base

I try to open a access database in LibreOffice Base First, I installed LibreOffice sudo apt-get install libreoffice Then I downloaded UCanAccess (http://ucanaccess.sourceforge.net/site.html) and ...
0
votes
0answers
8 views

Trying to use code countif+countif/countblank

I tried couple of things but everything gives me an Error, does anyone know why? =COUNTIF(COUNTBLANK(A12:D12),0) But when I try to put them in two different cells it actually works =COUNTBLANK(A12:D12)...
0
votes
0answers
49 views

Libreoffice draw forms: how to auto populate combo boxes from linked database

I am currently working on a pdf form in libre office draw that I will use on a website. The form inputs amongst other things “department”, “address”, “phone number”, etc in combo boxes. For the about ...
0
votes
1answer
400 views

Importing big bunch of files to LibreOffice Base table in one shot

I have table like this: and a bunch of CSV files like this: in per-patient directories. Please note that I need to take a Patient field from path name and Date from file name (as you see). What is ...
0
votes
3answers
552 views

LibreOffice Base Primary Key of several columns?

I have created a database with one table like this: How to create a primary key like: (Patient, Date, Test, Parameter) ? The database will be holding data for numerous patients examined multiple ...
0
votes
1answer
1k views

How to dynamically update a LibreOffice spreadsheet from file?

I have a CSV file with data I want in a spreadsheet - mostly to display a chart based on it. I also want the chart to be updated every time the file is rewritten by a console application. What I tried ...
1
vote
0answers
82 views

Libreoffice base combo box populating text boxes

I am using Libreoffice Base 4.2.8.2 on Zorin OS 9 I need a combo box (Business names) which will fill in text boxes text box 1 (Address)text box 2 (Phone) text box 3 (email) etc. It must be a combo ...
1
vote
1answer
720 views

Set background color in LibreOffice base form

The title pretty much says it all. I am trying to create a form in design view in LibreOffice and I can't see any control that allows me to set the background color. I've seen some old answers to ...
0
votes
1answer
456 views

Subtracting two times in libre office base

How can I subtract two times in a query in libre office base? For instance, 10:30 - 9:00 should give 1:30. Thanks. EDIT: As it says in the question, I am having this problem in "base", not with the ...
0
votes
1answer
21 views

Query that needs input from two different records

I have a "timecard" table. A few typical entries might look like ID task date start time 1 proj_XDFR 4/5/18 8:30 2 proj_PEIRN 4/5/18 9:45 3 proj_ERU54 ...
1
vote
1answer
47 views

Libre Office form — need data sheet layout with a lookup field

I am trying to develop a timecard form. The fields are ID, task, date, start time, and stop time. I want to create the form as a datasheet. I don't know the specific name for this, but I want it to ...
0
votes
1answer
406 views

Sync sheets in Libreoffice

Hopefully someone can help. I have an eccommerce dropship website on Woocommerce which I update via CSV using WPAllImport. I currently download a CSV Spreadsheet from my supplier which contains ...
1
vote
1answer
469 views

Cannot edit imported data in Libreoffice Base

I am using Libreoffice Base for my International GCSE ICT exam. I am practicing with past papers, but I can't get it to work. The files provided come as separate csv files, which have to be imported. ...
2
votes
2answers
5k views

Libreoffice Base: Need today's date as default value in a form field

New to libreoffice Base. I've found how to set the default value in a table to the current date. Now I need to have the current date show up in the corresponding field in a form. I have tried ...
0
votes
1answer
1k views

How to add a datasheet-style (grid) form/field in LibreOffice Base design view?

When creating a LibreOffice Base form via the Wizard, it is possible to choose a 'datasheet' style for the selected fields. The fields become part of a Mainform_Grid and/or Subform_Grid item if you ...
3
votes
2answers
1k views

LibreOffice 5.2.2.2 won't run without Java

I am trying to get LibreOffice to work with my Mac. We are trying to use the database application, but keep getting asked to install Java so it can connect to the tables. I have installed Java and ...
1
vote
0answers
26 views

LibreOfficeDev5.3 on Ubuntu 16.04 does not save modified forms

I've installed LO dev 5.3, because I need direct SQL to work, which I read was fixed in this version, but now I'm facing the issue that I can't edit any forms anymore. I can create new forms using the ...
2
votes
1answer
4k views

Populate foreign key using combo/dropdown on form

I'd like to populate a foreign key field in one table using a combobox/dropdown where the values the user sees are not the IDs but a description field from the foreign table. Consider the following ...
0
votes
1answer
198 views

modify a view that other views depend on

I use LibreOffice Base to create weekly reports. I have one table (named time_spent) that contains a lot of normalized data, and I am using views to do the processing required to produce the reports I ...
1
vote
0answers
337 views

LibreOffice Base sub form with multiple rows displayed

How do I show multiple lines in my sub-form? For example, my main form is a prospect, with the sub-form recording and displaying one or more activity. After creating the sub-form, only one line is ...
1
vote
0answers
155 views

How to print a LibreOffice Base Relation Design?

I've gone to the trouble of creating a graphic representation of my database design using Relation Design tool in LibreOffice Base. How can I print that out/export it to a PDF to share with others, ...
0
votes
1answer
41 views

OpenOffice showing syntax eror

Here's what I have so far: SELECT DISTINCT Min("gpa"."current_gpa"), "students"."lastname", "students"."firstname" FROM "students", "gpa" WHERE "students"."...
3
votes
0answers
5k views

Libreoffice Base: How have a combobox linked to a related table linked to or in the form table control

I could not sum up, what I really want in the title. But here I am going to try to explain what is it about. I have switched from MS Access to Libreoffice Base because it is open source, free and ...
1
vote
1answer
668 views

How to use data contained in several related database tables for a form letter?

I want to create a form letter with LibreOffice Writer. The data is contained in a LibreOffice Base database, in several tables. I followed the guide Creating a Form Letter. It seems that I can only ...
1
vote
2answers
2k views

Can LibreOffice Base directly use MySQL syntax?

From what I can see, LibreOffice Base comes with an HSQLDB implementation by default. I understand that ODBC allows users to connect to different data sources, including databases that use different ...
0
votes
2answers
2k views

Is it possible to put a wildcard search into a parameter query in LibreOffice Base?

I am using Base in LibreOffice 4.0 (still using the HSQL that comes with Base but looking at moving to HSQL 2.2.8) and I would like to do a query that asks for parameter input like: SELECT * FROM "...
0
votes
1answer
764 views

Trouble connecting to LibreOffice Base database in split database mode using HSQL 2.2.8

I am trying to install a split database (starting with a file copy) using an upgrade to HSQL 2.2.8. I got HSQL 2.2.8, and have followed the instructions from another post on this site ( How to set up ...
3
votes
1answer
12k views

How to set up the jdbc driver to connect to hsqldb from libreoffice?

I am trying to "split" a LibreOffice .odb file into a HSQL database and an OpenOffice document containing forms and macros. I am trying to follow the instructions from this thread: Within a few ...
2
votes
0answers
850 views

How to represent m:n relationships in a form in Libre Office base?

I have an embedded database in Libre Office. I am building a form in it, and got into a problem. I have a table called "Author" and another table called "Publication", connected by a third table "...
1
vote
1answer
594 views

Postgresql is not avaible in Libreoffice Base

I want to edit a postgresql base using libreoffice-base. When I launch the database wizard of Libreoffice-base, I am blocked at the first step: I can select an existing base, but the only ones ...
1
vote
2answers
1k views

No option to print LibreOffice Base document

My husband is trying to print out a document he has produced in LibreOffice Base. Unfortunately there is no option to print and we have tried everything we can think of. Bit of a Luddite so please ...
1
vote
1answer
3k views

How to use CREATE TABLE queries in LibreOffice Base?

I'm using LibreOffice 3.5.4.2 (from Ubuntu 12.04 packages) and trying to create tables using SQL's CREATE TABLE statement. For the first few attempts I got a message saying that the query must be a ...
0
votes
1answer
3k views

Libreoffice Base: combobox keeps replacing value to 0

I have a ComboBox which loads a country list, every time i select one item and then focus in other object of the form it resets to 0. This ComboBox is linked with an Integer value in the main table (...
0
votes
1answer
4k views

Can LibreOffice Base odb databases migrate to SQL server?

If I make a LibreOffice Base database in its native ODB format, is it possible to later migrate the database to a SQL server such as PostgreSQL??? If so, how? Thanks!
18
votes
2answers
39k views

How do I connect to a PostgreSQL server using LibreOffice Base?

I'm running into errors when I try to connect to a PostgreSQL server on the local machine using LibreOffice Base 3.5 (this applies to LibreOffice 4 as well): The following syntax (localhost:5432=<...
2
votes
0answers
292 views

Querying DB2 view from Libreoffice Base

I've created a view in DB2 that has the information I need for labels that I was hoping to print out from LibreOffice. When I query the view from the console ("SELECT * FROM ADDRBOOK.LABELS"), I get ...
0
votes
2answers
3k views

Dynamic Filtering on LibreOffice Base Reports

Is it possible to do a Dynamic Filtering on LibreOffice Base Reports?
7
votes
2answers
3k views

Insert a field at a specific position

In a LibreOffice Base document, the sequence of fields in a table definition is important[0]. But when I ask the “Table Design” dialogue to insert a field, or to paste a row from the clipboard, it ...