Error: Unable to set the NumberFormat property of the Range class

Applies to:

• Velixo NX
• Velixo Classic
• Every ERP

Symptom

When performing a drill-down, an error message may occur.

Text from the error message:

System.Runtime.InteropServices.COMException (0x800A03EC): Unable to set the NumberFormat property of the Range class 

at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData) 

at Microsoft.Office.Interop.Excel.Range.set_NumberFormat(Object )

at Velixo.Reports.GLHistoryDrilldown.g__FillCell|2_0(DrilldownColumns column, Object numberFormat, Object value, <>c__DisplayClass2_0& ) in C:\Dev\Velixo-Reports-Pro\Velixo.Reports\GLHistoryDrilldown.cs:line 110

at Velixo.Reports.GLHistoryDrilldown.FillRow(Range row, DrilldownData data) in C:\Dev\Velixo-Reports-Pro\Velixo.Reports\GLHistoryDrilldown.cs:line 100 

at CallSite.Target(Closure , CallSite , IDrilldownFormatter , Object , DrilldownData )

at System.Dynamic.UpdateDelegates.UpdateAndExecuteVoid3[T0,T1,T2](CallSite site, T0 arg0, T1 arg1, T2 arg2)

at CallSite.Target(Closure , CallSite , IDrilldownFormatter , Object , DrilldownData )

at Velixo.Reports.DrilldownHelper.ShowDrilldownResults(IEnumerable`1 collectedData) in C:\Dev\Velixo-Reports-Pro\Velixo.Reports\DrilldownHelper.cs:line 212 

at Velixo.Reports.DrilldownHelper.OnDrilldownClick() in C:\Dev\Velixo-Reports-Pro\Velixo.Reports\DrilldownHelper.cs:line 37 

at Velixo.Reports.Ribbon.Attempt(Action action) in C:\Dev\Velixo-Reports-Pro\Velixo.Reports\Ribbon.cs:line 242

Cause

The file has too many custom number formats.

Resolution

The resolution is to choose the Custom category in the Format Cells popup window and delete all unused formats.