Powerpoint Text Box Conditional Color Formatting

[bluecarbon]

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.

[Ruggero_Piccoli]

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.

[Frank_Hartmann]

see attached files for macro solution

hope this helps

[Ruggero_Piccoli]

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.

[Ruggero_Piccoli]

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.