Hi albe,

Yes.  There can be two ways to add multiple rows.

This is only possible with our Manual Tables and i will explain the methods.

You can create a Manual Table from scratch,

or you can import data from a CSV/Excel or Google Sheet for Manual Table creation.

 If you import the file, the plugin reads the source file and creates a manual table. 

Once the table is created, it is no longer linked to the source file, so changing data in the table will not show up in Excel or Google Spreadsheet, and vice-versa. 

-

When you need to add multiple cells at the same time,

you can either switch to the Excel-like view, 

and then select and copy the range of cells you want to paste from the source file, and paste it in the Excel-like view, 

or you can import a new/edited CSV/Excel or Google Sheet to update the table, as well, in the following ways :

• Update manual tables: Replace data within an existing table.
• Update manual tables: Add data to an existing table.
•  Update manual tables: Replace the entire table with new data.

Let me know if that helps.

-

And i just wanted to point out that you can try wpDataTables before purchasing

 on our sandbox Demo sites ( you can find links for the main plugin Demo,  

as well as add-on Demos, in my signature),

and there is a 15-day money-back guarantee period, 

so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

Let me know if you have any additional questions. 

Hi albe,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

Thank you for reporting this behaviour.

What you showed here is a Simple Table type.

This is a unique Table type which has some unique features such as

merging cells, and very user-friendly interface in terms of reordering rows, etc,

but on the other hand, this table has certain limitations when compared to our other table types.

-

For example, in a Manual Table, this makes a table in your SQL Database,

with its own set of columns and rows,

each row has a unique Row ID, so each cell is going to store its own data, its own color, formatting etc,

while in a Simple Table like this one, the color and style is being stored in a specific 'position' in a Table, more like a Spreadsheet would behave.

For example, if you have some style in Row 8, Column B, the style is saved for that 'cell position'.

Then when you remove an entire row, all the content that was in the row beneath changes the position of the content,

so now what was in the Column B, row 8 has now passed to Column B, cell 7.

We did have a bug with it before, that was not changing a color as expected when reordeding some merged cells, but that was fixed.

I agree with you though, in a scenario like this, i would prefer that the row with last name "Kirk" retains the red background color for all the cells that will move up one row,

but we have to take in consideration that, when you completely remove rows 6 and 7,

now what was previously row 8 has became row 7, and the Simple Table had white background with black text for that cell position,

and now there are no longer 10 rows in this table, but there are 8.

For example, i made this dummy Table as on my screenshot, and let's focus on this cell in row 8 , Column C, Last name "Kirk" is in the cell.

If i move this entire row up,  now all this data and style is moving along with the row,

so the color of the cell is moving as well,

now what was in row 8  is in row 7.

But if i did as you said, 

if i revert them to have background colors in Rows 8, 9 and 10,

Now if we completely remove the rows 6 and 7,

the content of the cells that were previously in rows 8,  9 and 10 will now get moved to row 6, 7 and 8,

so they will pick up the styles that were set in these rows and those Columns.

Basically, Row 7, Column B was in white background with black text,

so if we completely remove that row of data,

now the content of cells which was in Row 8 , Column B is now being moved up to Row 7, Column B,

and it 'takes the style' that was set for that cell position in the Simple Table.

That is the current default behaviour, so i am not sure if we will call it a bug/ or an issue,

but we will certainly check with our QA Team and our developers if we can change this to better suit your desired use-case,

and we will report back on that as quickly as possible.

Thank you for your patience.

In the meantime, can you tell me did you try our other Table types, such as a Manual Table?

Let me know if that table type might work better for your use case,

while we check this behaviour for Simple Tables.

Thanks.

Hi albe,

I have an update on this.

We can confirm our QA Team flagged this behaviour as a bug.

The expected behaviour should be as you described, to carry over the colors/styles when we delete rows like that.

The bug happens when we delete multiple rows at the same time,

it does not happen if we just delete 1 row at a time.

Our developers isolated the bug, and they'll add it to their queue for fixing.

 They will do their best to build a fix as soon as possible.

 We don't have an exact ETA on when the fix will be available, but please keep a lookout on our wpDataTables changeLog,

It will be stated there during updates which bug fixes have been implemented at each update,

and you could subscribe to our newsletter, if you wish, so you're informed about new features, bug fixes, freebies, etc.

Thank you for reporting that issue,

let me know if you have any additional questions or if you notice anything unrelated, please don't hesitate to open new/additional tickets, since we keep one subject per ticket as our policy.

I hope this should be fixed very soon, and i hope to see you soon as our premium user with an active licence.

Thanks again.

Hi albe,

No problem at all, we are happy to help and advise as much as possible.

Anything else that we could assist with, please don't hesitate to create new tickets.

Have a great day! :)