Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
medaminrannen opened this issue Feb 19, 2021 · 7 comments
Open
Labels
enhancement New feature or request

Comments

@medaminrannen
Copy link

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"); }
    }
@JanKallman
Copy link
Contributor

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

@JanKallman JanKallman added the enhancement New feature or request label Mar 15, 2021
@Yuexs
Copy link

Yuexs commented Jul 4, 2022

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

@JanKallman
Copy link
Contributor

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

@Yuexs
Copy link

Yuexs commented Jul 26, 2022

Is there any other way to achieve it?

@KikkoVinke
Copy link

I also encountered this problem. Any news?

@JanKallman
Copy link
Contributor

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.

@KikkoVinke
Copy link

KikkoVinke commented Jan 25, 2023

Please, can you provide an example? thanks

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

4 participants