Documentation of Excel Java issue

Documentation of Excel Java issue

Posted by: srinivas.varma on 9 July 2019, 2:10 am EST

• 

  srinivas.varma

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 9 July 2019, 2:10 am 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);
    [b]field_Amount.setNumberFormat("$#,##0.00");[/b]
  

  but in your jar version there is no method like that

  My Version is 2.2.1

  please help me out

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 9 July 2019, 7:40 am 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