This project has moved and is read-only. For the latest updates, please go here.

Unmerge a Range

Jan 22, 2015 at 4:00 PM
Hi guys!

In December had reported an error with unmerge a range:

And later another person also

Any progress on this?

Regards, Nicholls
Jan 23, 2015 at 6:08 PM
Hi Nicholls!

If range A1:B1 is merged, you can remove the merging of the cells like this:
ws.Cells["A1:B1"].Merge = false;
Does this not work for you? If not, please create an issue with a reproducible error.

Jan 23, 2015 at 6:58 PM
Hi Mats!

Thanks for your response, I will try to make a reproducible example.

Meanwhile do you think of my solution? =>

Regards, Nicholls
Jan 23, 2015 at 7:10 PM
Ok, I did not get that this was related to deleting cells as well. I just tried to merge and then unmerge which seemed to work fine... I will ask Jan to have a look at this, he knows these things better than myself and he has done a lot of work on the cell store lately.

Thanks for sharing your solution!

Jan 23, 2015 at 9:21 PM
Edited Jan 23, 2015 at 9:21 PM
Hi Mats!

Plase give me an email to send you the demo, I can't in CodePlex =>
My email is Thanks in advance, Nicholls
Jan 25, 2015 at 12:29 PM
Hi Nicholls!

I spoke to Jan about this today and he thinks that he has fixed it, he will push it to Codeplex today or tomorrow. We are planning to release a new version next week.

You can send the demo to

Marked as answer by jdnichollsc on 1/25/2015 at 4:47 PM
Jan 26, 2015 at 12:46 AM
Edited Jan 26, 2015 at 12:46 AM
Ohhh nice! Thanks Mats for your help and I send greetings to Jan!

Jan 26, 2015 at 2:25 PM
Edited Jan 26, 2015 at 6:30 PM
Hi Mats

I tryed with the last commit aa51fa8165f5 but when I try to open the excel file shows me error


I could attach the file

Regards, Nicholls