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: 
Chanty4u
MVP
MVP

Format issue

Hi all

i am facing one issue regarding number format

i am created a excel report in nprinting ,,, in my qliksense application stright table measure coloumns are  number format

but after creating reports  in result template  it is showing  number converted to text .

hence values are not coming in related tables in template.

1 Solution

Accepted Solutions
kakaderanjit53
Creator III
Creator III

Hello,

Kindly implement the following number format after deselecting the "keep source format" option under properties of object/element;

  

NameStyle
format.Integer#,##0
format.Decimal#,##0.00
format.Money$#,##0.00
format.Percentage#,##0.00%
format.ShortDateDD/MM/YYYY
format.LongDateWWWW, MMMM DD, YYYY
format.Timeh:mm:ss TT
format.TimestampDD/MM/YYYY h:mm:ss[.fff] TT

View solution in original post

4 Replies
kakaderanjit53
Creator III
Creator III

Hello,

Kindly implement the following number format after deselecting the "keep source format" option under properties of object/element;

  

NameStyle
format.Integer#,##0
format.Decimal#,##0.00
format.Money$#,##0.00
format.Percentage#,##0.00%
format.ShortDateDD/MM/YYYY
format.LongDateWWWW, MMMM DD, YYYY
format.Timeh:mm:ss TT
format.TimestampDD/MM/YYYY h:mm:ss[.fff] TT
Chanty4u
MVP
MVP
Author

still no luck bro

woutermak
Partner - Creator III
Partner - Creator III

You can change your cell format in Excel.

number.PNG

mkelemen
Creator III
Creator III

Hi,

17.3.1 was released yesterday and it fixes following bug:

Custom formats ignored on cells

Jira issue ID: OP-4037

If you added cells with the Keep source format flag deselected, and a custom format specified, Qlik

NPrinting ignored the custom format and displayed the numbers with scientific notation.

Not exactly what you are experiencing but it is worth a try.

BR,

  Matus