Ctrl+C doesn't copy empty cells to table variable

bug
#1

I have copied cells from excel or any window that represent data in tab separation format.
If the cells are empty, the table is skipping that cell and replacing that with next cell values and so on.

#2

Hi @pavan.karasala do you copy these values in a table using Clipboard action?
Can you share your recording or the screenshot of the Clipboard action?

#3

image

Follow the below steps.

  1. Copy data from an excel with spaces in between columns using the getRange from Excel Action library or copy data randomly from some UI which contains empty cells in between using ctrl+c.
  2. Now transfer that data to a table using setRange from Excel Actions library or using clipboard action library.
  3. Try to use that table and set it back to a new excel or Print the table in a log file.
  4. You will see that empty cell are replaced with data in its next column.
#4

@pavan.karasala I couldn’t reproduce this issue.
Can you share your recording?

#5

image

1 Like
#6

Step8. Test1 is an xlsx file with below content.
image

1 Like
#7

image

1 Like
#8

Step 12: Am just write the empty date to a text file.
Step 13: Opening an new excel named Test2.xlsx
Step 14: Copying the empty table to Test.xlsx

#9

Thank you for providing such a detailed explanation.
I managed to reproduce this issue. Weäll look into this.

#10

@pavan.karasala there is a bug in the current version. Thanks for reporting.
We have created a ticket to fix it.