python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - custom-functions-excel

Trigger for data change by Excel Streaming function

I am build a streaming function with Excel add-in following this example. Everything works so far. However, I would like to change the color of the cell depending on the latest value. I am thinking ab...
test-img

Steve Fagan

office-js

office-addins

excel-addins

custom-functions-excel

Votes: 0

Answers: 1

Latest Answer

I have tested it on my side and you are right that onChanged event does not trigger when the returned value of the streaming function changes. We'll track it on our backlog. The Excel JavaScript API C...
test-img

JHJ-MS

How to pass object or json stringify to custom function in office js?

I am working on an office js add-in now I have created a custom function that works as expected but when I pass JSON stringify string in the custom function it does not work and does not give any erro...
test-img

Vineet

json

office-js

office-addins

custom-functions-excel

Votes: 0

Answers: 2

Latest Answer

If you want to let Excel treat a double quote as literal text in a formula, you need to escape it. Try the following code to see if it can help: await Excel.run(async (context) => { const wb = ...
test-img

Rundong-MSFT

Posts

Questions

Blogs

Jobs