Stack Overflow
Stack Overflow

Questions tagged [custom-functions-excel]

For custom functions in Excel, written with JavaScript

For custom functions in Excel, written with JavaScript. Custom functions (similar to “user-defined functions”, or “UDFs”) are JavaScript functions built as part of an add-in. Users can see and run those functions in Excel alongside built-in functions like =SUM or =VLOOKUP. The functions will work on platforms that support add-ins: Excel for PC, Mac, and iPad, and also in Excel Online. See http://aka.ms/customfunctions for details.

147 questions
1
vote
1 answer

Excel custom function does not work across sheets

I'm quite new to writing excel custom functions, and I have encountered a strange behaviour that I can't seem to find explained when searching the net (although the amount of info is vast of course). Please bear with me. Here is a demo which shows…
danbae
  • 563
  • 2
  • 8
  • 22
1
vote
2 answers

Add excel custom functions to an existing excel add-in - Javascript Api

I have an existing excel add-in with UI (using react) and I would like to add some custom functions to it. When I add the add-ins in separate both work fine but when I try to merge them the custom functions don't appear. I assume that my issue is on…
José Salgado
  • 981
  • 10
  • 25
1
vote
1 answer

async customFunctions throws Unexpected message type at startup

I have a CustomFunctions javascript that does work perfectly with sync functions but as soon as i try using Async function i get: " Unhandled exception at line 21, column 707859 in…
Nicky
  • 70
  • 5
1
vote
2 answers

The AllFormFactors tag is not support in Visual Studio

I updated my office to insider version, and my customFunction is working. Then I added the AllFormFactors tag to my manifest.xml and Visual Studio gives me an error AllFormFactors is invalid