Page 1 of 1

How to set format for merged range?

Posted: Mon May 23, 2016 1:37 pm
by shenjige
Hi, I have a merged range that covers three cells. When I set formats(color shade and thick border) for the range, it only shows for the first cell, not for the entire range. I have tried XLS->CMDFormat, XLSRange->BorderInsideHorizStyle, I got the same results. Does anyone know how to do that? I remember in one of the previous XLSReadWrite II version, it worked. But it doesn't. Can some one help?
Thanks in advance!
gene.

Re: How to set format for merged range?

Posted: Sat May 28, 2016 9:10 am
by larsa
Hello

When formatting merged cells, set the formatting of the top left cell.