Bug 151250 - Database - no DB UI wizards are functional in LibreOffice from AppStore (macOS)
Summary: Database - no DB UI wizards are functional in LibreOffice from AppStore (macOS)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.3.6.2 release
Hardware: ARM macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: notBibisectable, regression
Depends on:
Blocks: Base-Without-Java
  Show dependency treegraph
 
Reported: 2022-09-30 11:06 UTC by Alex Thurgood
Modified: 2023-12-21 13:06 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Alex Thurgood 2022-09-30 11:06:49 UTC
Description:
None of the UI wizards that are displayed in and ODB container are functional in the version of LibreOffice available from the macOS AppStore.

Examples:
- table creation wizard
- query creation wizard
- form creation wizard
- report creation wizard


Steps to Reproduce:
1. Open an embedded Firebird ODB file
2. Click on any of Tables, Queries, Forms, Reports on the lefthand side
3. Click on any of the wizard entries
4. Nothing happens when these entries are clicked.

Actual Results:
None of the wizards are functional.

Expected Results:
Wizards should function to assist user.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.3.6.2 / LibreOffice Community
Build ID: c28ca90fd6e1a19e189fc16c05f8f8924961e12e
CPU threads: 8; OS: Mac OS X 12.6; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded
Comment 1 Alex Thurgood 2022-09-30 11:11:46 UTC
And before anyone retorts that, "duh, of course they don't function because they are written in Java", I know that, but the point is, the AppStore product description over which TDF does have control says you can use databases, and the UI of a loaded database file leads the user to believe you can.

What will the user's appreciation of the product be on discovering that actually most of that blurb isn't true for the version available from the AppStore?
Comment 2 Julien Nabet 2022-09-30 14:14:38 UTC
Yes without Java, Base part is not user friendly.
Comment 3 m_a_riosv 2022-09-30 20:29:58 UTC
I think to have read somewhere that the appstore doesn't allow the full app with Java dependencies.
Comment 4 Julien Nabet 2022-10-01 08:03:03 UTC
(In reply to m.a.riosv from comment #3)
> I think to have read somewhere that the appstore doesn't allow the full app
> with Java dependencies.

From https://developer.apple.com/app-store/review/guidelines/:
"2.4.5 Apps distributed via the Mac App Store have some additional requirements to keep in mind: "

"(viii) Apps should run on the currently shipping OS and may not use deprecated or optionally installed technologies (e.g. Java)"

BTW, there's also:
"(ix) Apps must contain all language and localization support in a single app bundle."
but that's another story.
Comment 5 Alex Thurgood 2023-03-16 12:06:24 UTC
Still reproducible with

Version: 7.4.6.2 / LibreOffice Community
Build ID: 5b1f5509c2decdade7fda905e3e1429a67acd63d
CPU threads: 8; OS: Mac OS X 13.2.1; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded

from the App Store
Comment 6 Xisco Faulí 2023-03-23 15:35:34 UTC
From https://apps.apple.com/us/app/libreoffice/id1630474372:
"Please note that the version provided in the App Store cannot support Java functionality, such as Java-based extensions."
Comment 7 Alex Thurgood 2023-03-24 05:45:57 UTC
(In reply to Xisco Faulí from comment #6)
> From https://apps.apple.com/us/app/libreoffice/id1630474372:
> "Please note that the version provided in the App Store cannot support Java
> functionality, such as Java-based extensions."

That doesn't tell the user that they can not use any of the DB wizards with their non-Java Firebird database. It also doesn't solve the problem. 

The UI wizards form part of the basic functionality of the DB module, and were designed to help new users with the complexity of basic DB tasks, such as those found in competing products. 

The solution is to either rewrite the wizards in C++ or another acceptable language, or remove the UI entries entirely.


Including buttons which simply do nothing is at best a bug, at worst, given that the user makes a financial contribution to obtaining the product, leaves the the foundation open to accusations of dubious commercial practises under a variety of consumer protection laws.
Comment 8 Julien Nabet 2023-04-30 06:58:01 UTC
Dup of tdf#127278
Comment 9 Alex Thurgood 2023-12-21 13:06:16 UTC
Still present in

Version: 7.5.9.2 (AARCH64) / LibreOffice Community
Build ID: cdeefe45c17511d326101eed8008ac4092f278a9
CPU threads: 8; OS: Mac OS X 14.1.1; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded