topic How do I format a cell value in Rich Text object in Qlik NPrinting

How do I format a cell value in Rich Text object

mikecrengland — Wed, 13 Sep 2017 18:23:17 GMT

Hello All -

In NPrinting 16 using Pixel Perfect report, I'm trying to create a Rich Text object with a few different cells in the text. My tables have the values formatted as ##.##%, but they come through as a float. How do I format those cell values?

Thanks!

Mike

Re: How do I format a cell value in Rich Text object

Ruggero_Piccoli — Thu, 14 Sep 2017 10:24:07 GMT

Hi,

Open the cell smartag (the small arrow in the upper right corner) and set the Format String.

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: How do I format a cell value in Rich Text object

mikecrengland — Thu, 14 Sep 2017 12:54:17 GMT

Thanks, Ruggero,

Does that only work if the cell is on it's own? If it needs to be part of a paragraph, can it still be formatted?

Thanks!

mike

Re: How do I format a cell value in Rich Text object

Ruggero_Piccoli — Thu, 14 Sep 2017 12:58:44 GMT

Hi Mike,

It is a property of the cell, so I think it will works everywhere you place the cell.

Best Regards,

Ruggero

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