Custom Property convert string to number

Jul 12, 2012 at 11:32 AM
Edited Jul 12, 2012 at 11:54 AM

Hi ,

I am trying to update a workbook custom property with the code below

workbook.CustomProperties.CustomProperty("GroupNumber").Value = groupNumber.ToString();  

But when i try to check the file the custom property, 'GroupNumber' has the Type 'Number' instead of 'Text'.

The code that reads the custom properties only accepts Text and I have no control to change that code. Is there a way to make the number as Text?

if only doing the code below is not readonly.

workbook.CustomProperty("GroupNumber").Type = XLCustomPropertyType.Text; //wont work because its a read-only