Hello Brian,

Thank you for posting in our community.

In order to provide you with more accurate support I will need some additional information regarding your scenario. Can you please answer the following questions:

1. Are you using igGrid and you would like to format its cell values according to you custom function? If this is the case I would suggest you having a look at our Column Formatting topic which explains different ways for displaying cell values. Please keep in mind that all formatting operates on the grid rendering phase and do not affect the underlying data source.
2. If you are looking for some formatting outside the scope of the igGrid can you please provide more details in order to explain what you are trying to achieve.

Looking forward to hearing from you.

About your scenario - I would suggest for you to take a look at the ExcelCalcFunction and see if this would do the work for you- https://www.igniteui.com/help/api/2018.2/ig.excel.ExcelCalcFunction.html#methods

Meanwhile, I have contacted the team that is working on the Spreadsheet control and I will update you with any additional information on your scenario as soon as possible.

Thank you once more for choosing Ignite UI!

Best regards,
Alexander

As a temporary workaround, while the feature is implemented, you can use this example: http://jsfiddle.net/fcj2dupv/

The example demonstrates hot to write a helper function in that page that creates a new derived calc function. Then the usage is 2 parts. One is to define the function.

e.g.

createCustomFunction("SumTwo", 2, 2, function(numberStack, argumentCount) {
                var second = numberStack.pop();
  var first = numberStack.pop();
  
  return new $.ig.excel.ExcelCalcValue(first.toDouble() + second.toDouble());
});

The other is to register an instance of it with the workbook:

function setWorkbook() {
     if ($("#spreadsheet").igSpreadsheet !== undefined && workbook != null) {
       workbook.registerUserDefinedFunction(new $.ig.CustomFunctions.SumEx());
       workbook.registerUserDefinedFunction(new $.ig.CustomFunctions.SumTwo());
 
        //load specific workbook
       $("#spreadsheet").igSpreadsheet("option", "workbook", workbook);
    }
}

Note that CustomFunctions are prefixed to avoid any naming collisions with any of the predefined classes. Note also that writing a custom function can be rather involved since the arguments can be raw values, arrays or references and it’s really up to the function to properly handle all these things based on how it needs to function.You would likely need to look at the various members of the ExcelCalcValue class to see how to identify the value of the arg and how to extract information from it if it’s anything more involved than what I showed in the 2 examples in that fiddle.

I hope this would meet your scenario requirements. However, once the feature is implemented in the future version, it is strongly recommended to switch to using it instead of this workaround.

If you face any other issues - please let us know!

Best regards,
Alexander