开发者

How do I programmatically create Excel row groups with the +/- box at the top of the group, not bottom

开发者 https://www.devze.com 2022-12-25 23:13 出处:网络
I am creating an Excel 开发者_JAVA百科sheet programmatically.I like to show group totals above each group, and for this to look best the +/- sign that opens and closes the rows should be at the top, w

I am creating an Excel 开发者_JAVA百科sheet programmatically. I like to show group totals above each group, and for this to look best the +/- sign that opens and closes the rows should be at the top, where the total row is.

Is there a way to accomplish this?

TIA,

Alex


Put the formulas in the row, then group the rows below with the option - Data->Group and Outline -> Group.

Hope this helps..

0

精彩评论

暂无评论...
验证码 换一张
取 消