Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

sureshqv
Esteemed Contributor III

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.

Tags (1)
1 Solution

Accepted Solutions
kakaderanjit53
Contributor III

Re: Format issue

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
4 Replies
kakaderanjit53
Contributor III

Re: Format issue

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
Highlighted
sureshqv
Esteemed Contributor III

Re: Format issue

still no luck bro

woutermak
Contributor III

Re: Format issue

You can change your cell format in Excel.

number.PNG

mkelemen
Contributor III

Re: Format issue

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

Community Browser