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

Program Error

Issue has been fixed in SAP Analysis for Microsoft Office 2.8 SP7

Analysis Office Installation and Update

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