How do I modify summaryBelow setting for sheet?

51 views
Skip to first unread message

Alexander

unread,
Jul 11, 2013, 7:40:59 AM7/11/13
to ax...@googlegroups.com

Hi guys,


There is a '+' icon in the left side of the doc when you group rows. The problem is - by default it is 1 line below Summary row. There is a setting to move it 1 line up:

<sheetPr><outlinePr summaryBelow="0"/></sheetPr>

I've created saved the same doc with summaryBelow enabled and disabled. The only difference is:

<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"><sheetPr><outlinePr summaryBelow="0"/></sheetPr><dimension ref="A4:A27"/><sheetViews><sheetView tabSelected="1" workbookViewId="0"> ....

Is there a way to set this property in axlsx?

Here is a screenshot I made on windows:


BTW, I didn't find a way to change it in Excel for Mac :) Does anybody know where can I find it?

Thanks in advance,
Alex
Reply all
Reply to author
Forward
0 new messages