Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

bluecarbon
Contributor

Powerpoint Text Box Conditional Color Formatting

Hi,

Is there a alternate way to implement conditional color formatting to a text box that needs to be displayed in a powerpoint?

Nprinting version : 17.3

Thanks,

Rakul.

Tags (1)
4 Replies
Employee
Employee

Re: Powerpoint Text Box Conditional Color Formatting

Hi,

I think the only way is to create a text object in the original QlikView or Qlik Sense app and import it as an image into the PowerPoint report.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Frank_Hartmann
Honored Contributor

Re: Powerpoint Text Box Conditional Color Formatting

see attached files for macro solution

hope this helps

Employee
Employee

Re: Powerpoint Text Box Conditional Color Formatting

Microsoft Office macros are not supported by Qlik NPrinting 17 at the moment, they are supported by Qlik NPrinting 16.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Employee
Employee

Re: Powerpoint Text Box Conditional Color Formatting

Microsoft Office macros are not supported at the moment in Qlik NPrinting 17. You cannot save a template in a macro enabled format (for example .xlsm) so you cannot get final report with macros.

Qlik NPrinting 16 supports Office templates with macros. In this case the VBA code is copied from the template to the created reports and never executed. You can configure the template to execute the VBA code when the report is open by a user. Note that if, for example, you add a VBA macro that format something in an Office report and you select PDF as output format, the generated PDF will not contain the updates made by the macro because it is not executed automatically.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Community Browser