Issue 105691 - Append data from sheet
Summary: Append data from sheet
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.1.1 RC2
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-10-07 17:52 UTC by villeroy
Modified: 2013-01-29 21:47 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description villeroy 2009-10-07 17:52:05 UTC
Many people collect data in emailed spreadsheets and it is a quite common
problem that OOo does not allow to merge tables or collect records from various
When I drag a spreadsheet range into the beamer, the only reactive part is the
tables section of some database. I drop my range and then I have to enter the
table name and choose option "Append Data".
I believe that Base could be a little bit more attractive if you could collect
data a little bit easier.
2 things I could think of:
Drag and drop on a table should start the import wizard with the right table
name and append option.
The same should be possible with writable queries. A query starting with the
right order of fields could help to import data in two steps. Drag&drop and
confirm the field order.