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
6
votes
1 answer

Submit add-ins with custom functions (update?)

I asked a question regarding submitting add-ins with custom functions 6 months ago. The conclusion at the moment was an add-in that uses custom functions cannot currently be published to the Office Store or via Office 365 centralized deployment. But…
SoftTimur
  • 5,630
  • 38
  • 140
  • 292
5
votes
1 answer

Excel failing to load basic custom functions add-in

First, environment: Excel Version 1905 (Build 11629.20246 Click-To-Run) Connected to Office 365 ProPlus Windows 10 Enterprise 10.0.16299 Build 16299 I've been trying to work with the Custom Functions API in Excel, but its consistently failing to…
Adam Schiavone
  • 2,412
  • 3
  • 32
  • 65
4
votes
1 answer

User Defined Function by JavaScript API for Excel

I have a library of functions written in JavaScript, for example myfactorial(n) can caculate the factorial of n in my way. I would hope to develop an add-in by JavaScript API for Excel, such that once a user loads the add-in, they could use the…
SoftTimur
  • 5,630
  • 38
  • 140
  • 292
4
votes
1 answer

Build an add-in and UDF for all the Excel versions

One data provider wants to develop an Excel add-in, these are the requirements: 1) it can be installed on desktop. It adds one menu and buttons in Ribbon, and it also provides some specific functions (to get real-time data, like Bloomberg…
SoftTimur
  • 5,630
  • 38
  • 140
  • 292
3
votes
1 answer

Define a custom function in Office.js add-in with React

I'm quite new working with the Office.js API. I created a React add-in project and I'm now trying to add a custom function which can simply add two cells just like the examples at create custom function in Excel. In this guide it says you have to…
Romina
  • 195
  • 1
  • 3
  • 12
3
votes
1 answer

How to reload Excel custom functions?

I've deployed the Excel-Custom-Functions sample successfully and can use the new JS functions. After changing the code/definition in customfunctions.js, I've restarted my web server, started Excel, inserted the custom functions from the Office…
Kai
  • 67
  • 5
2
votes
1 answer

Prevent Excel custom function running on file open

I am building an Excel add-in with many custom functions. They work fine, however, when I close and reopen the file, all functions are recalculated. Since each custom function makes an API request to my website and the data does not change…
Steve Fagan
  • 39
  • 4
2
votes
0 answers

How can I have multiple files with custom function declarations?

I would like to split up Excel Custom Function declarations into multiple files for code cleanliness. I changed the webpack entry.functions into an array and added the two separate files: module.exports = async (env, options) => { const dev =…
Antoine Dahan
  • 574
  • 2
  • 9
  • 23
2
votes
1 answer

How do I set environment variables for an excel add-in custom function?

I am building out an Excel add-in custom function and I'm struggling to figure out how to add environment variables to my project. Based on my research we don't have access to the manifest file at runtime and we also don't have access to environment…
Tim Hutchison
  • 3,483
  • 9
  • 40
  • 76
2
votes
1 answer

Excel Web Add-in Custom Function using Visual Studio

I have created Excel Web Addin project using VS 2019 and trying to incorporate Custom Functions into this project. Unfortunately all the documentation on MSDN refer to Yeoman generator so I am not sure either VS created project doesn't support…
user1455675
  • 81
  • 7
2
votes
1 answer

How can I create UI-less custom function Excel add-ins?

In the "Custom Functions' section of the Excel API documentation, there is a subsection for "UI-less custom functions". However, while they talk about authentication issues, how to debug, and runtime differences, they never explicitly state how to…
Permittivity
  • 229
  • 1
  • 12
2
votes
1 answer

Is there a way to customise `#BUSY` message on custom-function?

There are some users of our add-ins started asking for the meaning of #BUSY message while custom-function rendering data. Since, our product had a COM add-ins version on excel that showing another message. So, we're looking for a way to change…
nkrtarm
  • 31
  • 3
2
votes
1 answer

Excel JS Add-In - Shared Runtime Not Working

I'm trying to use the "Shared Runtime" to work with my Excel JS Add-In, but it's not working. Below are the docs that I have been reviewing. Below are screenshots of my project. It looks like I'm able to set an initial state but my custom function…
Tony Hunter
  • 31
  • 4
2
votes
1 answer

Office JS "Network Error" on sending data with post request in custom functions runtime on desktop (Edge 18)

I'm implementing Office JS custom functions which make requests to an external API via POST. Currently I'm getting an error "Network Error" using the custom functions runtime on desktop. This error only occurs when sending data (data config option…
phillipl
  • 21
  • 2
2
votes
4 answers

Converting "##h ##m" to ##.## hours

My time tracking app exports employee hours in the following format: xxh yym I'm looking for a way to convert this into a decimal number of hours. For example, input(06h 30m) return(6.5) Can't figure out a way to do it on Google Sheets or Excel. I…
Danielb1212
  • 23
  • 3
1
2 3
…
9 10