486676_en-US

liliconcom

personal presets for "new formula column" right click menu

I often have to apply the same formula to correct input data.

Is there a way to define a list of personal formula presets that can be quickly used via the "new formula column" right click menu?

 

e.g. 

Num(Substitute( ..., ",","."))

to convert columns with comma decimal separator to numbers - just with a single click.

(Very convernient till there will be some settings to choose in the separator in the csv input dialog

 

User InterfaceRe: personal presets for "new formula column" right click menu - Status changed to: Acknowledged

@HolgerSp - Thank you for your suggestion! We have captured your request and will take it under consideration.

Re: personal presets for "new formula column" right click menu - Status changed to: InvestigatingRe: personal presets for "new formula column" right click menu

Hi @hogi! I wanted to make sure you are aware that you can define a custom function and this allows you to add it to the new formula menu. You have to define the custom function in your startup.jsl or an addin (because the definition doesn’t persist). Would this fulfill your request? 

Re: personal presets for "new formula column" right click menu - Status changed to: Not Planned For NowRe: personal presets for "new formula column" right click menu

Hi Sarah,

 

custom functions are fine.
I fond them after filing the request.

 

The request can be closed.