Instructions for inserting more than 1 line at a time.

Discussion of issues, suggestions and bugs of Devart Excel Add-ins, our product line for connecting Excel to external data from cloud applications and databases
Post Reply
Cortlandt
Posts: 2
Joined: Tue 23 Apr 2019 17:01

Instructions for inserting more than 1 line at a time.

Post by Cortlandt » Thu 25 Apr 2019 00:02

How are we supposed to insert more than I row at a time?
I've tried a number of combinations and can't get consistent results.

Note that when I right click on a row with data in many cases Excel does not give a "Insert" option.
Instead of "Insert" it shows "Insert Copied Cells".

Please update the documentation.

Pinturiccio
Devart Team
Posts: 2390
Joined: Wed 02 Nov 2011 09:44

Re: Instructions for inserting more than 1 line at a time.

Post by Pinturiccio » Thu 25 Apr 2019 15:32

You can copy and paste several records in a time:
1. After you have imported data, on the Devart tab, in the Edit Session group, click "Edit Mode".
2. The bottom row is highlighted in green. Enter a new record in it. The next line becomes green and you can enter a new record. You can also copy and paste one or more records into the green row. If the pasted data has the same structure (same columns in the same order) as the structure of the imported table in Excel, new records will be added and marked as new rows.

Post Reply