Formatting on Pivot Tables

Formatting on Pivot Tables

Posted by: ksriram on 18 January 2022, 5:28 am EST

• 

  ksriram

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 18 January 2022, 5:28 am EST

  We recently started using pivot tables on SpreadJS. We noticed cell formatting ( Bold, Italics, Background color … ) applied on the pivot table gets reset when the pivot panel is opened ( using GC.Spread.Pivot.PivotPanel )

  This doesn’t happen on the spreadJS designer demo.
  
  https://www.grapecity.com/spreadjs/designer/index.html

  Can someone point us to the right documentation on how to add cell formatting to Pivot tables?

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 20 January 2022, 4:52 pm EST

  Hi,
  
  The observed behavior is by design. The designer internally manages to preserve the style and when the pivot panel is created, it automatically applies the style to the table. This is not the case with SpreadJS.
  
  It is recommended to use the setStyle method to set the style on the pivot table: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Pivot.PivotTable~setStyle.html
  
  Pivot Style Demo: https://www.grapecity.com/spreadjs/demos/features/pivot-table/pivot-style/purejs
  
  Please refer to the sample that describes the same: https://jscodemine.grapecity.com/share/gcV4BCQgAkWyaEXId0AzVQ/
  
  Regards.

• 

  ksriram

  • Post Options:
  • Link
    Copy

  Posted 28 January 2022, 9:01 am EST

  Can you point me toward the documentation for PivotAreas and how to convert a selection on PivotTable into PivotAreas

  The documentation on Pivot Table Area doesn’t have any information
  
  https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Pivot.IPivotArea.html

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 30 January 2022, 10:31 pm EST - Updated 3 October 2022, 12:27 am EST

  Hi,

  1. Please refer to the demos that demonstrates Pivot Area:

  https://www.grapecity.com/spreadjs/docs/v14/online/pivot-table-components.html and https://www.grapecity.com/spreadjs/docs/v14/online/themes-and-style.html

  You can also refer to the SpreadJS definition file on various properties of IPivotArea. Please refer to line 3713 of the attached definition file: gc.spread.sheets.d.ts

  

  703×221 5.7 KB

  2. We are unable to understand your second requirement. Could you elaborate what you are trying to achieve by the following statement?

  Regards,
  
  Avinash

  gc.spread.sheets.d.ts.zip