Documentation of Excel Java issue

Posted by: srinivas.varma on 8 July 2019, 5:10 pm EST

  • Posted 8 July 2019, 5:10 pm EST

    i am trying to develop pivot table using below link
    https://demos.componentone.com/gcdocs/gcexceljava/#/com.grapecity.documents.excel.examples.features.pivottable.SetNumberFormatForField

    but i document its showing we can apply numberformat for PivotFields
    ex :
      IPivotField field_Amount = pivottable.getPivotFields().get("Amount");
    field_Amount.setOrientation(PivotFieldOrientation.DataField);
    field_Amount.setNumberFormat("$#,##0.00");


    but in your jar version there is no method like that

    My Version is 2.2.1

    please help me out
  • Marked as Answer

    Replied 8 July 2019, 10:40 pm EST

    Hello,

    With build 2.2.1 of GcExcel JAVA we can see NumberFormat being set on PivotTable. Please have a look at attached sample and documentation link for the same.

    https://help.grapecity.com/gcdocs/gcexceljava/onlinehelp/webframe.html#ExportPivotTableStylesAndFormat.html

    Hope it helps. Else please share a small working sample replicating the issue so that we can investigate this issue further.

    Thanks,
    Reeva
    PivotTable-NumberFormat.zip

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels