05-03-2024 10:44 AM
Is there a way to format 'NoData' cells so that when the report exports to excel it shows a dash or 0, instead of the cell being blank?
Solved! Go to Solution.
05-03-2024 02:34 PM
Hi,
I was able to accomplish this using UD8 dynamic calc. By setting up a dynamic calc to return a 0 if IsNoData is TRUE. Then you can use the Excel formatting as Krishna mentioned.
Dim cellCheck As DataCell = api.Data.GetDataCell("UD8#None")
If cellCheck.CellStatus.IsNoData() Then
Return 0
Else
Return api.Data.GetDataCell("UD8#None").CellAmount
End If
Thank you,
Thomas Uhler
05-03-2024 11:44 AM
@SaBrien - Try this setting in the CV Cell Format in Excelformat ExcelNumberFormat = [#,###,0;(#,###,0);-]
05-03-2024 01:01 PM
We've tried many variations using the excel number format but none seem to work. Any cell that has 'NoData' will be blank and we were wanting them to show zeros.
05-03-2024 02:34 PM
Hi,
I was able to accomplish this using UD8 dynamic calc. By setting up a dynamic calc to return a 0 if IsNoData is TRUE. Then you can use the Excel formatting as Krishna mentioned.
Dim cellCheck As DataCell = api.Data.GetDataCell("UD8#None")
If cellCheck.CellStatus.IsNoData() Then
Return 0
Else
Return api.Data.GetDataCell("UD8#None").CellAmount
End If
Thank you,
Thomas Uhler