2 weeks ago
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.
2 weeks ago
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
2 weeks ago
@SaBrien - Try this setting in the CV Cell Format in Excelformat ExcelNumberFormat = [#,###,0;(#,###,0);-]
2 weeks ago
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.
2 weeks ago
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