Ask Your Question

dougmn's profile - activity

2020-05-07 02:52:48 +0200 received badge  Taxonomist
2020-04-16 13:50:33 +0200 received badge  Notable Question (source)
2020-03-31 18:32:03 +0200 received badge  Notable Question (source)
2020-03-29 00:11:14 +0200 received badge  Popular Question (source)
2020-03-18 18:55:14 +0200 marked best answer How can I install 2 additional spell-check dictionaries

My LibreOffice came with the English (UK) dictionary pre-installed. I would like to install and use the dictionaries for English (USA) and Spanish (Mexico). How do I download and install these two additional dictionaries?

Version: 6.3.5.2 Build ID: 1:6.3.5~rc2-0ubuntu0.18.04.1~lo1 CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded

2020-03-18 18:55:10 +0200 commented answer How can I install 2 additional spell-check dictionaries

Thank you Opaque. Initially the newly installed dictionaries did not show up, but then I remembered to restart LO, and t

2020-03-18 17:16:34 +0200 commented answer How can I install 2 additional spell-check dictionaries

Thank you Opaque. I ran the commands in the terminal, but it seems there must be an additional step to make them availab

2020-03-18 14:57:52 +0200 received badge  Critic (source)
2020-03-18 14:05:45 +0200 received badge  Popular Question (source)
2020-03-03 02:41:57 +0200 received badge  Famous Question (source)
2019-12-03 04:56:42 +0200 received badge  Notable Question (source)
2019-11-25 15:11:43 +0200 commented answer Is there a way to automatically save a database?

"I have not seen any method to "automatically" save items in a Base file." How writing a "save everything" macro, which

2019-11-25 14:49:31 +0200 received badge  Popular Question (source)
2019-10-03 16:46:53 +0200 received badge  Notable Question (source)
2019-09-22 22:13:56 +0200 commented question How do I edit a resume I have Libre Office? my pc I have dragged and dropped resume but can not edit resume?

If you google "pdf to text" you will find a number of sites where you can make an editable file from your .pdf document.

2019-09-21 16:18:32 +0200 commented question How do I edit a resume I have Libre Office? my pc I have dragged and dropped resume but can not edit resume?

Or there be a web-site somewhere that would convert your jpeg to text. Similarly to scanning your document, you'd probab

2019-09-21 15:58:15 +0200 commented question How do I edit a resume I have Libre Office? my pc I have dragged and dropped resume but can not edit resume?

Do you still have the printed resume? As far as I know, editing the text from a jpeg file would be impossible. But if yo

2019-09-21 15:52:41 +0200 commented answer how to filter on boolean fields in Firebird

Yes, including the "unknown" values would make it more complex. It could probably be solved with an additional line of c

2019-09-21 15:40:04 +0200 received badge  Popular Question (source)
2019-09-21 15:32:22 +0200 commented answer how to filter on boolean fields in Firebird

Yes, including the "unknown" values would make it more complex. It could probably be solved with an additional line of c

2019-09-21 05:35:54 +0200 received badge  Self-Learner (source)
2019-09-21 05:35:54 +0200 received badge  Teacher (source)
2019-09-21 04:59:05 +0200 marked best answer how to filter on boolean fields in Firebird

I'm experimenting with migration of a database to Firebird from HSQLDB. I have a personal accounting database with a boolean field "Deductible." When filtering for reports, I want to be able to select one of the following options:

Only decuctible (Deductible field = TRUE)

Only NOT deductible (Deductible field = FALSE)

ALL records (Dedcutble field is either TRUE or FALSE)

I have a 1 record table for my filtering criteria, selecting for dates, expense category, as well as the deductible field. I use a form to update this table. A query based on the data table and the criteria table is the basis for reports.

With HSQLDB I could use integer values to filter for boolean fields, but this doesn't seem to work in Firebird. How do I set up my criteria table and form to filter for the three options I want above? The "ALL records" option is what I don't know how to select for.

2019-09-21 04:58:47 +0200 edited question how to filter on boolean fields in Firebird

how to filter on boolean fields in Firebird I'm experimenting with migration of a database to Firebird from HSQLDB. I ha

2019-09-21 04:58:07 +0200 answered a question how to filter on boolean fields in Firebird

Okay, I'll answer my own question. I suppose writing it out, and then having some time to (not) think about it helped.

2019-09-20 20:14:45 +0200 asked a question how to filter on boolean fields in Firebird

how to filter on boolean fields in Firebird I'm experimenting with migration of a database to Firebird from HSQLDB. I ha

2019-09-16 18:49:24 +0200 received badge  Notable Question (source)
2019-08-05 14:00:30 +0200 received badge  Notable Question (source)
2019-07-01 20:25:08 +0200 received badge  Famous Question (source)
2019-06-26 00:39:28 +0200 commented answer Missing macros

In regard to the incorrect date display, I just found that the format example for the date field was not set in the tabl

2019-06-25 23:48:23 +0200 received badge  Popular Question (source)
2019-06-25 23:43:48 +0200 commented answer Missing macros

In regard to the Snap version, at the time I installed it, it was the only version I could get in which everything worke

2019-06-25 23:42:34 +0200 commented answer Missing macros

It was one macro, so I just replaced it. There is one other issue, in one of my forms, the date format in a pattern fiel

2019-06-25 18:25:48 +0200 commented question Missing macros

Version: 6.2.4.2.0+ Build ID: libreoffice-6.2.4.2-snap1 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;

2019-06-25 18:24:59 +0200 asked a question Missing macros

Missing macros On some of the forms in my database, I have a macro which causes the form to go to a new record when open

2019-06-25 05:26:34 +0200 received badge  Famous Question (source)
2019-06-19 08:23:20 +0200 received badge  Popular Question (source)
2019-06-19 05:02:05 +0200 received badge  Famous Question (source)
2019-06-19 05:01:04 +0200 commented answer All my forms have become small

Thanks. Changing the zoom back to 100% fixed it. I do suspect that having reduced the zoom in writer at some point affec

2019-06-19 04:59:28 +0200 marked best answer All my forms have become small

I have a database that I use occassionally. When I opened it today and tried to open a form, I got a message that the JRE was missing. I resolved that, and when I opened the form, everything (fonts, all the controls) was way smaller than it should be. I checked the other forms for the database, and this happens with all of them. Also, on some of them I have a macro which causes the form to go to a new record when opened, and now I am getting error messages that the script could not be found.

Any ideas about what happened, and how to fix it?

2019-06-18 20:07:27 +0200 commented question All my forms have become small

Version: 6.2.4.2.0+ Build ID: libreoffice-6.2.4.2-snap1 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;

2019-06-18 20:06:48 +0200 asked a question All my forms have become small

All my forms have become small I have a database that I use occassionally. When I opened it today and tried to open a fo

2019-06-09 01:22:24 +0200 commented answer Changing from PDF to normal LO text document for editing

Please excuse my question not directly related to the original question. @music-music, what Linux application will let y

2019-05-08 11:37:50 +0200 marked best answer How to fix missing java problem in base

I just opened a database file that I had not opened for a few weeks, and got this message:

"The LibreOffice configuration has been changed. Under Tools - Options - LibreOffice - Advanced, select the Java runtime environment you want to have used by LibreOffice."

The path that's offered when I go to "Tools - Options - LibreOffice - Advanced" doesn't contain a Java runtime environment.

When I try to open any of the forms or reports, I get this message: The connection to the data source “DatabaseName” could not be established. No Java installation could be found. Please check your installation.

Writer is working okay. I use it all the time.

Here's my the info on my installation:

Version: 6.2.1.2
Build ID: libreoffice-6.2.1.2-snap1
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); UI-Language: en-US

How do I fix this? Where can I find the lost JRE?

2019-05-02 11:17:13 +0200 received badge  Famous Question (source)