SAP Knowledge Base Article - Public

2934086 - Excel row height changed from fixed to flexible

Symptom

Customers noticed a change in the Excel output file: before, the rows' height was always the same, regardless of the size of the text within it, now the rows' height are flexible, adjusting to the size of the text.

Environment

SAP SuccessFactors HCM Suite

Reproducing the Issue

  1. Go to Report Center
  2. Run a report offline (.xls or .xlsx)
  3. Go to View Schedules > My Jobs
  4. Download the report, open the file
  5. You'll notice that the rows' height is adjusted to the size of the text

Cause

This happens due the new Excel renderer configuration. This new renderer consumes 90% less memory compared to old one and helps reports that used to fail due out of memory exceptions to run fine.

Resolution

This is the expected behavior of the system. Customer can change the rows' height manually in Excel.

Keywords

Excel, height, report, center, view schedules , KBA , LOD-SF-ANA-RDT , Report Distributor (Advanced Reporting, ORD) , Problem

Product

SAP SuccessFactors HCM Suite all versions