Excel merge warning

Add-in Express™ Support Service
That's what is more important than anything else

Excel merge warning
 
murat serhat adalı




Posts: 2
Joined: 2007-05-14
Hi,

I am quite new to excel programming. When I programmatically merge columns of a range object, I am getting regular merge warning which tells "The selection contains multiple data values. Merging into one cell will keep the upper left-most data only."

Is there a way to get rid of them? (My application object is invisible by the way.)

thanks.
Posted 14 May, 2007 06:49:51 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
Joined: 2004-07-05
Hi Murat Serhat.

Actually this is the correct behaviour. Excel warns you about the data that may be lost after you merge some cells.


P.S. Note that we take up your forum requests in the order we receive them. Besides, it may take us some time to investigate your issue. Please be sure we will let you know as soon as the best possible solution is found.
Posted 14 May, 2007 09:50:12 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
Joined: 2004-07-05
Please try to use the DisplayAlerts property of Excel application.
I think it should help.
Posted 14 May, 2007 10:05:11 Top
murat serhat adalı




Posts: 2
Joined: 2007-05-14
Thanks a alot sergey, it did the trick.
Posted 15 May, 2007 07:10:31 Top