jqxgrid – multiplecellsadvanced copy issue

[hurricaneParticipant]

Hi,

I have defined a grid with selectionmode as multiplecellsadvanced. The problem is when I am having a column with no value/ empty value, It is not getting copied to other places. For example, I have a 3 columns defined as follows :

FIRST NAME | LAST NAME | AGE
AB <No value> 25

Now, I am selecting all of above cells and doing ctrl+c (just like excel copy columns). Then, I did ctrl+v in next row and got following results:

FIRST NAME | LAST NAME | AGE
AB YY <No value>
AB YY AB
YY AB YY

Please suggest if I have not followed any standards while configuration of grid.

Note – Defined columns are editable.

Regards.

[hurricaneParticipant]

Correcting entries :

FIRST NAME | LAST NAME | AGE
AB YY <No value>

Now, I am selecting all of above cells and doing ctrl+c (just like excel copy columns). Then, I did ctrl+v in next row and got following results:
FIRST NAME | LAST NAME | AGE
AB YY <No value>
AB YY AB
YY AB YY

[Peter StoevKeymaster]

Hi,

We are unable to reproduce such Grid behavior using our demo: http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/spreadsheet.htm?light

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[hurricaneParticipant]

Hi Peter,

Sorry for not being clear in my example. I am able to produce the same issue to the demo grid as well.

Here is my data for 3 columns for row 1,
A B C
1 V1 V2 <empty cell>

now copy these 3 cells ctrl+c , then ctrl+v to row 2,3,4. I have copied the results from the grid demo as follows :

2 V1 V2 V1
3 V2 V1 V2
4 V1 V2 V1

Here, I copied 3 cells but eventually values for only 2 cells got copied. I feel issue still persist.

On the other side, excel world , following are the results :

2 V1 V2 <empty cell>
3 V1 V2 <empty cell>
4 V1 V2 <empty cell>

Regards.

[Peter StoevKeymaster]

Hi,

We will look into that Grid behavior. The empty cell value is not taken into account and it considers it as No Value i.e does not copy it. The multiplication of V1 is because of that. If you select 4 cells, values should be V1 V2 Empty V1.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[hurricaneParticipant]

Thanks Peter for a quick update!

Any plans of considering this change for upcoming jqwidgets release ?

Regards.

[Peter StoevKeymaster]

It’s a Grid work item, but I cannot give any guarantees when exactly it will be resolved. Hopefully, soon with the next release.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[Author]

Posts