topic NPrinting Cell Format in Qlik NPrinting

NPrinting Cell Format

ijulias — Sat, 16 Nov 2024 02:49:57 GMT

Hi everybody,

I would like to change the number format of a Cell depending on the cell value.

In "Edit Cell -> Format", I've tried to put this, but it doesn't run:

If (Name_cell > 50, num(Name_cell,'0.0'), num(Name_cell,'0.00'))

Anybody knows if it's possible to do it?

Thanks.

Re: NPrinting Cell Format

Frank_S — Fri, 23 Aug 2019 19:05:50 GMT

Hi @ijulias

Inside the NP template editor or even outside the template editor a new excel worksheet, try your formula directly on the xlsx spread sheet cell where you inserted the NPrinting tag to or in blank worksheet or try to use the custom format editor in Excel.

If it doesn't work there as a custom cell format, then it surely won't work in the location that you are trying to do it. If it does, then it will hopefully work with NP as well.

Hope this helps....

Re: NPrinting Cell Format

Ruggero_Piccoli — Mon, 26 Aug 2019 06:52:27 GMT

Hi,

Did you unflagged the "Keep Source Format" option?

If no, select the cell/column in the treeview on the left side then bottom in the properties remove the flag to the Keep source format option only for the specific cell or column.

Best Regards,

Ruggero

Re: NPrinting Cell Format

ijulias — Thu, 12 Sep 2019 08:22:42 GMT

Hi @Frank_S ,

I've tested you said in a new spread sheet and it runs, but in NP it doesn't run...

I suppose I'm doing something wrong...I'll try to discover it.

Thanks a lot!

Re: NPrinting Cell Format

ijulias — Thu, 12 Sep 2019 08:25:29 GMT

Hi @Ruggero_Piccoli ,

I unflagged the "Keep Source Format" option.

Thanks for the advice, I'll try in the way @Frank_S suggested.