Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I found a weird bug when using Excel conditional formatting.
I made a Excel report that is transformed to a PDF document.
When i preview the document in Excel the conditional formatting is used and shown
It's a simple conditional formatting rule. When the data date is smaller than date today than the cell turns red.
But a problem arises when I preview it to PDF
The complete conditional formatting isn't shown anymore.
This also comes out this way when I start the task and output the report.
Anybody with the same problem, who can help me with a solution?
A very late reaction but I just fixed this problem.
I used the NUMBERVALUE function in the conditional formatting rule. I changed it to the VALUE function and that works when i preview to PDF.
The precise conditional formatting rule is: VALUE(TODAY())
Very weird problem but it works.
Hi
in left side panel
select the table right clik properties and uncheck the option keep source format and preview
Thank you for the quick reaction.
The option was already unchecked. I used my own formatting on this column and the table
is it working for excel report?
Yes. The second screenshot in my startpost shows the Excel Preview and that works.
yes i worked in excel its working fine am not sure about pdf lech_miszkiewicz will help you on this
PDFs from Excel are basicly Prints of Excel for the user settings running NPrinting Engine. One thing i can think of is that you have some printing settings where for example:
I suggest you do following to test my suspisions:
cheers
Lech
Hi Lauran - any updates regarding this?
I do have a difference when i change the workflow.
When i Preview the document to XLSX and then print it with the Qlik NPrinting PDF Printer. I do get the conditional formatting but i also get watermarks in all of the corners.
When i Preview the document directly to PDF. The conditional formatting doesn't work.
I am very certain the conditional formatting just doesn't work when i directly convert to PDF. Let me give you an example:
In the report I have conditional formatting with traffic lights that turn red when i go over time, Orange when I'm 5 days within today's date and Green when i still have time.
This is a preview in Xlsx
This is the preview when i preview to PDF
All the traffic lights are green.
What could be the next step to check?
I don't have the Bullzip PDF printer only the Qlik NPrinting PDF Printer
Hi,
strange - how do you calculate your conditional formatting? Does your report have to refresh something (for example recalculate data "on open"?
keep in mind that NPrinting PDF is a PRINT to PDF of you Excel so any actions "On Open, Macros etc" will not work.
regarding Bullzip printer - that is OK as you have NPrinting Printer. Make sure you check its settings when logged in as a NPrintng service account - as this is a user specific setting belonging to a user profile.