{"action":"created","issue":{"url":"https://api.github.com/repos/handsontable/handsontable/issues/1765","labels_url":"https://api.github.com/repos/handsontable/handsontable/issues/1765/labels{/name}","comments_url":"https://api.github.com/repos/handsontable/handsontable/issues/1765/comments","events_url":"https://api.github.com/repos/handsontable/handsontable/issues/1765/events","html_url":"https://github.com/handsontable/handsontable/issues/1765","id":42677500,"number":1765,"title":"How to retrieve merged cell info from handsontable?","user":{"login":"jordanlev","id":149992,"avatar_url":"https://avatars.githubusercontent.com/u/149992?v=3","gravatar_id":"","url":"https://api.github.com/users/jordanlev","html_url":"https://github.com/jordanlev","followers_url":"https://api.github.com/users/jordanlev/followers","following_url":"https://api.github.com/users/jordanlev/following{/other_user}","gists_url":"https://api.github.com/users/jordanlev/gists{/gist_id}","starred_url":"https://api.github.com/users/jordanlev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jordanlev/subscriptions","organizations_url":"https://api.github.com/users/jordanlev/orgs","repos_url":"https://api.github.com/users/jordanlev/repos","events_url":"https://api.github.com/users/jordanlev/events{/privacy}","received_events_url":"https://api.github.com/users/jordanlev/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/handsontable/handsontable/labels/Question","name":"Question","color":"0052cc"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2014-09-12T22:41:28Z","updated_at":"2015-03-04T22:13:34Z","closed_at":null,"body":"Really loving the new merge cells feature -- thank you so much for implementing that!\r\n\r\nI see how to enable the feature, and how to set merged cells on initial data... but how exactly do I retrieve info about which cells are merged from the table when it comes time for me to save the user's input? The data structure that the handsontable is bound to (an array) just shows all the cell data -- no info about what is merged. And I couldn't find any kind of \"getMergedCells\" function in the docs or in the codebase itself.\r\n\r\nThanks."},"comment":{"url":"https://api.github.com/repos/handsontable/handsontable/issues/comments/77261554","html_url":"https://github.com/handsontable/handsontable/issues/1765#issuecomment-77261554","issue_url":"https://api.github.com/repos/handsontable/handsontable/issues/1765","id":77261554,"user":{"login":"rasekar2000","id":3443965,"avatar_url":"https://avatars.githubusercontent.com/u/3443965?v=3","gravatar_id":"","url":"https://api.github.com/users/rasekar2000","html_url":"https://github.com/rasekar2000","followers_url":"https://api.github.com/users/rasekar2000/followers","following_url":"https://api.github.com/users/rasekar2000/following{/other_user}","gists_url":"https://api.github.com/users/rasekar2000/gists{/gist_id}","starred_url":"https://api.github.com/users/rasekar2000/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rasekar2000/subscriptions","organizations_url":"https://api.github.com/users/rasekar2000/orgs","repos_url":"https://api.github.com/users/rasekar2000/repos","events_url":"https://api.github.com/users/rasekar2000/events{/privacy}","received_events_url":"https://api.github.com/users/rasekar2000/received_events","type":"User","site_admin":false},"created_at":"2015-03-04T22:13:34Z","updated_at":"2015-03-04T22:13:34Z","body":"Hello @JeromeLam & Team,\r\n\r\n  In this way, I can only get the static / predefined mergedCellInfoCollection only.\r\n\r\nIn this demo page, \r\nhttp://jsfiddle.net/veyx8Lz1/3/\r\n I have merged manually ( not in predefined mergedCellInfoCollection ) cell 4,1 and 4,2 and updated them as \"Merged Cell\" , \r\n    --> I could retrieve this value by calling , hot.getDataAtCell(4,1) as \r\n\r\nhttp://tinypic.com/r/almg7l/8\r\n\r\nBut when I merge some random cells, how do i get the mergedCellInfoCollection for the Cells (4,1)\r\n My expectation is that the response should be  {\"row\":4,\"col\":2,\"rowspan\":1,\"colspan\":2} for the attached use case.  Can you please let us know?\r\n \r\nThanks and Regards,\r\nRaj\r\n PS: when i tried hot.mergeCells.mergedCellInfoCollection.getInfo(4,1), I got Undefined as expected\r\n "}}