autofit_AutoFit合并的单元格行高更新20151203

autofit

Way back in June 2012, I posted some sample code for adjusting the row height in merged cells. It's been 3-1/2 years, and people are still commenting on that article!

早在2012年6月，我发布了一些示例代码来调整合并单元格中的行高 。 已经有3-1 / 2年了，人们仍然在评论那篇文章！

Apparently it is a common problem, and even though I don't like merged cells, sometimes we just have to deal with them.

显然，这是一个普遍的问题，即使我不喜欢合并的单元格，有时我们也只需要处理它们。

自动调整问题 (The AutoFit Problem)

To quickly summarize the problem – if cells are merged, the rows don't AutoFit correctly when you double-click in the row button area.

为了快速总结问题–如果合并单元格，则在行按钮区域中双击时，行将无法正确进行自动调整。

For example, the text doesn't fit in the merged cell below.

例如，该文本不适合下面的合并单元格。