Description: Connect to an existing database drop-down list should be alphabeticcaly sorted Today it looks so: JDBC Oracle JDBC ADO Microsoft Access Microsoft Access 2007 Spreadsheet dBase Firebird External Text MySQL/MariaDB ODBC PostgreSQL Writer Document But should looks like: ADO dBase Firebird External JDBC Microsoft Access Microsoft Access 2007 MySQL/MariaDB ODBC Oracle JDBC PostgreSQL Spreadsheet Text Writer Document Steps to Reproduce: 1. Open LibreOffice 2. Select File->New->Database (it opens the Database wizard) 3. Select Connect to an existing database radiobutton 4. Select the drop-down list below and look at it (see Description above) Actual Results: Connect to an existing database drop-down list in Database Wizard isn't alphabeticcaly sorted Expected Results: Connect to an existing database drop-down list in Database Wizard is alphabeticcaly sorted Reproducible: Always User Profile Reset: No Additional Info: Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: ccb78b98e0618cce365562fe326d018892b8104a CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL Jumbo
Looks like some kind of sorting is done here. Wonder what difference is between JDBC vs. Oracle JDBC, the various MSO formats, what exactly Spreadshseet means (if LibreOffice Calc we should label it so and Writer as well). So before sorting, which is not a bad idea, we have to clarify the options. => needsDevAdvice
(In reply to Heiko Tietze from comment #1) > Wonder what difference is between JDBC vs. Oracle JDBC, "Oracle JDBC" is probably just Libreoffice's SDBC-JDBC driver with some (all?) settings hardcoded to what is know to be working/correct with Oracles' JDBC driver. Which is also what the "MySQL/MariaDB JDBC" option is (which you get after choosing MySQL/MariaDB and clicking next, you get a new choice between native, JDBC and ODBC). > the various MSO formats Probably ".mdb" and ".accdb", respectively. Similarly, those are thin wrappers around the ADO support, IIRC. > what exactly Spreadshseet means Probably "any file format supported by LibreOffice Calc". That includes "Text", but would be using the "Text" file through LibreOffice Calc, instead of through native Base/SDBC support.
FWIW, there is/was also an ongoing discussion about how to reorganise (or not) the MySQL/MariaDB entry, i.e. whether or not to put everything into the main, first dialog, or leave it as present in a secondary dialog which only appears if MySQL/MariaDB is selected in the first window. See, for example : bug 128950 But also see the related discussions around what to put in the first dialog: bug 127665 bug 148192
If anyone is going to tackle this, please make sure that it is consistent throughout - there are multiple entry points for displaying the list of possible database connection types.
(In reply to Heiko Tietze from comment #1) > > So before sorting, which is not a bad idea, we have to clarify the options. > > => needsDevAdvice @Heike : I believe you already started looking at the Spreadsheet page in bug 148499 ?
(In reply to Alex Thurgood from comment #5) > @Heike : I believe you already started looking at the Spreadsheet page in > bug 148499 ? Not beyond adding the code pointer