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

Have custom functions and a task pane at the same time

I am following this link to try custom functions. The following manifest does enable the custom functions:
SoftTimur
  • 5,630
  • 38
  • 140
  • 292
2
votes
1 answer

Excel JS custom function does not return a matrix

I am trying to implement an Excel custom function (JavaScript) that returns a matrix of strings. According to Create custom functions in Excel (Preview) the resultDimensionality has to be set to matrix in this case. To keep it simple I've just…
Kai
  • 67
  • 5
2
votes
1 answer

Excel-Custom-Functions,Contoso.ADD42 function is not appearing in Excel

I followed steps added here Excel-Custom-Functions. Hosted Customfunctions.html and customfunctions.js in IIS web app with self created SSL certificate. I hosted only above mentioned files. I created a folder in C drive, copied manifest with…
Ravi Anand
  • 5,106
  • 9
  • 47
  • 77
2
votes
1 answer

Excel-Custom-Functions sample code not working because of undefined ExtensionPoint "CustomFunctions"

The manifest.xml in the Excel Custom Functions sample does not validate because the ExtensionPoint CustomFunctions does not exist in TaskPaneAppVersionOverridesV1_0.xsd. Resulting error message is: This is an invalid xsi:type…
razorrahim
  • 21
  • 1
2
votes
2 answers

whats the alternative to user defined functions in excel online office.js javascript lib

I am trying to develop the office excel add-in, similar to one i had for office 2013. in that i was using user defined function created using "VBA" and could fetch the data in the cells. The advantage i had was 1. if i close my excel file and open…
shyam_
  • 2,370
  • 1
  • 27
  • 50
2
votes
2 answers

Programmatically Creating Custom Functions in an Excel Add-in using JavaScript

I'm in the process of "translating" a Google Sheets add-on to an Excel add-in. I have trouble finding if and how custom functions would be programmatically created using JavaScript in an Excel add-in (which btw is really simple for Google…
Alexandre Raffin
  • 53
  • 7
1
vote
0 answers

Excel Custom function returns #BUSY

I am using Script Lab for defining custom function in Excel. Even the most trivial function returns #BUSY result. This is test funcition that returns #BUSY error. /** @CustomFunction */ function add10(x: number): number { return x + 10; } I am…
Davit Margvelashvili
  • 51
  • 1
  • 5
1
vote
1 answer

Excel custom functions show BUSY! but async function is not called

I have an Excel Add-in having custom functions and taskpane. My client created a workbook having multiple sheets using my custom functions approximately 3500+ function calls in current workbook. When a user opens this workbook, I need to recalculate…
Kashif
  • 85
  • 8
1
vote
0 answers

Excel Add-in dialog box not sending data to Excel Desktop

I've created an Excel add-in using Yeoman and it has taskpane and Custom functions. For my custom functions I use a dialog box using displayDialogAsync method to open the dialog box and display a list of data which user can select and that selected…
user21064709
  • 11
  • 2
1
vote
1 answer

Excel Refreshes whole sheet even when a single cell is changed

I am working on an Excel Add-in and have created some custom functions in it. Now my user has created some functions (150+ custom functions) and all of these custom functions have parameters as references to other cells in sheet. When user updates…
Kashif
  • 85
  • 8
1
vote
1 answer

Excel Custom functions inside Excel Add-in

I have a office add-in generated using Yeoman template for Taskpane type using Angular Framework. How do I add custom functions to this project and what changes do I have to make ? I have already tried this using shared runtime and followed these…
Ruturaj Maggirwar
  • 9
  • 3
1
vote
3 answers

Longest repeated odd number

Consider: let N = 12 let arr = [1, 1, 1, 1, 2, 2, 2, 2, 2, 1, 1, 1] Your task is to find the maximum number of times an odd number is continuously repeated in the array. What is the approach for this? This is the hint: 1 is repeated 4 times from…
Nawab Pvt
  • 11
  • 2
1
vote
0 answers

Excel custom function not working in Online Excel

I have created an excel custom function with a shared runtime environment. It's working fine in the desktop app, but when I run the same project on the server it's not working. My excel function is not working online. I don't know why its behavior…
Shiv Yadav
  • 467
  • 2
  • 11
1
vote
0 answers

cache storage in Excel Custom Function

I want to store my searched values in key and pair in excel custom function. and when I search again with the same value it should return from the cache storage. How can I do that? When I use office runtime storage it shows me error that is "wrong…
Shiv Yadav
  • 467
  • 2
  • 11
1
vote
1 answer

Title of Office.context.ui.disaplogAsync

I want to change the title of dialog box of office. I am not able to change the name of title. It display the whole url. How to add the title instead of URL.
Shiv Yadav
  • 467
  • 2
  • 11
1
2
3
…
9 10