https://community.qlik.com/t5/Integration-Extension-APIs/Rounded-numbers-in-export-Vizlib-pivot-table-to-Excel/m-p/2105957#M19000 <P>Hi!</P> <P>I have exported a Vizlib pivot table to Excel.&nbsp;</P> <P>Unfortunately the numbers in one column are rounded in the export:&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SterreKapteijns_0-1692108067409.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/114449i8307548F206F8D71/image-size/medium?v=v2&amp;px=400" role="button" title="SterreKapteijns_0-1692108067409.png" alt="SterreKapteijns_0-1692108067409.png" /></span></P> <P>And in Excel:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SterreKapteijns_1-1692108137950.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/114450i99F9C392D85EBBC1/image-size/medium?v=v2&amp;px=400" role="button" title="SterreKapteijns_1-1692108137950.png" alt="SterreKapteijns_1-1692108137950.png" /></span></P> <P>It shows as 15% even though the cell has the right number, the format of the cell is "Custom", even though in Qlik it is a number.&nbsp;</P> <P>Does anyone know how to change this? I have already tried Num() and changing the decimals.</P> <P>Thanks in advance!</P> <P>&nbsp;</P> Wed, 16 Aug 2023 06:42:41 GMT SterreKapteijns 2023-08-16T06:42:41Z https://community.qlik.com/t5/Integration-Extension-APIs/Rounded-numbers-in-export-Vizlib-pivot-table-to-Excel/m-p/2105957#M19000 <P>Hi!</P> <P>I have exported a Vizlib pivot table to Excel.&nbsp;</P> <P>Unfortunately the numbers in one column are rounded in the export:&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SterreKapteijns_0-1692108067409.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/114449i8307548F206F8D71/image-size/medium?v=v2&amp;px=400" role="button" title="SterreKapteijns_0-1692108067409.png" alt="SterreKapteijns_0-1692108067409.png" /></span></P> <P>And in Excel:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SterreKapteijns_1-1692108137950.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/114450i99F9C392D85EBBC1/image-size/medium?v=v2&amp;px=400" role="button" title="SterreKapteijns_1-1692108137950.png" alt="SterreKapteijns_1-1692108137950.png" /></span></P> <P>It shows as 15% even though the cell has the right number, the format of the cell is "Custom", even though in Qlik it is a number.&nbsp;</P> <P>Does anyone know how to change this? I have already tried Num() and changing the decimals.</P> <P>Thanks in advance!</P> <P>&nbsp;</P> Wed, 16 Aug 2023 06:42:41 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Rounded-numbers-in-export-Vizlib-pivot-table-to-Excel/m-p/2105957#M19000 SterreKapteijns 2023-08-16T06:42:41Z https://community.qlik.com/t5/Integration-Extension-APIs/Rounded-numbers-in-export-Vizlib-pivot-table-to-Excel/m-p/2106001#M19001 <P>Hi, I would suggest contacting Vizlib support, for your questions with Vizlib.<BR /><A href="https://community.vizlib.com/support/home" target="_blank">https://community.vizlib.com/support/home</A></P> Tue, 15 Aug 2023 16:34:47 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Rounded-numbers-in-export-Vizlib-pivot-table-to-Excel/m-p/2106001#M19001 Alan_Slaughter 2023-08-15T16:34:47Z