We have noticed that export to excel(Periodic—DataExport—Import/Export—ExcelSpread sheets—Template wizard) gives an error when working with tables which we have added fields to. Error is coming from class “SysExcelTemplateWizard” method: format cell. Error is: Error execution code. DictEnum Object not initialized. I have noticed that if i uncheck our fields, there is no error. Also i have noticed that it might something to do with our fields which ARE NOT created using extended data type. I might be wrong about this one. But when i use in Wizard our fields which use extended data types, no error. Does it really matter? We would not want to change fields at this point, because we wrote a lot of code declaring them as “real”, for example, not extended data types. May be it is not core of the problem, but something else should be done(some set up) for our fields? Please advice. thank you, M.
Hi, There are some bugs in SysExcelTemplateWizard class for quite some time. Not sure why MS hasn’t fixed this yet … Any way try to change the following line in SysExcelTemplateWizard → formatCell method. Comment line no. 24 - // label = new DictEnum(_tmpExcelField.methodEnumId).label(); And replace with this - label = _tmpExcelField.methodEnumId ? new DictEnum(_tmpExcelField.methodEnumId).label() : ‘Unknown’; HTH, Harish Mohanbabu
thank you so much, it worked!!!