4 Replies Latest reply: Oct 3, 2017 9:19 AM by Ruggero Piccoli RSS

    Powerpoint Text Box Conditional Color Formatting

    Rakul Alagu

      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.

        • Re: Powerpoint Text Box Conditional Color Formatting
          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.

          • Re: Powerpoint Text Box Conditional Color Formatting
            Frank Hartmann

            see attached files for macro solution

             

            hope this helps

              • Re: Powerpoint Text Box Conditional Color Formatting
                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.

                • Re: Powerpoint Text Box Conditional Color Formatting
                  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.