Read/write by column

Discontinued products Uncategorized discussions
#1

Hi… how can I parse by complete column?



i have this…







00

0000:value



//Second Column

00

0000:value



//First Column

01

0100:value







Want to read in this order… fisrt cell-first column, then second cell-First column, Then First cell- Second column.





Is it posible or must rewrite xml code? In that case, could you send me an xml sample, writed by entire column? Dont know how to do it.







Thanks!









#2

Is it posible or must rewrite xml code? In that case, could you send me
an xml sample, writed by entire column? Dont know how to do it.
Grid is row centric and it is pretty hard to import XML in such format.
You can check
    dhtmlx.com/docs/products/dhtmlxG … tloadtypes
But the more simple approach will be to use server side XSLT transformation, to translate data in your format in common grid’s format.

#3

ok thanks.
I think its more simple than do that.
The reason of all of it, is that I must paint cells depending on the cell value. (fo e.g. if cell 1,1 (first column) has the value “4”,  then cells 1,2  1,3 and 1,4 must be green background)

So Ive been thinking … once Ive got the xml, im gonna go through the grid with javascript (by entire column) and change the style.

Must use the mygrid.forEachRow, and a "for column loop " to solve the thing, uh?

Do you have an example to do that?  (I dont wanna be lazy, but have few time …)













 

#4

and a "for column loop " to solve the thing, uh?
Yes, it is one of possible solutions.

>>Do you have an example to do that?
mygrid.forEachRow(function(id){
    if (mygrid.cells(id,0).getValue==4){
       mygrid.cells(id,1).cell.style.backgroundColor=“green”;
       mygrid.cells(id,2).cell.style.backgroundColor=“green”;
       mygrid.cells(id,3).cell.style.backgroundColor=“green”;
    }
})

#5

Thanks for all, very helpfull.