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
0
votes
1 answer

autoopen macro in LibreBase, after upgrade to last Kubuntu

With the advice I received in fine tuning a goto bookmark libreoffice macro and here too, I had successfully created a macro that in LibreWriter went to the last point where the cursor was at the end. After upgrading from Kyubuntu 17.04 to Kubuntu…
Duns
  • 1
  • 4
0
votes
1 answer

Getting a button from Macro in Base (Libreoffice)

I'm trying to create a simple macro to control two buttons that have been placed in a form. They alternate positions, so they can be left pressed or unpressed, and the objective is to have only one of them pressed. My idea was to execute a macro…
Xabi Linazasoro
  • 59
  • 2
  • 13
0
votes
3 answers

LibreOffice Base V5.3.2.2 - Equivalent to Access IIF

I'm new to Base and trying to convert a simple MS Access query: Box:IIF([Archive_Loc] like '**ox*','B') I'm using casewhen("Archive_Loc" = '%ox%','B') but I can't seem to figure out how if I can use LIKE instead of = which obviously doesn't give me…
user1737416
  • 35
  • 4
0
votes
1 answer

Relational database design for hierarchical data?

I am a trying to design a database to act as a language dictionary where each word is associated not only to its definition by also to its grammatical "taxon". E.g., it should look something like this: "eat": verb.imperative "eat":…
Tfovid
  • 761
  • 2
  • 8
  • 24
0
votes
0 answers

LibreOffice: How to create popup menu in a form?

I design an application in LibreOffice Base 5.3 using forms and Star Basic macros. Is it possible to create a custom context menu which popups on right mouse button click and is bound to datagrid in a form?
Olexandr
  • 33
  • 1
  • 6
0
votes
1 answer

using cast in sql in libre office base

I am using libreOffice Base to query an external (access.mdb) database which is predefined and cannot be altered. This is because I get a new database every day and have to create reports based on the included data. In this database on row is…
Frankk
  • 3
  • 1
0
votes
1 answer

Libreoffice soffice always trigger document recovery dialog box though no file to be recovered

I am using Libreoffice 5.2.7.2 on Ubuntu 14.04. When I do soffice --show filename.odp it always trigger document recovery dialog box even though there is no file to be recovered. After hitting ok, it will prompt me to select filename.odp to load…
Cheng Ping Onn
  • 687
  • 1
  • 8
  • 17
0
votes
0 answers

Connecting to a Libre Base database in Monodevelop

i have a librebase Database file , and i want to connect it to my monodevelop project. İ cant find which plugins i need to install or which libraries i should be using .
M.Karavural
  • 21
  • 7
0
votes
1 answer

LibreOffice Base form to edit table via query

so I stuck at one point at work. I got this table "IP". It has relations to another table. In order to see the "real name" of entity I created a query. See picture of my query of my IP table --> host / hostname I want to create a form to edit…
Sethologik
  • 1
  • 1
0
votes
0 answers

Libreoffice base - "The driver class 'com.mysql.jdbc.Driver' could not be loaded" occurs even after adding class path

I am trying to connect Libreoffice base to an already existing database. To do so, I have done the following: 1) 2) I chose the "Connect using JDBC" option, and provided the database name and server. On testing class, it shows that the driver…
mahesh Rao
  • 375
  • 1
  • 4
  • 16
0
votes
1 answer

Where to find the Base module of LibreOffice that has no row limit?

I have a file that has ten million rows. I want to open it using OpenOffice Calc but OpenOffice Calc 3.3.3 has a limit of around one million rows. If you follow this link, the answer mentioned that the Base module of LibreOffice has NO ROW LIMIT.
shiny
  • 3,380
  • 9
  • 42
  • 79
0
votes
1 answer

Current Version of HSQLDB in LibreOffice?

I was hoping to develop a small database/form application for a client, but it would require some functionality to at least auto-populate fields, but probably also trigger insertions of calculated rows into another table. I did a little homework on…
Todd Pierce
  • 161
  • 7
0
votes
2 answers

LibreOffice, SQL command with inner join

my problem is that I only know the new name of the owner of the house with id_house = 10, so this code should work. If i try to run it in LibreOffice Base, it says unexpected end INNER, requires SET statement [update "t_Owner" inner] Can you help…
robz
  • 1
  • 2
0
votes
1 answer

How do I export a LibreOffice Base database table with very small numbers? (... using scientific notation?)

https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Base tells me to export by copy and pasting into LibreOffice Calc. This works in general. But my numbers in the database are very small and best expressed in "scientific notation".…
nks
  • 41
  • 3
0
votes
2 answers

Query to calculate profits in a month

I have to tables: Incomes: | date | incomeAmount | Expenses: | date | expenseAmount | I would like to sum all my incomes in an especific month using: MONTH(date) = ? I also need to sum all my expenses in this same month Then subtract to obtain my…
MariaH
  • 331
  • 1
  • 8
  • 21
1 2 3
…
11 12