Start Building Professional
Web Apps Today

dhtmlxtreegrid1.6 - copying values from Microsoft Excel

Hi,

I tried copying two cell values from Microsoft excel.When i serialise the grid, i am getting some space appended to the last cell's value.What may be done to rectify this?


I copied two cells with values -98 and 300 .The xml string which i got after doing serialisation is
<?xml version="1.0"?><rows><row id='1'><cell>-98</cell><cell>300

</cell></row></rows>

The issue can't be reconstructed locally.
You can try to use attached js file, it has one minor fix not directly related to your problem

The grid copy and place data in cells exactly as it was taken from clipboard. If you need some additiional filtering|trimming you can modify code of  pasteBlockFromClipboard method of dhtmlxgrid.