Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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)
thanks Devarasu and Andy.
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
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.
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
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.
no worries then
did you actualy solve your issue raised in this topic - If so please mark correct answers?
cheers
Lech