Nprinting number format

[ronaldwang]

Hi,

When I try to export data into excel (using the not keep formatting) and I want to show the negative number in red so I use format like "#,##0;[Red]-#,##0". but the result is changed to #,##0;__-#,##0. Anyone had similar experience and what is the fix? thanks

[ogster1974]

Have you tried using the conditional formatting built into excel?

Layout your table cells in the sheet and highlight the data cells  you want to conditionally format.

[devarasu07]

Hi,

Why don't you do your conditional text column in qlikview object itself (refer to sample attachment). then nprint easy to capture the format.

try to put like below in your expression (measure filed --> under text color)

if(sum(Sales)>0,Black(),Red())

Note:

if you really wanted to do in nprint custom format like below

#.##0,0;(#.##0,0)

[ronaldwang]

thanks Devarasu and Andy.

[Lech_Miszkiewicz · Accepted solution]

Hi Ronald,

When you want to format your cells in XLS you must use "Excel Conditional Formatting" for cells you want to apply collors to!

see screenshots (i did them quickly in Excel, but you would have to do it oin NPrinting designer - template editor and conditional formatting will be applied to the tag representing  your number , like: <nodeXX>:

regards

Lech

[ronaldwang]

Thanks Lech.

I used to open excel template directly and edit from there as it works quicker. and from your post seems like this is not the safest way to edit.

[Lech_Miszkiewicz]

That is still fine.

Just remind me Ronald - are you on version 16 or 17 of NPrinting. In version 16 it was very easy to find and edit template where in version 17 template is tailer in repository files and it has self assigned GUID id which may be difficult to find among other files.

regards

Lech

[ronaldwang]

Hi Lech,

I am using 16.2 and easy to edit the template, just when the template file gets bigger, the speed to edit in designer is very slow.

[Lech_Miszkiewicz]

no worries then

did you actualy solve your issue raised in this topic - If so please mark correct answers?

cheers

Lech