Description: 1) Start Collabora Office 2) Start the Base wizard to try and create a new embedded database 3) The first step of the wizard shows an error message: It is not possible to create a new database, because neither HSQLDB, nor Firebird, is available in this setup. Steps to Reproduce: See description above. Actual Results: No new embedded database can be created. Expected Results: Should be able to create either an embedded HSQLDB database, or an embedded Firebird database. Reproducible: Always User Profile Reset: Yes Additional Info: Version : 6.4-20 Build ID : 8f9231b97d06858b598c6fa819546ca3391d11c7 Threads CPU : 8; OS : Mac OS X 11.2; UI Render : par défaut; VCL: osx; Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded
Bug still present in Collabora Office Version : 6.4-39 Build ID : 3a86bbd5e06d0fb7c057c761e924111e6499d20e Threads CPU : 8; OS : Mac OS X 11.4; UI Render : par défaut; VCL: osx; Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded cf. enclosed screenshot
Created attachment 173153 [details] Screenshot of Base Wizard Dialog Page 1
Still present in Version: 21.06.3.1 Build ID: af9fc08c876737f17aed2427c2645ca8b82fdaf9 CPU threads: 8; OS: Mac OS X 11.4; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded
intel mac no repro Additional Info: Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: 246f24ebc8227345f13784d9e2f055d813f3d24f CPU threads: 12; OS: Mac OS X 10.15.7; UI render: default; VCL: osx Locale: ru-RU (ru_UA.UTF-8); UI: en-US Calc: threaded Version: 7.1.5.2 / LibreOffice Community Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5 CPU threads: 12; OS: Mac OS X 10.15.7; UI render: default; VCL: osx Locale: ru-RU (ru_UA.UTF-8); UI: en-US Calc: threaded
(In reply to Denys Prokhorov from comment #4) > intel mac no repro > Thanks, I suspected as much, and originally filed the bug as relevant only for Apple Arm processors, but the confirmation that it works on Intel is good to know.
Have installed on OpenSUSE 15.2 Collabora Office Version: 21.06.3.20210810 Build ID: b606764ce2a042f2a38c98820d7236661149d20c CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: en-US Calc: threaded Created a new database with Collabora Office, opened the new database → all works well here. So couldn't confirm with Collabora Office and Linux. Could be a special MAC/ARM-bug @Comment4: has been tested with Libre Office, not Collabora Office …
Still broken in Collabora Office Version: 21.06.4.1 Build ID: 5ad6bfb54ffec15fe311ed990aa1518979b8f086 CPU threads: 8; OS: Mac OS X 11.5.2; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded
In comparison and contrast, LibreOffice from TDF does not suffer from this problem. Ironically, neither does : Version: 7.2.0.4 / LibreOffice Community Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b CPU threads: 8; OS: Mac OS X 11.5.2; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded also released by Collabora via the app store.
Bug still present in Version: 21.06.9.1 Build ID: 0579e4dd91e7fd2e0574e3919b921e930642f8dd CPU threads: 8; OS: Mac OS X 12.1; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded
Collabora Office 21.06 is based on LibreOffice 7.1. Firebird database was marked as experimental feature in LibreOffice 7.1. Therefore you have to enable experimental features on Preferences - Colabora Office - Advanced tab. Then you have Firebird.
(In reply to Andras Timar from comment #10) > Collabora Office 21.06 is based on LibreOffice 7.1. Firebird database was > marked as experimental feature in LibreOffice 7.1. Therefore you have to > enable experimental features on Preferences - Colabora Office - Advanced > tab. Then you have Firebird. Seems a little bit confusing: Alex wrote about any embedded database an MacOS. Your answer is about Firebird, not about the default HSQLDB. Why did you switch it as worksforme, while Alex still could confirm the bug with the same version. Did you really test it with Mac OS X 11.4?
Hi Robert; HSQLDB requires Java which is extremely problematic and expensive to maintain. Firebird provides a solution that does not depend on Java, and as such is much more attractive. As & when we update to base from LibreOffice 7.3 which is due later this year we should have Firebird on by default - I imagine. HTH.
One can load an existing embedded Firebird ODB, but can not now create a new one without activating the experimental features ? From a user perspective, this is not very logical given that Firebird is the only embedded database engine that Collabora supports.
(In reply to Michael Meeks from comment #12) > Hi Robert; HSQLDB requires Java which is extremely problematic and expensive > to maintain. Firebird provides a solution that does not depend on Java, and > as such is much more attractive. As & when we update to base from > LibreOffice 7.3 which is due later this year we should have Firebird on by > default - I imagine. HTH. Hi Michael, I feel that Collabora really needs to communicate better on this wrt the end user. With TDF LO, the user still has the choice of embedded HSQLDB if the experimental features are not activated. With Collabora Productivity, making embedded Firebird an experimental feature again, when it wasn't in previous versions is confusing at best, especially given that the user can still load and work with existing embedded Firebird files in normal mode (i.e. without experimental features), just not create any new ones.
(In reply to Alex Thurgood from comment #14) From the Apple Store : > I feel that Collabora really needs to communicate better on this wrt the end > user. > "Collabora Office is built for critical business needs and discerning users by Collabora" Hmmm...
I'm sure you're right - we can communicate better. However, since there is already a fix for this: us upgrading to Libreoffice 7.3 -and- this is coming in the next months, I would prefer to avoid burning engineering time for a temporary fix or user dialog explaining things here.