CCS Evaluation Export to Excel fails with error String assigned to the cell cannot be greater than 32767
search cancel

CCS Evaluation Export to Excel fails with error String assigned to the cell cannot be greater than 32767

book

Article ID: 158652

calendar_today

Updated On:

Products

Control Compliance Suite Control Compliance Suite Standards Module Control Compliance Suite Standards Server

Issue/Introduction

You are trying to export Evaluation Results using the option File > Export to Excel and the export operation is terminated with the error below: 

ERROR: String values assigned to a cell cannot have a length greater than 32767

 

String values assigned to a cell cannot have a length greater than 32767

 

Cause

The error is valid. Some of the checks return more than 32767 characters and cannot be imported to the single cell as per Microsoft Excel limitation

For more information on Excel specifications please refer to the link below:
Microsoft - Excel specifications and limits

 

Resolution

There is another option in CCS that allows the export. If you would like to avoid the error, right-click the asset in the Asset-based view and choose "export results to XLS" - that will truncate evidence output larger than 30000 characters into multiple cells. For example, evidence of 40000 characters will be spanned over one cell of 30000 and a second cell of 10000 characters. 

Alternatively - export to CSV and use that for data processing or manipulation.