https://bugs.documentfoundation.org/show_bug.cgi?id=160102
Bug ID: 160102
Summary: Items in the field type drop-down in design view of
tables should be sorted alphabetically
Product: LibreOffice
Version: 7.6.2.1 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
