Apache OpenOffice (AOO) Bugzilla – Issue 80917
copying data from calc and writer to base is omitting the first line/record
Last modified: 2011-02-02 08:18:03 UTC
Task: Copy data from writer/calc to an existing base table appending data. Error: The first line of data is not inserted into the target table. Database: Internal HSQLDB registered Data Source Tested with: 2.2.0 680m2 OS: Win98se Reproduce: - open attached .odb file plus one of the .ods/.odt files - goto writere/clac doc - writer: select complete table with the mouse / calc: select the used range - click the "copy" button in the toolbar - activate the base window - select the tables container - click the "paste" button in the toolbar - the import assistant window pops up - type in "Artikel" as table name - select "append data" - click next (not sure if necessary) - click finish - open the table "Artikel" You'll see: the data has been imported without any proton. (In case of copying from writer there are spaces inserted into the first field of each row, this is a separate issue 80916)
Created attachment 47701 [details] spreadsheet containing data to copy
Created attachment 47702 [details] writer doc containing data to copy
Created attachment 47703 [details] database file for reproduction
confirming, targeting, assigning
At the moment it is not possible to say that the first row isn't the row which defines the columns. Change target to enhancement. As a workaround you could insert table row which defines the names of the columns.
Hey, so it's a feature well known from CSV and the like. :) I'd like to suggest two actions then: 1. The import wizard could have one more checkbox labeled "use first line as field names" as usual. 2. There should be some information in the online help that are easy to find in the context of c&p to base.
Fixed in cws dba24c
.
Please verify. Thanks.
back to oj. The new check box is missing
reassign back to oj
Has to be clarified with UX how to handle it. First shot was not that promising. :-(
Change target to 3.1. No new UI changes can be done for 3.0.
Ocke, did you manage to contact UX for their feedback?
I'm sorry. No. May be the best way is to assign this issue directly to ux.
Target moved.
Betina, Ocke, could you, please, involve UX or just decide on UI and get this issue resolved? The code is ready for a year and users are not benefiting from the effort made. Thank you for your prompt action. Regards, Kirill Palagin.
@kpalagin: I agree to you, this issue is to severe to be postponed to 3.x, which could be mean anything up to 3 years. @bh: Sorry, back to 3.1. We need to decide on this.
Blocks meta-issue 95768.
FS, OJ, please comment on "When a range of cells are copied and then pasted into Base there are two scenarios, either the creation of a new table or the appending of the data into an existing table. Issue 80917 deals specifically with the second scenario, appending data. However the behavior of treating the first row in the input data as column designators is the same in either scenario. So I would assume that the fix, the addition of an option to treat the first row as data, is available in both also. Question 1 then, is this the case? Question 2, if so then given the situation where a user selects to create a new table from the data and selects the option to not use the first row as column names how will the column names be entered? Thanks Drew" by Drew Jensen.
Not sure where you have this from (I think I already read it, but I don't know anymore in which list, so I'm not sure about the context here). 'bout your questions: Yes, I think a check box would apply to both scenarios. Basically, this option affects how the source data is interpreted, so changing target parameters (like "append or create") has no effect on its availability. Second, on one of the wizard pages is a field to change column names, isn't it? The default would probably be something like "Column_1", ... "Column_25".
Here is the context http://ux.openoffice.org/servlets/ReadMsg? listName=discuss&msgNo=2427
thanks, copied my answer to the list.
Sigh. Lost this from the radar, and now we effectively missed feature freeze.
Any news with this one? Regards.
Grabbing. We need to discuss this enhancement in the I-Team. Any help how to redesign the table copy wizard is welcome.
Any chance to finally get this going before code freeze for 3.2?
Yes. I'll wait for a new cws to put my changes in.
Fixed in cws dba32d Now the user can select if the first row should only be used to describe columns or if the row should also be inserted. This only applies for RTF and HTML formats. When copying from another database columns are already defined.
fs->msc: please verify in CWS dba32d
verified in CWS dba32d find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba32d
This issue is closed automatically and wasn't rechecked in a current version of OOo. The fixed issue should be integrated in OOo since more than half a year. If you think this issue isn't fixed in a current version (OOo 3.1), please reopen it and change the field 'Target Milestone' accordingly. If you want to download a current version of OOo => http://download.openoffice.org/index.html If you want to know more about the handling of fixed/verified issues => http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues
Sorry this issue was wrongly closed. This issue will be reopened automatically. And will be set after that back to fixed/verified.
Set to state 'fixed'.
Set back to state 'verified/fixed'. Again. Sorry for the mass of mails.
Verified in m52 - checkbox "Use first line as column name" is there and works. Thanks a lot! Closing.
*** Issue 18904 has been marked as a duplicate of this issue. ***