Description: As it is presented in the UI now, there doesn't seem to be a logical order. With an alphabetical order, it will at least be easier to select from the list. Steps to Reproduce: 1. Open a base database (.odb) file 2. Select 'Create Table in Design View' from tasks 3. Enter a field name 4. Open the field type drop-down list Actual Results: a 21 item drop-down list is presented in the order: Tiny Integer [TINYINT], BigInt [BIGINT], Image [LONGVARBINARY], Binary [VARBINARY], Binary (fix) [BINARY], Memo [LONGVARCHAR], Text (fix) [CHAR], Number [NUMERIC], Decimal [DECIMAL], Integer [INTEGER], Small Integer [SMALLINT], Float [FLOAT], Real [REAL], Double [DOUBLE], Text [VARCHAR], Text [VARCHAR IGNORECASE], Yes/No [BOOLEAN], Date [DATE], Time [TIME], Date/lime [TIMESTAMP], OTHER [OTHER] Expected Results: a drop-down list with the items sorted in some order. e.g. alphabetically (BigInt [BIGINT], Binary (fix) [BINARY], Binary [VARBINARY], Date [DATE], Date/lime [TIMESTAMP], Decimal [DECIMAL], Double [DOUBLE], Float [FLOAT], Image [LONGVARBINARY], Integer [INTEGER], Memo [LONGVARCHAR], Number [NUMERIC], OTHER [OTHER], Real [REAL], Small Integer [SMALLINT], Text (fix) [CHAR], Text [VARCHAR IGNORECASE], Text [VARCHAR], Time [TIME], Tiny Integer [TINYINT], Yes/No [BOOLEAN]), or in order of size. Reproducible: Always User Profile Reset: No Additional Info: as the list is quite long, it's hard to find the desired type. personally i think the alphabetical sort is the easiest to navigate
There seems to be no logical order in the list of field types. Might be we should order the fields by "numeric", "date and time", "text" and others. Also alphabetical order will be better than the order in list box of the editor now. This behavior is as old as OpenOffice Base exists. I will set this one to NEW.