Apache OpenOffice (AOO) Bugzilla – Issue 12518
Column drag behavior from Data Source Browser to Writer
Last modified: 2014-03-21 09:55:15 UTC
When I drag a row/record from the DSB to Writer, I get an Insert Database Columns (pilot?) dialog box which allows me to insert the table with or without the column titles, etc. But if I drag a column/field from the DSB to Writer, I get <column name>, not a columnar list of data like I wanted. Not very intuitive. Looks like I have to make a special query to get just one column. Split from Issue# 12482
Still ugly.
SBA: Reassigned to Bettina from the User Experience team for consideration.
OpenOffice.org Issue Tracker - Feedback Request. The Issue you raised is currently 'Unconfirmed' pending review, but has not been updated within the last 3 years. Please consider re-testing with one of the latest versions of OOo, as the problem(s) may have already been addressed. Either use the recent stable version: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ Please report back the outcome so this Issue may be Closed or Progressed as necessary - otherwise it may be Resolved as Invalid in the future. You may also wish to search for (and note) any duplicates of this Issue that may have advanced further by checking the Issue Tracker: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".
Program skips "Insert Database Columns" dialog window and assumes I want to insert a column header field and not table or text when dragging a column header. Only row dragging brings the dialog window. AOO410m14(Build:9760) - Rev. 1573601 2014-03-03 17:47:48 (Mo, 03 Mrz 2014) Win 7
This is a feature since the data browser exists, not a bug. A data row has a defined number of fields (columns). So D&D a row into a Writer document it asks you, how to insert the selected rows. But a column have so many entries how the database have rows. Hundreds? Thousands? But apart from that you can feel free to insert the whole table (all rows) and select in the "Insert Database Rows" dialog window only the column(s) that you want. D&D a column insert a mail merge field, so it is easy to create mail merge letters. This worked long before the mail merge wizard was introduced. And this feature was documented but now I can't find anything about this in the help. So imagine that you create a mail merge (template) by dragging columns into the document, and you fill the document by dragging the right row. Because of this I change the status.
(In reply to mroe from comment #6) > This is a feature since the data browser exists, not a bug. This issue is marked enhancement... > A data row has a defined number of fields (columns). So D&D a row into a > Writer document it asks you, how to insert the selected rows. > > But a column have so many entries how the database have rows. Hundreds? > Thousands? It is possible to have a data source with column number > row number... > But apart from that you can feel free to insert the whole table (all rows) > and select in the "Insert Database Rows" dialog window only the column(s) > that you want. Not efficient... > D&D a column insert a mail merge field, so it is easy to create mail merge > letters. This worked long before the mail merge wizard was introduced. And > this feature was documented but now I can't find anything about this in the > help. > > So imagine that you create a mail merge (template) by dragging columns into > the document, and you fill the document by dragging the right row. Interaction with data source columns shouldn't be limited to mail merge fields creation. > Because of this I change the status. I request more opinions heard before dismissing this issue.
(In reply to Edwin Sharp from comment #7) > (In reply to mroe from comment #6) > > This is a feature since the data browser exists, not a bug. > This issue is marked enhancement... Because of misunderstanding the feature. > > A data row has a defined number of fields (columns). So D&D a row into a > > Writer document it asks you, how to insert the selected rows. > > > > But a column have so many entries how the database have rows. Hundreds? > > Thousands? > It is possible to have a data source with column number > row number... This is common to newly created databases. > > But apart from that you can feel free to insert the whole table (all rows) > > and select in the "Insert Database Rows" dialog window only the column(s) > > that you want. > Not efficient... Describe an more efficient way. Lesser than 2 or 3 clicks as I described. But remember that you can't select more than one column. > > D&D a column insert a mail merge field, so it is easy to create mail merge > > letters. This worked long before the mail merge wizard was introduced. And > > this feature was documented but now I can't find anything about this in the > > help. > > > > So imagine that you create a mail merge (template) by dragging columns into > > the document, and you fill the document by dragging the right row. > Interaction with data source columns shouldn't be limited to mail merge > fields creation. > > > Because of this I change the status. > I request more opinions heard before dismissing this issue. After 11 years ...
Because of missing a description of the feature in help: https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/OOo3.3_User_Guide_Chapters or https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/OOo3.3_Chapters_ODT Ch11 - Using Mail Merge Look at section "Creating a form letter"