Questions tagged [office-js-helpers]

A collection of helpers to simplify development of Office Add-ins & Microsoft Teams Tabs

A collection of helpers to simplify development of Office Add-ins & Microsoft Teams Tabs (from https://github.com/OfficeDev/office-js-helpers)

113 questions
2
votes
0 answers

Is there any Office.js API to get user input

In task pane of our Office.js WORD add-in, we need to get a user input and display in the document. Is it even possible to get user input in an Office.js add-in. If so, is there any Office.js API for that?
nam
  • 21,967
  • 37
  • 158
  • 332
2
votes
1 answer

OAuth using login.microsoft.com returns inconsistent tokens

I'm using office-js-helpers Authentication library. Using the Microsft Azure AD 2.0 Converged auth endpoint, I have tested logins from both a AD user (belonging to an AD tenant) and a ...@gmail.com account registered with Microsoft. They both return…
1
vote
0 answers

error TS2339: Property 'comments' does not exist on type 'Worksheet'. microsoft /Office-js

I have updated "@microsoft/office-js" from ^1.1.25 to "^1.1.70" and I'm trying to use comments in my angular project. I have added CDN link in index.html file head tag of the project. I want to use add() method of…
neha
  • 11
  • 1
1
vote
1 answer

Office Js - Excel Set a Cell with Base64 Content

We are using Excel Add-in side loaded for our application. I am trying to Set a Cell Value in Excel with Base64 Encoded content (that has formatted content). I see example of how set base64 encoded image but not the text content with formatting. I…
user2596892
  • 93
  • 1
  • 9
1
vote
2 answers

How to add Customized comment in MS Word using OOXML?

I am creating a word custom add-in. In that user can able to add custom comments with color, bold, or highlight or set other possible options. But when I try to use directly Hello This is comment and also try with the below option. When the…
Deep Soni
  • 431
  • 4
  • 24
1
vote
1 answer

Can Events in Excel be registered without a button click?

I am trying to create events that are registered when the Excel add-in is first loaded up. I'm not sure how to get around this since I've only seen examples where they are registered with a button click.
1
vote
1 answer

Is there any method available in officejs to close the word document ? Or "how we can open word document in same instance"

Is there any method available in officejs to close the word document ? Or "how we can open word document in same instance (if there is an instance already open)".
1
vote
1 answer

How to make a Rest API call from Office JS using Yeomen Generator for Angular framework?

I have tried to refer a project Angular Reference Project Link from MSFT and now i am trying to call a rest API from Angular and i am trying to create a singleton service, but whenever i try to run the application with Singleton the application…
Aagam Doshi
  • 155
  • 2
  • 14
1
vote
2 answers

Set Dropdown Value Back to Placeholder or Very First Option After onClick Event on a Button?

In the following code, I have a Dropdown and a Button. Once you select an option in the Dropdown and click the Button, that value will be sent to Excel in the active cell. After sending this data to Excel, can I set the Dropdown back to the…
1
vote
1 answer

How to Convert String to Range After Awaiting Context.sync?

In the following async function, I am getting the active cell in Excel and then loading the row index. After the context.sync I am creating a string called "newRange". Is there a way that I can set the current range to my "newRange"? I need to…
Ethan
  • 808
  • 3
  • 21
1
vote
0 answers

Trying to open object browser dialog using Office js Addin

I'm developing a Word Add-in (Word API + Office.js) and I'm wondering if it's possible to open word embedded object browser dialog Currently my word template has few content controls with data, now i am trying to open object browser dialog to attach…
1
vote
1 answer

How to change the error bar values in a bar chart in Excel script lab?

I am trying to draw a horizontal boxplot in Excel using Script Lab. For this, I first created a stacked bar chart and made the first and the last bars as transparent. Now I am trying to add error bars to the data bar in the middle using the…
Vinni
  • 23
  • 1
  • 6
1
vote
1 answer

Word web Add-in: detect document Close

I'm developing a Word Add-in (Word API + Office.js) and I'm wondering if it's possible to get notified when the user click on Close button of word application Currently my word template has few content controls with data, i am saving the content…
1
vote
0 answers

How to authenticate Excel Web Add-in with IdentityServer4 on .NET Core 2.2 using office-js-helpers

I am attempting to authenticate a Excel Web Add-in(custom funcitons) with IdentityServer4 on .NET Core 2.2 using office-js-helpers in Visual Studio 2019 Adding an endpoint for my own IdentityServer, im pretty sure i need to set a clientSecret? But…
1
vote
0 answers

Edge browser is blocking Office-Helpers-Js library from closing authentication dialog after getting the token

Inside an Excel add-in, I obligate the user to authenticate himself against an Azure AD app using the Office Helpers Library. When the add-in is launched, I invoke the "authenticate" function of the Authenticator instance, it opens the Login Dialog…