Bug 68374 - UI: Feature Enhancement: Query Design View: Select multiple columns at once
Summary: UI: Feature Enhancement: Query Design View: Select multiple columns at once
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) release
Hardware: Other Linux (All)
: medium enhancement
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: Database-Queries
  Show dependency treegraph
Reported: 2013-08-21 11:04 UTC by athanasiusofalex
Modified: 2017-11-06 00:02 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description athanasiusofalex 2013-08-21 11:04:02 UTC
Problem description: At present, in the query design view, in order to select many columns in a table with many fields, the user must double-click or else drag-and-drop each one, which is tedious.

Steps to reproduce:
1. Create a query with the query design view.
2. Add a table (preferably with many columns).
3. Try to add (for example) all of the columns save one.

Current behavior: You have to double-click or drag-and-drop each field individually. The problem occurs in the small boxes produced by "adding" a table to the query. If the user selects many fields at once and then tries to drag-and-drop, the selection simply collapses to a single field.

Expected behavior: If many fields are selected, clicking and holding the mouse should preserve the selection. When the user keeps his hold on the mouse and drags it down to the bottom of the screen, he should be able to add all of the selected fields  to the query at once.
Operating System: Debian
Version: release
Comment 1 Jean-Baptiste Faure 2013-11-13 20:55:23 UTC
Did you try to use shift+click or ctrl+click ?
I do not know if that works, but these combination key+click are widely used to select a range and to make multiple selections.

Best regards. JBF
Comment 2 athanasiusofalex 2014-01-12 09:54:06 UTC
(In reply to comment #1)
> Did you try to use shift+click or ctrl+click ?
Yes, but neither one produces the desired effect.

(Note: I am speaking about query-design view, where one is trying to construct a query using diagrams.)

What is needed is a way to add all fields selected in a table to the query, on one move.
Comment 3 Jean-Baptiste Faure 2014-01-12 10:25:49 UTC
Ok, set to NEW and enhancement.

Best regards. JBF
Comment 4 Alex Thurgood 2015-01-03 17:40:52 UTC Comment hidden (no-value)