Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
ronaldwang
Creator III
Creator III

Nprinting excel report null value

when exporting in cell or column format (de-selecting source format). if the cell value is null. the source format will still be kept. anyone know how to solve the issue? (apart from changing the expression to convert null to zero) thanks

2 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

from QlikView or QlikSense?

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
ronaldwang
Creator III
Creator III
Author

Hi Lech,

It is from QlikView. that is when the cell value is null, the border of the cell will disappear. as long as the cell value is not null, it is all good.