topic Re: Nprinting excel report null value in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/Nprinting-excel-report-null-value/m-p/1356249#M17745 <HTML><HEAD></HEAD><BODY><P>Hi Lech,</P><P></P><P>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.</P></BODY></HTML> Tue, 13 Jun 2017 06:20:26 GMT ronaldwang 2017-06-13T06:20:26Z Nprinting excel report null value https://community.qlik.com/t5/Qlik-NPrinting/Nprinting-excel-report-null-value/m-p/1356247#M17743 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Tue, 13 Jun 2017 02:42:01 GMT https://community.qlik.com/t5/Qlik-NPrinting/Nprinting-excel-report-null-value/m-p/1356247#M17743 ronaldwang 2017-06-13T02:42:01Z Re: Nprinting excel report null value https://community.qlik.com/t5/Qlik-NPrinting/Nprinting-excel-report-null-value/m-p/1356248#M17744 <HTML><HEAD></HEAD><BODY><P>from QlikView or QlikSense?</P></BODY></HTML> Tue, 13 Jun 2017 06:15:20 GMT https://community.qlik.com/t5/Qlik-NPrinting/Nprinting-excel-report-null-value/m-p/1356248#M17744 Lech_Miszkiewicz 2017-06-13T06:15:20Z Re: Nprinting excel report null value https://community.qlik.com/t5/Qlik-NPrinting/Nprinting-excel-report-null-value/m-p/1356249#M17745 <HTML><HEAD></HEAD><BODY><P>Hi Lech,</P><P></P><P>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.</P></BODY></HTML> Tue, 13 Jun 2017 06:20:26 GMT https://community.qlik.com/t5/Qlik-NPrinting/Nprinting-excel-report-null-value/m-p/1356249#M17745 ronaldwang 2017-06-13T06:20:26Z