Create a new embedded HSQLDB.
Try running the CREATE statements of your script file. If this works, you get all the tables, relations and indices.
Copy the data.
Copy queries forms and reports.

This is a backup script for Windows which safely backups the database without stopping the service. Adjust the absolute paths and names. Start it from the Windows task scheduler. REM Backup one database SET DBN=MyDatabase SET HOST=192.168.1.1 SET BDIR=E:\hsql\database\backups\ SET URL=jdbc:hsqldb:hs...

LibreOffice only: =REGEX(A1;"([^[:alpha:]])+")

=ISNUMBER(FIND("1920";A1))

OpenOffice is walking dead. Replace it with LibreOffice which is the actively maintained successor to OpenOffice but still very much like OpenOffice. https://www.libreoffice.org/discover/libreoffice-vs-openoffice/ Anything related to macros does not require any Java. There is hardly anything in Libr...

Just open the database document and open the form(s).

Forget the database.

This office suite comes with a database component.

Find/Replace % with nothing and you get the decimal cell value.

Any operation with a Null value returns Null.

Embedded HSQL does not have a DateAdd function like most other database engines have. As a work-around, you can calculate the day fractions and add them as you would do in a spreadsheet. A formatted control on a form or report can display this value as a time. SELECT *, Hour("Time")/24 + M...

Tools>Options>Calc>"Expand references when rows/columns are inserted " = ON Now you can insert new cells anywhere within or directly below the referenced range and all references in formulas, names, charts, conditional formatting etc. will expand automatically. With that setting turned off...

Hi guy, Didn't you notice that the user can merge emails simply by activating the Option menu? Is your extension by the way really necessary? Regards Nick In the LibreOffice options, you can specify your outgoing SMTP Server with log-in credentials. However, this feature is broken currently. You ca...

Annotations are special types of TextFields. MRI records the following: [Tutorial] Introduction into object inspection with MRI

psilocybe wrote: ↑Wed Mar 06, 2024 4:38 am You have to install by hand...

Can I simply replace the old jars with the niew ones?
Why does the old version install cleanly but not the new one?

Trying to update from 1.1.5 to 1.2.2 on Version: 24.2.0.3 (X86_64) / LibreOffice Community Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1 CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: x11 Locale: de-DE (de_DE.UTF-8); UI: en-US Calc: threaded Error while installing extension jdbcDriver...

Hello Sir, I've seen for myself. Please find enclosed test file. Regards Nick Your column A uses the default locale, which is German(Germany) in my case and the dates are displayed like 31.12.99 here. If your default locale is English(UK), 31/12/99 might be the displayed date. Column B uses English...

How to filter by criteria in form controls without any macro: http://forum.openoffice.org/en/forum/do ... p?id=11663 (search this forum for "power filtering").

LibreOffice canceled the integer dates and times in favor of date and time structs.

The attachment has no formula. Calc Guide Chapter 8 - Using a Pivot Table

LOOKUP in LO Calc It's the same LOOKUP function since the very first version of Visicalc in the year 1979 and successive spreadsheet applications such as Lotus 1-2-3, Excel and Calc. LOOKUP never did what most users expect it to do. In your specific example =CODE(D1)-43 returns a correct result wit...

By the way, "OOo" in the name jdbcDriverOOo is misleading for two reasons. "OOo" refers to the product "OpenOffice.org" which was named after the website hosted by Sun Microsystems. - Since 2011 the product name is Apache OpenOffice (AOO). - Your package is incompatible...

Somehow, the Thunderbird application grabs all access rights, no matter if it is started before or after LO Base. The Base frontend gets into some "frozen" state when TB is running. My problem is, that I can not open the database in read-only mode, so it does not interfere with TB in any w...

Great job. This driver allows me to access the contacts database of the Thunderbird mail client without too many issues. Can you tell me if it is possible to establish a read-only connection? If I load the database document after the Thunderbird client, the database is locked (does not show any tabl...

The locale is the relevant setting. You can set it for the entire office document, for cells and cell ranges, text fields, for anything numeric in templates for documents. How to enter a date in a spreadsheet cell (Calc, Excel and others): 1/ enters the first day of current month 1/2/ enters this ye...

open_mike wrote: ↑Tue Feb 06, 2024 7:49 pm To recap, my goal is to have the answer field in Table1 populated with the results of value1 + value2

Makes no sense. Why do you store a calculation result? When you change value1 or value2, the stored sum will not update.

Use a document template.

One-to-many and many-to-many relations in tables, queries and forms with subforms and lisboxes.: download/file.php?id=11250