3019771 - Analysis for Office crashing when EnableNativeFormatting is set

Issue occurs when adding a time field to Rows or Columns and EnableNativeFormatting is set.

In the trace, you can also see the following error:

com.sap.ip.bi.pioneer.excel.models.EaItemGrid.Render|VSTA_Main|Exception in EaItemGrid Render: Bali Exception:

bali.lang.UnsupportedOperationException
at com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.AbstractQvCharacteristicConsumerMember.getTimeSpan()
at com.sap.ip.bi.pioneer.core.utils.CrBicsResultSetHelper.GetCellValue(ICrGridCell iCell, ICrBicsResultSetFormatConfiguration config)
at com.sap.ip.bi.pioneer.excel.views.grid.EaRenderStructure.GetValueFromGridCell(ICrGridCell iCell, EaFormulaHelper iFormulaHelper)
at com.sap.ip.bi.pioneer.excel.views.grid.EaRenderStructure.FillArraysFromCell(Int32 iCol, Int32 iRow, Int32 iCorrectedRow, ICrGridCell lCell)
at com.sap.ip.bi.pioneer.excel.views.grid.EaRenderStructure.FillArraysFromCell(Int32 iCol, Int32 iRow, ICrGridCell lCell)
at com.sap.ip.bi.pioneer.excel.views.grid.EaRenderStructure.CreateFromModel()
at com.sap.ip.bi.pioneer.excel.models.EaItemGrid.Render()
com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.AbstractQvCharacteristicConsumerMember.getTimeSpan(AbstractQvCharacteristicConsumerMember:74)

SAP Analysis for Microsoft Office 2.8

getTimeSpan, time, drilldown, enablenativeformatting, Bali Exception, An exception occurred in one of the data sources, SAP BI Add-in has disconnected all data sources, If you want to restart, press the Restart Button below. (ID-111006), ID111006, 70ef-3f47-dc , KBA , BI-RA-AO-XLA , Excel Addin , Problem