Insert/Delete column along with loading data from XML

Discontinued products Uncategorized discussions
#1

We have grid table with 2 columns with data loaded from XML with 2 cells for each row.



After adding one more column to the grid with grid.insertColumn and loading XML with 3 cells for each row, data from last cell will go to newly created cell, doesn’t matter what index we assign to new column.



Then if we delete this column with grid.deleteColumn and do just the same grid.insertColumn once again, then load data from XML with 3 cells per row, we’ll get 2 original cells just fine and newly created column empty. Then if we load data from XML with 4 cells per row then 4th cell will be displayed in newly created column, but 3rd cell will be nowhere.



So it seems inserting column will attach it to the end of already created columns and deleting, will just hide it from view.



Is there is the way to insert it in the right position or load data not by cells order, but by some id?



Thanks.

#2

Current logic tries to preserve data format, so if you originally have two columns, after added new column - you can still load data in the same format and it will be correctly mapped to old columns.

If you need not such functionality, and prefer to load data in you custom order you can add next command after insertColumn

    grid._c_order=null;


#3


Thanks, after adding this command grid working exactly like we like it to be.

#4

Pls. can u put this “TIP” into your documentation? Would have saved me hours of work! :slight_smile: Thank you so much!

Regards Phil