Frage stellen

LKeithJordan's Profil - Aktivität

2020-09-27 13:12:41 +0100 verliehene Abzeichen  Tag-Schöpfer
2020-09-13 21:48:16 +0100 Als beste Antwort markiert Live link from Calc to Base

The other day, I found that I could create a live link from Calc to Base, and add a live link from Base to Calc. I was excited, envisioning various ways I could use this ability.

Unfortunately, I found through further research that the Calc-to-Base connection was read-only. This severely limited my field of possibilities, but I still thought I might be able to use joins and other database query features to enhance spreadsheet data handling.

Unfortunately, I found that query joins were not possible. Queries in the read-only database were limited to one table ONLY.

I have been trying to envision a viable advantage (vs using Calc or Base alone) for the ability to use this live link from Calc to Base, but so far I haven't found any. Does anyone have any ideas?

^^^^^^^^^^^^^^^^^^^^^^^ EDITS:

1) Apparently it is not clear in my question. I am using Base with Calc as the data source (NOT Firebird, HSQLDB, etc.).

2) Here is my hardware and software:

COMPUTER MSI GT780 i7 quad core processor with hyperthreading 16 GB RAM Linux 4.15.0-117-generic Mint 19 Cinnamon 3.8.9 OS (Installed on SSD) LibreOffice Version: 6.4.6.2

COMPUTER Acer Spin 5 i7 quad core processor 8 GB RAM Linux 4.15.0-20-generic Mint 19 Cinnamon 3.8.9 OS (bootable persistent USB flash drive) LibreOffice Version: 7.0.0.3

COMPUTER Acer Spin 5 (same computer as above) Windows 10 (Installed on M.2) LibreOffice Version: 6.4.5.2

2020-09-13 21:48:07 +0100 Kommentierte Antwort Live link from Calc to Base

BTW, I'm giving you the check mark. :)

2020-09-13 21:37:28 +0100 Kommentierte Frage Live link from Calc to Base

Thanks, but I seem to have found the answer to my question. It appears there is currently no viable use for this behavio

2020-09-13 14:22:08 +0100 Kommentierte Antwort Live link from Calc to Base

Your comments don't exactly match my experience in either case. I can think of several possible reasons for our differen

2020-09-13 05:51:30 +0100 Kommentierte Antwort Live link from Calc to Base

Hi Ratslinger. I'm glad you answered. I have in fact created a LIVE LINK from Calc to Base. As I make changes to the s

2020-09-12 23:25:48 +0100 verliehene Abzeichen  Elementare Frage (Quelle)
2020-09-12 23:00:42 +0100 Überarbeitete Frage Live link from Calc to Base

Live link from Calc to Base The other day, I found that I could create a live link from Calc to Base, and add a live lin

2020-09-12 22:43:26 +0100 Kommentierte Antwort Live link from Calc to Base

Thanks, anyway, trying to help. Have a great day.

2020-09-12 22:32:46 +0100 Kommentierte Antwort Live link from Calc to Base

No, it actually IS a live link the way I have connected. I can add a spreadsheet row or column and it shows up as a new

2020-09-12 22:04:24 +0100 Kommentierte Antwort Live link from Calc to Base

Already thought of that, but I have found no other way provided to make the connection except as you create the database

2020-09-12 21:57:44 +0100 Kommentierte Frage Live link from Calc to Base

I AM the user. Apparently we are not communicating. Your quote just made my point, yet your comment indicates you believ

2020-09-12 21:34:10 +0100 Kommentierte Frage Live link from Calc to Base

I beg to disagree. Base has HSQLDB and Firebird embedded, but you can use an external datasource instead (such as Calc,

2020-09-12 21:17:10 +0100 Kommentierte Antwort Live link from Calc to Base

No -- and I didn't make the data read-only, Base did. BTW, Base is NOT a database; it serves as a front end for many da

2020-09-12 19:56:00 +0100 Überarbeitete Frage Live link from Calc to Base

Live link from Calc to Base The other day, I found that I could create a live link from Calc to Base, and add a live lin

2020-09-12 19:36:47 +0100 verliehene Abzeichen  Bemerkenswerte Frage (Quelle)
2020-09-12 19:35:42 +0100 Kommentierte Antwort Live link from Calc to Base

Thanks for the suggestion, but Views are disabled in the read-only database.

2020-09-12 19:28:52 +0100 Kommentierte Frage Live link from Calc to Base

I edited my original post to correct my inadvertent omission.

2020-09-12 19:28:11 +0100 Überarbeitete Frage Live link from Calc to Base

Live link from Calc to Base -- what is the point? The other day, I found that I could create a live link from Calc to Ba

2020-09-12 12:00:16 +0100 verliehene Abzeichen  populäre Frage (Quelle)
2020-09-12 07:49:32 +0100 Überarbeitete Frage Live link from Calc to Base

Live link from Calc to Base -- what is the point? The other day, I found that I could create a live link from Calc to Ba

2020-09-12 02:56:52 +0100 Gestellte Frage Live link from Calc to Base

Live link from Calc to Base -- what is the point? The other day, I found that I could create a live link from Calc to Ba

2020-09-08 22:45:17 +0100 verliehene Abzeichen  Elementare Frage (Quelle)
2020-09-08 15:44:38 +0100 verliehene Abzeichen  Elementare Frage (Quelle)
2020-09-07 07:21:23 +0100 verliehene Abzeichen  Bemerkenswerte Frage (Quelle)
2020-09-04 01:07:10 +0100 Kommentierte Antwort LO Base issue clicking switchboard item to see data in form?

Thanks, Ratslinger. Excellent answer. Have a wonderful day.

2020-09-04 01:06:11 +0100 Als beste Antwort markiert LO Base issue clicking switchboard item to see data in form?

Please bear with me as I set up the situation.

I am using Base with Firebird. The database in question has several tables, and several data forms. A given data form opens a specific table.

In addition, I have added a main switchboard (NOT standalone) and two sub-switchboards (again, NOT standalone). Clicking a button on the main switchboard launches a macro which opens a sub-switchboard. Clicking a button on a sub-switchboard launches a macro which opens a data form with its underlying data.

HERE IS THE WEIRD THING (at least to me): LEFT-clicking to open the data form in this fashion results in NO UNDERLYING DATA being displayed or accessible UNLESS I exit the form and open it a second time. Subsequent CONSECUTIVE exits and openings of the same data form continue to display the underlying data. Every time I change to another data form, I have to repeat the process just described.

I tried bypassing the main switchboard and launching the data form straight from the sub-switchboard. The results are the same.

Bypassing the switchboard forms altogether and opening the data forms directly displays the underlying data -- FIRST TIME EVERY TIME.

I would have thought my code might be at fault, EXCEPT I found a number of peculiar behaviors depending on how I clicked the sub-switchboard buttons to access the data form.

I found that RIGHT-clicking to open the data form from the sub-switchboard form opens the data form and displays the underlying data -- FIRST TIME, EVERY TIME.

Interestingly enough, I ALSO found by playing around that double-clicking a sub-switchboard button opens a data form with NO UNDERLYING DATA EVERY TIME -- no matter the sequence. However, I can immediately REOPEN the same form from the sub-switchboard with a single left-click and the UNDERLYING DATA APPEARS.

I've tried this database on two different computers with two different versions of LO (one computer is running the stable version, the other is running the fresh version). I get the same behavior in either case.

Does anyone have an explanation for what I would consider unusual behavior?

Laptop 1: MSI GT780 16 GB RAM 64-bit i-7 quad core (8 threads)

running LibreOffice Version: 6.4.6.2 on Linux 4.15 Mint 19 (running on 500 GB SSD with a 250 GB SSD data drive)

Laptop 2: Acer Spin 5 8 GB RAM 64-bit i-7 quad core (8 threads)

running LibreOffice Version: 7.0.0.3 on Linux 4.15 Mint 19 (running on 256 GB bootable persistent USB flash drive)

2020-09-04 01:05:30 +0100 verliehene Abzeichen  populäre Frage (Quelle)
2020-09-04 00:24:57 +0100 verliehene Abzeichen  Elementare Frage (Quelle)
2020-09-04 00:05:56 +0100 Kommentierte Frage LO Base issue clicking switchboard item to see data in form?

Ratslinger - Just realized I can't give you a check mark because you answered in the comments. Cut and paste your answer

2020-09-04 00:03:54 +0100 Kommentierte Frage LO Base issue clicking switchboard item to see data in form?

Hi Ratslinger: I almost tried "Execute action" earlier today, based on a couple of videos I found, but decided there wa

2020-09-03 23:48:37 +0100 Kommentierte Frage LO Base issue clicking switchboard item to see data in form?

I was joking. It was a joke. Lighten up. (grin) Any ideas what the problem could be? I thought about a hardware incom

2020-09-03 21:49:03 +0100 Kommentierte Frage LO Base issue clicking switchboard item to see data in form?

Hi Ratslinger: As I indicated earlier, my first thought was a macro problem, too -- but remember there is NO problem if

2020-09-03 21:27:28 +0100 Überarbeitete Frage LO Base issue clicking switchboard item to see data in form?

Issue clicking switchboard item to see data in form? Please bear with me as I set up the situation. I am using Base wit

2020-09-03 19:37:25 +0100 Überarbeitete Frage LO Base issue clicking switchboard item to see data in form?

Issue clicking switchboard item to see data in form? Please bear with me as I set up the situation. I am using Base wit

2020-09-03 19:35:23 +0100 Überarbeitete Frage LO Base issue clicking switchboard item to see data in form?

Issue clicking switchboard item to see data in form? Please bear with me as I set up the situation. I am using Base wit

2020-09-03 19:22:46 +0100 Gestellte Frage LO Base issue clicking switchboard item to see data in form?

Issue clicking switchboard item to see data in form? Please bear with me as I set up the situation. I am using Base wit

2020-09-03 16:59:19 +0100 Kommentierte Antwort multiply cells

RayN, I did not mean to imply that "SUM" would be used for multiplication. If my answer was unclear on this point, I apo

2020-09-03 10:42:58 +0100 verliehene Abzeichen  Bemerkenswerte Frage (Quelle)
2020-09-03 10:42:58 +0100 verliehene Abzeichen  Elementare Frage (Quelle)
2020-05-07 21:20:41 +0100 Als beste Antwort markiert Calc pivot table does not preserve word wrap format on refresh

I have noticed this effect for some time. You can word wrap individual Pivot table cells or entire spreadsheet rows. You can do this via the format menu, the ribbon, or the properties window. Regardless of how you do it, a refresh resets to disable word wrap for the Pivot table cells (but not the cells outside the Pivot table -- if you word wrapped entire spreadsheet rows). I could perhaps change the Styles, but this might create unintended consequences in other Pivot tables.

Right now I'm using LibreOffice Version 6.4.0.3, but I have noticed this effect as far back as Version 3.x -- in both Windows and Linux editions. To the best of my memory, I have seen this effect on more than one of my laptops, so neither hardware nor OS seem to play a role.

Is this a bug, or am I missing something?

(search word "format" inserted into the subject by @Lupp)

2020-05-07 21:19:33 +0100 Kommentierte Antwort Calc pivot table does not preserve word wrap format on refresh

Lupp, I just figured out the answer to my own question -- HOWEVER, I am giving you the check mark. Please let me explain