Back to Ideas
1
Like
Follow Idea
Copy and Paste Data into Grid
7820Views
10Comments
Implemented
Frontend (App Interfaces)

I would like to be able to copy data from web page or Excel sheet and paste into data grid.


the use case is batch data entry.


Example: https://www.ag-grid.com/javascript-grid-clipboard/

 Paste from Clipboard 

 Paste to clipboard can only be done in the following ways:

  • Press keys Ctrl+V while focus in on the grid with a single cell selected. The paste will then proceed starting at            the selected cell if multiple cells are to be pasted.
  •  Press keys Ctrl+V while focus in on the grid with a range of cells selected. If the selected            range being pasted is larger than copied range, it will repeat if it fits evenly, otherwise it will just            copy the cells into the start of the range. 



25 May 2018
Copy link to comment
Changed the category to
Service Studio
25 May 2018
Copy link to comment
2014-02-07 17-02-43
Vasco Pessanha
Changed the category to
Frontend
06 Jul 2018
Copy link to comment
Changed the status to
On our RadarOn our radar

Hi George,

Thanks for the idea. I just didn't understand one thing. You're looking for a grid component that allows a copy paste feature, or are you looking to use an existing OutSystems component (and, if so, which one) with extended copy paste capabilities?

Regards,

Ricardo Alves

28 Nov 2018
Copy link to comment

Hi,


A grid component that allows copy and paste.


The use case is for excel users who can copy multiple cells of text and post into grid rows in a single operation, rather than type one by one.

Im not after import excel feature as it is not intuitive. I want copy paste.


Regards, 

George

28 Nov 2018
Copy link to comment

Hi,


A grid component that allows copy and paste.


The use case is for excel users who can copy multiple cells of text and post into grid rows in a single operation, rather than type one by one.

Im not after import excel feature as it is not intuitive. I want copy paste.


Regards, 

George

28 Nov 2018
Copy link to comment
Changed the status to
Implemented
on 27 Mar 2019

Hi George,

We released a data grid component, that supports such use case.

Try it out and let me know if it solved your use case.

Kind regards,

Ricardo Alves 

08 Apr 2019
Copy link to comment

Great! I'll try. Thanks so much.

09 Apr 2019
Copy link to comment

Hey George,

I have a data grid implemented and I would like to have the possibility to paste as many lines as I want in order to paste it directly on the grid without having to press manually "Add New Line" accordingly to the amount of lines I would be about to paste. Does this JS feature supports that?

In other words If I copy 10 lines in my excel sheet file (with the same structure as the grid) and paste it over the outsystems grid with only 1 line there, would my 10 copied lines be created and added after paste?


Thanks so much,

Ricardo

25 Mar 2022
Copy link to comment

Sorry @Ricardo, I don't know the solution to your answer but I am interested as well. Hope some experts can help :)

If you do figure it out, much appreciate if you can post here.

26 Mar 2022
Copy link to comment

Hi George,

Can you please help me with Data Grid copy & paste feature like, copying data from Excel and pasting in Data Grid both having same structure.

How we can use copy paste feature in Data Grid? 

If you can provide the steps it will be very much useful.

Thank You.

17 Jul
Copy link to comment