EPPlus icon indicating copy to clipboard operation
EPPlus copied to clipboard

Repeat Labels in Pivot Table fillDownLabels is not defined in C#

Open medaminrannen opened this issue 3 years ago • 7 comments

I want to repeat Labels in Pivot Table but the fillDownLabels is not defined in C#

`if (!isPivotTree)
        {
            pivotTable1.RowGrandTotals = false;
            pivotTable1.ColumnGrandTotals = false;
            pivotTable1.Fields.ForEach(field =>
            {
                field.Outline = true;
                field.Compact = false;
                field.ShowAll = false;
                field.SubtotalTop = true;
                field.ShowMemberPropertyToolTip = false;
            });
        }`
/// <summary>
    /// Gets whether or not to repeat item labels in the pivot table for this field.
    /// </summary>
    public bool RepeatItemLabels
    {
        get { return base.GetXmlNodeBool("d:extLst/d:ext/x14:pivotField/@fillDownLabels"); }
    }

medaminrannen avatar Feb 19 '21 07:02 medaminrannen

I'll see if I can add this to the field to the next version.

JanKallman avatar Mar 02 '21 14:03 JanKallman

I also encountered this problem. Has it been realized at present

Yuexs avatar Jul 04 '22 06:07 Yuexs

No, it's still on the to-do list. I'll see if we can give this a little attention.

JanKallman avatar Jul 04 '22 08:07 JanKallman

Is there any other way to achieve it?

Yuexs avatar Jul 26 '22 03:07 Yuexs

I also encountered this problem. Any news?

KikkoVinke avatar Jan 25 '23 13:01 KikkoVinke

No, this has not yet been implemented. The only way to achieve this is to update the xml via the PivotTableXml yourself. This is property must be written to the extLst element with on the correct field. You can check the format by setting the property in excel and open it in EPPlus or renaming the workbook *.zip and extract the pivot table xml file.

JanKallman avatar Jan 25 '23 14:01 JanKallman

Please, can you provide an example? thanks

KikkoVinke avatar Jan 25 '23 15:01 KikkoVinke