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.