Pivot table DataField.NumberFormat not applied to subtotal/grand total rows

Pivot table DataField.NumberFormat not applied to subtotal/grand total rows

Posted by: sivaraman.perumal on 24 February 2026, 1:06 am EST

• 

  sivaraman.perumal

  • Post Options:
  • Link
    Copy

  Posted 24 February 2026, 1:06 am EST

  Using Spread.NET 19 WinForms (GrapeCity.Spreadsheet.PivotTables), I am setting NumberFormat on pivot data fields:
  
  vbpvTable.DataFields(i).NumberFormat = “0.00”
  
  Debug confirms the format IS set correctly (verified via DataFields(i).NumberFormat).
  
  Detail rows display correctly with 2 decimal places.
  
  However subtotal rows (e.g. “2025 Total”) and Grand Total row still show full precision like 5.29083333333333.
  
  This appears to be a rendering bug where the pivot engine ignores NumberFormat for aggregate rows.
  
  Please advise on the official workaround or confirm if this is a known issue.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 25 February 2026, 7:19 am EST

  Hello,

  We are looking into this case and will get back to you with the updates soon.

  Regards,
  
  Prabhat Sharma.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 26 February 2026, 12:03 am EST

  Hello Sivaraman,

  Thank you for reaching out to Mescius Support.
  
  We tried to replicate the scenario on our end, but unfortunately, the issue did not occur. Please find the attached stripped-down sample that works fine at our end. We request that you modify the attached sample and share it back so that we can replicate the issue at our end.
  
  Along with this, please share your OS and machine locale details.

  Regards,
  
  Prabhat Sharma.
  
  SpreadPivotDemo.zip

• 

  sivaraman.perumal

  • Post Options:
  • Link
    Copy

  Posted 27 February 2026, 12:17 am EST

  Hi Prabhat,

  Please find attached sample code and the result. kindly review it and confirm.

  Thanks.
  
  Best Regards,
  
  Siva

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 27 February 2026, 5:45 am EST

  Hello Siva,

  The attachment is missing in your last post. Kindly re-attach it so that we can investigate this request further.

  Regards,
  
  Prabhat Sharma.

• 

  sivaraman.perumal

  • Post Options:
  • Link
    Copy

  Posted 27 February 2026, 6:55 am EST

  Hi,
  
  Please find attached sample code with appropriate screenshot for your refrence.
  
  Thank you.
  
  Best Regards,
  
  SivaDesktop.rar

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 2 March 2026, 2:08 am EST

  Hello Siva,

  The code file that you have shared has lots of unknown terms, so we can not use it directly at our end.
  
  Can you please update our last attached sample to replicate the issue and share it back? This will help us review it properly and assist you further.

  Regards,
  
  Prabhat Sharma.