Issue 18904 - OO spreadsheet multirow paste into data source table does not copy first row
Summary: OO spreadsheet multirow paste into data source table does not copy first row
Status: CLOSED DUPLICATE of issue 80917
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-01 21:14 UTC by arnechaa
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description arnechaa 2003-09-01 21:14:57 UTC 
When I copy two rows from an OO spreadsheet containing name and age into a table 
with corresponding data columns only the last row is copied. To be more precise 
I copy the 4 cells (2 rows with 2 colums). In "Assign columns" only the first 
row shows up. After pasting the data source view is not automatically refreshed. 
After refreshing manually only the last row shows up.

Using mysql-4.0.14b-win.
The database definition looks like this:

CREATE TABLE `nameage` (
  `name` varchar(50) NOT NULL default '',
  `age` tinyint(4) default NULL,
  PRIMARY KEY  (`name`)
) TYPE=MyISAM;
Comment 1 Frank Schönheit 2003-09-02 11:37:04 UTC 
correcting sub component
(http://www.openoffice.org/issues/describecomponents.cgi?component=database%20access)
and default owner
Comment 2 marc.neumann 2003-09-03 14:49:21 UTC 
Hi,

It's not 'really' an issue, it's more an howto.

The problem is that the first row you select use as header and the
second row is used as your data.

So as a solution for your topic select the row before the row you need
also.

However, we have to think about a more 'useable' solution.

Bye Marc
Comment 3 ocke.janssen 2003-09-15 13:33:18 UTC 
Hi arnechaa,

as Marc already mentioned, this isn't a bug. I'll send this one back
as invalid. If you want to have an extra option (header line included)
aka check box in the copy table dialog, please sumbit a RFE (Request
for enhancement).

Best regards,

Ocke
Comment 4 arnechaa 2003-09-15 21:47:03 UTC 
I reopen this as a RFE.
When copying data, and creating a new database table, from a 
spreadsheet it may be logical to include header to be the names of 
colum in new table.

When copying into an existing database table it is not logical to 
include header (so this could still be considered to be a bug, but 
never mind).

When creating a new table OO should:
1. If header included confirm (with possibility to change) that header 
should be used as column names.
2. If header not included ask for column names.

When copying into existing table:
1. If header included: skip header or warn user that a probable header 
was stored.
2. if header not included: copy ALL rows to table.

Alternate solution:
Include option to tell if data includes header. The default value 
should be "included" when creating new table and "not included" when 
copying into existing table.

Arne
Comment 5 hans_werner67 2004-02-02 12:24:19 UTC 
change subcomponent to 'none'
Comment 6 ocke.janssen 2004-02-10 14:33:53 UTC 
Set new target
Comment 7 ocke.janssen 2011-02-02 08:18:05 UTC 
Cleaning up.



*** This issue has been marked as a duplicate of 80917 ***
Comment 8 ocke.janssen 2011-02-02 08:18:43 UTC 
Closing.