What Changed
If you create or modify a workbook in code - or via the Spreadsheet control’s UI - and do not specify the DocumentProperties.Application and DocumentProperties.Version values, we set these properties as follows:
-
the Application property is set to
DevExpress Office File API/X.Y.Z.0
, where X.Y.Z is the DevExpress build number (for instance, 20.1.5.0); -
the Version property is set to the DevExpress major version (for instance, 20.1).
Reasons for Change
This change will help you identify that a document was created or modified by the DevExpress Spreadsheet Document API or Spreadsheet control.
How to Update Your Application
Specify your Application and Version values
If you assign custom values to the Application and Version properties, these values will be preserved when you save the document.
C#workbook.DocumentProperties.Application = "My Application v1.0.0.0";
workbook.DocumentProperties.Version = "1.0";
Visual Basicworkbook.DocumentProperties.Application = "My Application v1.0.0.0"
workbook.DocumentProperties.Version = "1.0"
Use the Application and Version values of the loaded workbook
The following example shows how to save a document with the same Application and Version values that were specified in the loaded document:
C#workbook.DocumentProperties.Application = workbook.DocumentProperties.Application;
workbook.DocumentProperties.Version = workbook.DocumentProperties.Version;
workbook.SaveDocument("Document.xlsx");
Visual Basicworkbook.DocumentProperties.Application = workbook.DocumentProperties.Application
workbook.DocumentProperties.Version = workbook.DocumentProperties.Version
workbook.SaveDocument("Document.xlsx")
Clear document properties
You can clear values of the Application and Version document properties as shown below:
C#workbook.DocumentProperties.Application = "";
workbook.DocumentProperties.Version = "";
Visual Basicworkbook.DocumentProperties.Application = ""
workbook.DocumentProperties.Version = ""