This project has moved. For the latest updates, please go here.

Unmerge a Range

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

In December had reported an error with unmerge a range: https://epplus.codeplex.com/discussions/574716

And later another person also http://epplus.codeplex.com/workitem/15134

Any progress on this?

Regards, Nicholls
Developer
Jan 23, 2015 at 5: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.

/Mats
Jan 23, 2015 at 5:58 PM
Hi Mats!

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

Meanwhile do you think of my solution? => https://epplus.codeplex.com/workitem/15179

Regards, Nicholls
Developer
Jan 23, 2015 at 6: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!

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

Plase give me an email to send you the demo, I can't in CodePlex => https://epplus.codeplex.com/workitem/15182/
My email is jdnichollsc@hotmail.com Thanks in advance, Nicholls
Developer
Jan 25, 2015 at 11:29 AM
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 epplusproj@gmail.com.

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

Nicholls
Jan 26, 2015 at 1:25 PM
Edited Jan 26, 2015 at 5:30 PM
Hi Mats

I tryed with the last commit aa51fa8165f5 but when I try to open the excel file shows me error http://screencast.com/t/TKOd2I0xCA

Image

I could attach the file https://epplus.codeplex.com/workitem/15182

Regards, Nicholls