html - How to merge cell or make colspan on jquery-handsontable? -

-

i using handsontable make excel-like table. want have merged title on table. possible? or there other solution? thx.

<div id="example1" style="width: 400px; height: 300px; overflow: scroll"></div>  <script>             function mergecell(instance, td, row, col, prop, value, cellproperties) {               handsontable.textcell.renderer.apply(this, arguments);               td.colspan = 2;             }             var mydata = [               ["", "1", "2", "3", "4", "5", "6"],                  //i want merge first row using function 'mergecell'               ["year", "d", "n", "d", "n", "d", "n", "d", "n", "d", "n", "d", "n"],               ["2009", '', -11, 14, 13, 1, 2, 8, 13, -5, 9, 12, 0],               ["2010", '', 15, -12, 1, -5, '', 12, 3, -1, '', 12, 13],               ["2008", -5, '', 12, 13, -5, '', 12, 13, -4, '', 10, 3]];              $("#example1").handsontable({               data: mydata,               fixedrowstop: 2,               fixedcolumnsleft: 1,               contextmenu: true,               cells: function (row, col, prop) {                 var cellproperties = {};                   cellproperties.readonly = true;                                if (col != 0 && row === 0) {                   cellproperties.renderer = mergecell;                  }                 return cellproperties;               }             }); </script>

i found answer question! function mergecell should called after other functions, if have them.

<div id="example1" style="width: 400px; height: 300px; overflow: scroll"></div>  <script>             function mergecell(instance, td, row, col, prop, value, cellproperties) {               handsontable.textcell.renderer.apply(this, arguments);               //td.colspan = 2; wrong, should :               td.setattribute("colspan", "2");             }             var mydata = [               ["", "1", "2", "3", "4", "5", "6", "", "", ""],                  //i dont know why should have columns               ["year", "d", "n", "d", "n", "d", "n", "d", "n", "d", "n", "d", "n"],               ["2009", '', -11, 14, 13, 1, 2, 8, 13, -5, 9, 12, 0],               ["2010", '', 15, -12, 1, -5, '', 12, 3, -1, '', 12, 13],               ["2008", -5, '', 12, 13, -5, '', 12, 13, -4, '', 10, 3]];              $("#example1").handsontable({               data: mydata,               fixedrowstop: 2,               fixedcolumnsleft: 1,               contextmenu: true,               cells: function (row, col, prop) {                 var cellproperties = {};                   cellproperties.readonly = true;                                if (col != 0 && row === 0) {                   cellproperties.renderer = mergecell;                  }                 return cellproperties;               }             }); </script>

edit script load wrong data. @ last, cancelled making title cells merged.


Comments

Post a Comment

Popular posts from this blog

javascript - DIV "hiding" when changing dropdown value -

-
this related previous question asked: hide / show multiple divs i have code in place previous question , seems work ok apart when change value in dropdown "after" ticket selection made. i have number of javascrpts in place wondering if there clash somewhere? first bit of code in head of document. <head> <script type="text/javascript"> $(function() { $('.cat_dropdown').change(function() { $('#paymethod').toggle($(this).val() >= 2); }); }); </script> <script type="text/javascript"> $(document).ready(function () { $(".paymentmethod").click(function () { $(".paymentinfo").hide(); switch ($(this).val()) { case "credit card authorisation": $("#pay0").show("slow"); break; ...
Read more

node.js - Node - Passport Auth - Authed Post Route hangs on form submission -

-
this weird one. im passport's 'local strategy' express app , i'm running odd issue. essentially, have 3 routes. each have auth check in place. app.get('/admin', authenticatedornot, adminroute.index); app.get('/admin/new', authenticatedornot, adminroute.newpost); app.post('/admin/new', authenticatedornot, adminroute.create); the authenticatedornot method : var authenticatedornot = function(req, res, next){ if(req.isauthenticated()){ next(); }else{ res.redirect("/login"); } } works perfect logging in admin area, , checking if user logged in, when submit form '/admin/new' post route, browser hangs. nothing happens in console, console.log in place : exports.create = function(req, res){ console.log(req); // database logic here res.redirect('/admin'); } i cant seem work. hangs, , fails. browser console says 'pending' in network request. ive tried remov...
Read more

Does Firefox offer AppleScript support to get URL of windows? -

-
i trying write applescript that, among other things, gets url of every open webpage in firefox. in safari (and chrome), done simply: tell application "safari" return url of every tab in every window however, seems me firefox offers no real applescript support, such getting url of tab or window. when google terms "firefox" , "applescript" together, firefox bug requests asking applescript support restored, last updated in 2010 or 2011 (like this , this ). am right in thinking, then, firefox no longer offers proper applescript support? realize there semi-workarounds, such simulating key-commands in applescript, aren't practical purposes. to see of applescript commands firefox responds to, launch applescript editor, select menu file > open dictionary... , , choose firefox application. you'll find you're expecting: firefox doesn't offer useful applescript commands.
Read more