4 Replies Latest reply: Mar 26, 2018 11:41 AM by Leandro Job Neto RSS

    NPrinting - Number format

    Lennard de Koning

      Hi all,

       

      I'm having an issue with number format when sending reports from an NPrinting Excel template. Basically, NPrinting is reversing the comma and point given up in Qlikview. But Excel treats them the way Qlikview does.

      This means I need to specify format '#,##0' (with comma) to see format '#.##0' (with point) in Excel. This results in us not being able to use the "Use source formats" and we need to specify the format for every field we add in Nprinting. We have a large amount of data that we want to send through Nprinting so this will become a real pain.

      Seeing as both Qlikview ánd Excel are treating the formats as expected, I am hoping that there is an Nprinting specific setting that I can use?

       

      More specific: The following is an example of the case.

       

      I Have a Qlikview document with expressions that are set up as a integer. In the "Number" tab the format is '#.##0' following from

       

      SET ThousandSep=          '.';

      SET DecimalSep=             ',';

       

      Result of QV Expression in QV: 33.419.942

       

      When I import these expressions into NPrinting with "Keep Source Formats" and export an example of a table or graph, my numbers are shown without a thousand separator and with decimal numbers. This decimal separator however is a comma (,). 

      Now, If i change the Format in NPrinting into '#,##0'  (with a comma) and export to Excel I get the desired result.  The funny thing is that Excel than says that the format is "#.##0" (with a point).

       

      Result of NPR Example with "Keep source formats":  33419923,66

      Result of NPR Example with "#,##0" (Comma)           33.419.924         Excel "Format Cells"says format is "#.##0" (point)

      Result of NPR Example with "#.##0" (point)               33419923,66       Excel "Format Cells"says format is "#,##0" (comma)

       

       

       

      We are running Nprinting 16, Qlikview 11 and MS Excel 2013.

       

      Is there a setting I can change in Nprinting? I have not been able to find anything as of yet, neither in settings nor on the forum.