title: In handsontable - convert number to date by function and load refresh more data
body: <p>I am using handsontable for creating a CRUD (create read update delete) interface for my databases which now require these two things.</p>
  
  <ol>
  <li>Able to create/update/delete <code>rows/cells which are changed</code> (and not the whole data set)</li>
  <li>Able to <code>load more data</code> from database (as new records are added) or <code>refresh changed rows</code></li>
  </ol>
  
  <p>-</p>
  
  <h2>Part 1 (Solved) - <a href="http://jsfiddle.net/p7KwM/" rel="nofollow">http://jsfiddle.net/p7KwM/</a></h2>
  
  <p>So I added a field name <code>modified as timestamp (INT)</code> to database so that data can be refreshed at user side by checking this modified field, and it is INT so that TZ value can be added as per user. See here <a href="http://demo.mgvz.com/.twilio/loader.pl" rel="nofollow">http://demo.mgvz.com/.twilio/loader.pl</a> and now <code>I am stuck at that I want to modify this INT to add TZ value and to covert it to date-time format within handsontable</code>. (Can't do it server side) If it can be modified by way of function within handsontable, else the only option is to modify it before giving it to handsontable.</p>
  
  <h2>Part 2 (any help appreciated)</h2>
  
  <p>Second, I have to <code>add rows which are created on server</code> and <code>update rows which are changed on server</code>, without effecting other unchanged rows, (a user might be editing other rows), and to maintain sorting while adding the rows.</p>
  
  <p>Can anyone guide me about it.</p>
  
  <p>Thanks</p>