Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

mikecrengland
Contributor III

How do I format a cell value in Rich Text object

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?

2017-09-13_12-21-26.png

Thanks!

Mike

Tags (1)
1 Solution

Accepted Solutions
Employee
Employee

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

Hi Mike,

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

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.
3 Replies
Employee
Employee

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

Hi,

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

FormatString.png

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.
mikecrengland
Contributor III

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

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

Employee
Employee

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

Hi Mike,

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

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