Created attachment 60570 [details] Snapshot cutting from NotePad and pasting in LO Base (*) This might be a request rather than a bug (?) Sw: - LibreOffice Base 3.4.4 Portable (from portableapps.com) - Win XP 2002 SP3 Context: I've tried cutting a range of cells from an Excel spreadsheet. Then I tried again cutting a list of lines from a notepad. Finally I tried again pasting the lines into Writer. Then converting them into a table and cutting it again. I'm editing a table content and I've tried to paste the mentioned source contents into a LO Base field-cell/box expecting LO Base to append/create a number of new records at one click. The target table at LO Base has a structure defined by just one single compatible (VARCHAR(200)) field. Sympthoms: LibreOffice Base pastes the array into the single field-cell.
This is one of my first bug records for Freedesktop. I guess I must set it myself into "New" status. The fact that I can do it leads me to think I don't need approval from anyone else (?).
@reporter bugreport isn´t reprpducuble. Please list details - step by step
How do you add the copied fields? When you will try this directly in a table you could only add content to one field of one row. Same behaviour in a base-form. You have to use the wizard to import more than one field and one row into a table. Try the following way: Copy the content you want to insert into a table. Click with the right button of the mouse in the table-folder of Base. The wizard appears. Choose the option "Append Data". Table name is the name of the table, where you wish to add the data. ... and then follow the whole steps of the wizard. Does this steps solve your problem?
NOTABUG, this is how cut and paste work within the Table view of Base. The Table view/representation is not a Calc sheet, it doesn't know how to interpret carriage return / line feeds. At best this is a request for enhancement, but it probably is not trivial to achieve, and more importantly, there are already other ways of importing your data into a table than direct copy and pasting of mulitple rows of data from a text field, as Robert has indicated. You can also copy that data into a Calc spreadsheet and from there dragndrop it onto the Table entry in your list of tables in the main ODB window. So, at least 2 ways to achieve what you want to do : NOTABUG.
(In reply to comment #3) > How do you add the copied fields? When you will try this directly in a table > you could only add content to one field of one row. Yes. That's the behavious I was requesting to change. > You have to use the wizard to import more than one field and one row into a > table. > Try the following way: > Copy the content you want to insert into a table. > Click with the right button of the mouse in the table-folder of Base. > The wizard appears. I have to select "Paste" and then it appears > Choose the option "Append Data". > Table name is the name of the table, where you wish to add the data. > ... and then follow the whole steps of the wizard. > Does this steps solve your problem? Yes. It is a quite unobvious procedure, but it works indeed. It rather does insert the copied rows at the top of the table rather than appending them, but yet it solves the need. By the way, it would be nicer if the wizard would offer some more user friendly way to input a name of an existing table into the "Table name" box: a)It could fill the default value with the name of the table that was right-clicked by the user b) or it could offer a drop-down list with all existing table names plus a "new table" value, or c) or it could try a) and if not feasibe (e.g. called somehow else than right clicking a table folder) then show the dropdown list.
(In reply to comment #4) > At best this is a request for enhancement, I agree, as I already said in the description. How do I file a request for enhancement? Is there another request-tracking system? If there is, then you can stop reading here. > NOTABUG, this is how cut and paste work within the Table view of Base. The > Table view/representation is not a Calc sheet, it doesn't know how to > interpret carriage return / line feeds. Yes, that's it. And for the sake of an intuitive and productive user-friendly usage I want to ask for an enhanced behavior. > but it probably is not trivial to achieve, I agree. And it is a good reason to delay the resolution, but not one to close the ticket. > and more importantly, there are already other ways of importing > your data into a table than direct copy and pasting of mulitple rows of data > from a text field, as Robert has indicated. Again, the existence of other tricky ways to achieve it is very nice and I'm also very happy to know about them (don't doubt I'll use them), but is not a reason to close a request-ticket asking to implement a more straight-forward alternative.
@comment 5 There is a feature in base, which offers the table for import. If there isn't any content to import, you could click with right mouse-button and the menu offers only "Copy" and nothing with "Paste". If I had copied content from, for example, Calc, and then click with right mouse-button the mu offers "Copy", "Paste" and "Paste special ..." If you choose "Paste" the wizard appears with the marked table-name and also choosen "Append data" and "Use first line as column names". "Paste special" would only change the format of the content you will insert. Seems, that the feature, you wish, is already there.