Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | OO spreadsheet multirow paste into data source table does not copy first row | ||
---|---|---|---|
Product: | Base | Reporter: | arnechaa <arnechaa> |
Component: | code | Assignee: | ocke.janssen |
Status: | CLOSED DUPLICATE | QA Contact: | issues@dba <issues> |
Severity: | Trivial | ||
Priority: | P3 | CC: | issues |
Version: | OOo 1.1 RC3 | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Windows 2000 | ||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
arnechaa
2003-09-01 21:14:57 UTC
correcting sub component (http://www.openoffice.org/issues/describecomponents.cgi?component=database%20access) and default owner 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 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 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 change subcomponent to 'none' Set new target Cleaning up. *** This issue has been marked as a duplicate of 80917 *** Closing. |