/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PublicSymptom
From a generated excel sheet document, when selecting some cells with numbers, average and sum are not shown on the low bar of excel.
Environment
SAP SALES CLOUD CPQ
Cause
New document engine (Aspose Library) treats general cells (when they have numbers) as text.
Resolution
It is necessary to explicitly define cell type to Number in the template before adding it to CPQ. With that, after generating a document, it will show sum and average.
Keywords
CPQ, Excel, Sum, Average, Template, Cell , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , How To
Product
SAP CPQ 2025
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)