5,768 questions
1
vote
1
answer
65
views
How to restrict worksheet deletion in excel using office js
I want to restrict delete worksheet option from worksheet tab.
I couldn't find any thing about this so that I use one event which is available in office-js documentation. onDeleted
For that I use this ...
- 13
1
vote
0
answers
25
views
How to identify the list of users who is accessing the sharepoint excel file using the office excel web addin (code-type script)
How to identify the list of users who are active in the sharepoint excel file currently using the office excel web addin (code-type script)
identify if we have a user already working on the sharepoint ...
- 11
0
votes
0
answers
40
views
Excel.FormattedNumberCellValue is not working with custom formula response
{
type: Excel.CellValueType.formattedNumber,
basicValue: Number(value),
numberFormat: '#,##0.00',
};
this is how I am formatting my response in custom formula response returning in excel ...
- 324
1
vote
0
answers
26
views
word formatting issue : underlines continues while typing, next to previously underlined word
I have underlined the word through my JS add-in code by updating the Ooxml value, and to identify that word I have used the bookmark, (added the underline inside the bookmark).
The issue I'm facing is ...
- 21
1
vote
0
answers
249
views
OfficeJS - Outlook Web Add-in using OpenId Authentication
I've a VSTO Add'In running in Outlook to integrate some emails with a Web Application in .NET Framework 4.8 that uses openid authentication.
Now, Microsoft released the new version of Outlook that no ...
- 121
1
vote
0
answers
263
views
Outlook add-in generated from yeoman office add-in generator won't execute a function as intended
I'm trying to develop an Outlook add-in so I'm using the Yeoman generator for Office to generate a base template of an outlook add-in. I have sideloaded the add-in in Outlook.
Problem
This add-in ...
- 11
2
votes
1
answer
276
views
How to Fix "Office.js is Loaded Outside of Office Client" Warning in Outlook Web
I open an Office dialog for SSO and after login I successfully get the code from the URL using this code:
const currentUrl = window.location.href;
console.log(currentUrl);
const getCodeFromUrl = (...
- 102
1
vote
1
answer
74
views
Excel Add-in API functionality for storage, identity, and notes
I was directed to ask this question in this forum from here.
We are developing an Excel Add-in in Javascript and want to understand the API better.
Our application needs to store data in a way ...
0
votes
0
answers
512
views
Undo action not working properly in PowerPoint office add-in when inserting slide using insertSlidesFromBase64 method
I am developing a PowerPoint add-in wherein there is a functionality of adding a slide using the base64 string and the method insertSlidesFromBase64. Below is the code for the same:
await PowerPoint....
- 13
0
votes
0
answers
27
views
How to access the currently displayed / rounded off value of a cell in Excel using office js?
How can I access the currently displayed value of a given cell range but not the actual value of that cell? For example - see this below image, where I have not increased the width of the cell enough ...
- 1,292
1
vote
2
answers
65
views
Word runs both my source js file and the webpacked file, making all functions run twice (Office JS Yeoman)
Both taskpane.js and a packed version of the same file (75af049aa831360ba2a0.js) are running at the same time in my Office JS Add-in. I only want my file/functions to be run once.
Here is my webpack....
- 25
0
votes
1
answer
135
views
How to add notification message in outlook compose window with office js add-in with action button
I want to add notification message in outlook compose window. On this make 2 buttons one is Add and second one is Dismiss. when click on add button do call an API in commonds js. Is it possibale. i ...
- 33
0
votes
0
answers
31
views
How can I show some feedback from a Office.js Excel right-click command?
I have an Excel javascript add-in that includes some cell right-click actions, which can therefore be done when the add-in's task pane is not showing.
One of the actions should launch a pop-up dialog. ...
- 26
0
votes
0
answers
75
views
Replace old add-in custom function with new custom functions syntax in cell
Is there any way to replace old version of excel add-in custom formulas to the new version of add-in custom formula using excel javascript api and angular ?
like this : =OLD.GET(A5,B5,C5)
to this : =...
- 324
0
votes
1
answer
60
views
Sending Document Identifier from Office Add-in to Backend Service
I am integrating our backend service (built with Java Spring Boot) with a Microsoft Word add-in (built with Angular).
Current Setup:
Our backend service creates a DriveItem for a Word document
...
0
votes
1
answer
713
views
Office Script to format raw data and export to csv
I am new with Office Scripts. Here is what I am trying to accomplish
If A9 is 1, copy Raw_Data sheet F9 to J9 to temp sheet A1 to E1
If A10 is 2, copy Raw_Data E10 and I10 to temp sheet F1 and G1
If ...
- 25
1
vote
1
answer
139
views
getRange works when pasting from one sheet to next but not if getRangeByIndex
I am trying to understand why getRangeByIndex does not work when copy pasting from one sheet to another sheet
Here is the getRange script
function main(workbook: ExcelScript.Workbook) {
let temp = ...
- 25
0
votes
1
answer
88
views
Is this possible to add/update ribbon dynamically while runtime in word add-in created with officejs?
I am developing a Word add-in using OfficeJS and Angular. There is a requirement to update the ribbon text dynamically at runtime. Is this possible now?
I want to display the name of the current ...
1
vote
0
answers
97
views
How can I make my Excel add-in appear on iPad without sideloading?
I've developed an Office.js Excel add-in which has recently been deployed by my organisation through Integrated Apps. The add-in works perfectly on MacOS and through the browser, but I would like it ...
- 11
0
votes
0
answers
31
views
How do I detect the user switching accounts from within an Excel js add-in?
I'm building an Excel Js add-in taskpane that provides basic features for free and advanced features for licensed users. For that, I need to know who the current user is to look up if they have a ...
- 26
0
votes
1
answer
72
views
Is there a way to get mail body in Outlook with Office.js
I am trying to create a mobile add-in with Office.js and I am using OnNewMessageCompose event.
10 second after event launched, I am trying to get body with the code below but it doesn't work.
async ...
0
votes
0
answers
97
views
Event based action in Outlook web addin stops working when Admin deployed
I'm developing an Outlook web addin for Microsoft 365 accounts following Microsoft documents that consists of manifest.xml, webpack.config.js etc. It has:
a button we can click to display a ...
- 119
-2
votes
2
answers
62
views
Call a function from another script
I am trying to develop an Excel addin that would use Three.js.
For that, I have several files :
Home.html, my main html
3dModel.js, the script using three to create and display my 3d model
Home.js, ...
0
votes
1
answer
103
views
Outlook version 2403 doesn't show an addin when using requirement set 1.13
We have implemented a web addin using Outlook.js that shows in the task pane when an email is read. Now we need to use this addin also when multiple email are selected, so following the Microsoft ...
0
votes
1
answer
310
views
Can Office JavaScript API (Office JS) can be used outside of Office clients?
I am developing an independent application based on NodeJS and typescript which works on PowerPoint (read slides, metadata etc. ). I am interested in knowing if I can use office JS to process ...
- 31
0
votes
0
answers
100
views
Why my Office Add-In is not working with my Flask backend though the js code works in Script Lab and the localhost certificate is correct?
I'm trying to create a very simple Powerpoint Add-in to learn how to do so. The add-in is a Powerpoint taskpane that is supposed to write "Hello world" in the selected text frame. I have a ...
- 119
0
votes
1
answer
205
views
Office script to get data from table, filtered data and pasted into a new tab and new table
I have been trying to extract filtered data from my "PMs" table in my excel, I need to filter column D for statuses that are equal to "WSCH" or "WAPPR" or "INPRG&...
0
votes
0
answers
93
views
Use query string parameters on Word add-in SourceLocation(manifest.xml)
I want to use query string parameters on SourceLocation on a Office add in(Word add in). I can add the query string parameters inside the manifest.xml file. How can I read them inside taskpane.html ...
- 344
0
votes
0
answers
53
views
Insert text into a slide with the javascript office add-ins API doesn't work
Anyone can help me with the javascript office add-ins API for powerpoint?
I am trying to add a sideload add-in that just has a button to some text on a slide. And this works perfectly fine when I put ...
0
votes
0
answers
31
views
Formatting getting disturb while opening file using base64(Alignment,Font Colour,FontSize etc.)
My Environment
Platform : PC desktop
Host: Power Point
Office version number: Microsoft® PowerPoint® for Microsoft 365 MSO (Version 2404 Build 16.0.17531.20140) 64-bit
Operating System: Windows 11 pro
...
- 15
0
votes
0
answers
65
views
Specifying Application ID URL
Context
I'm building an Office 365 add-in - to be run in Outlook, both desktop and web -, and I'm at the stage where I want to try logging the user in and getting an access token. However, I'm running ...
- 653
0
votes
0
answers
66
views
Excecute task pane code without showing task pane at startup
I'm trying to figure out if it's possible to execute code in my task pane without rendering the task pane. I've reviewed all the relevant documentation here:
https://learn.microsoft.com/en-us/office/...
- 51
1
vote
1
answer
59
views
How to find Merge cell for givenNamedRange(NamedItem)
I want To create One object in which I want to store Cell address and there column and row index.
I have achieve that using this code but in mereged cell I'm facing issue. If A1 and B1 Cell is ...
- 15
0
votes
1
answer
34
views
Word Ribbon Action Function Is Not Triggered
I am working in an add-in project using taskpane. I created a custom tab and identified my buttons and function actions in the manifest file as described:
<bt:Urls>
<bt:Url id=&...
-1
votes
1
answer
282
views
How to publish a Word addin to Microsoft AppSource
I'm trying to push my Word plugin to AppSource:
I followed the documentation and created an account on the Microsoft Partner Program: https://learn.microsoft.com/en-us/office/dev/add-ins/publish/...
- 2,402
1
vote
0
answers
85
views
Remove specific text block from word document
I am creating a Word add-in that writes in a document while generating some text.
The problem is that sometimes the document already has something above the generated text, so I need to keep that ...
0
votes
1
answer
142
views
How to upload and test an Excel add-in using Azure blob storage
I've developed an Excel Add-In which, as I understand it, I need to upload to an Azure blob storage and generate an URL with a SAS key that I then share with the certification team. This will be a ...
0
votes
1
answer
80
views
How do I get the footnote number in Word document?
In office-js when I create a footnote, it returns a Word.NoteItem object, but there doesn't seem to be any obvious way to get the index of the footnote.
const footnote = range.insertFootnote();
// ...
0
votes
0
answers
339
views
Report Message - Outlook Add-In opens Browser and doesn't work correctly
I'm trying to use the "Report Message" Outlook Add-In which I think is MSFT developed to report a "Phishing" e-mail but it's opening the Edge browser to the following URL and not ...
- 2,890
1
vote
1
answer
65
views
Is there any way to select the Simple Markup option by default using OfficeJS?
I am trying to set my default on load view of the word document to simple markup but there seems to be no direct function for it in OfficeJS. Does anyone have any idea how to achieve it or any ...
- 29
0
votes
1
answer
45
views
issue word document font size and font family is not proper according templates
Get doc file blob format and base64 string
let url = `${location.origin}/assets/templates/test.docx`;
fetch(url).then(response => response.blob()).then((base64String) => {
blobToBase64(...
0
votes
1
answer
351
views
Create New Addin using React js(typescript) in visual studio 2022
I am developing an add ins in visual studio 2022 using java-script.
I want to upgrade my add ins with React (type script) I read documentation in that I can create add ins in visual studio code using ...
- 13
0
votes
0
answers
45
views
Creating a consistent formula format painter with Office.Js
I am trying to develop a consistent formula painter with office.js for purposes of reviewing financial models. The script is meant to be run on the active sheet and will color code it using the ...
- 1
0
votes
1
answer
49
views
How do I tell that the new inspector window was the result of a user clicking Reply or Forward button using Office JS in Outlook?
In Outlook COM Add-ins, we can catch the Reply/Forward events but for Web/JS Add-ins, there doesn't seem to be such events exposed. The closest one is OnNewMessageCompose and OnMessageCompose but ...
- 2,105
1
vote
1
answer
136
views
Microsoft Outlook Add-in - Microsoft 365
I'm experimenting with an Outlook Add-in to install it on both Outlook Web and the Outlook Desktop Application. When I run the sample code using npm run start, Outlook redirects to the sign-in page. ...
- 53
2
votes
1
answer
275
views
Office.ribbon.requestUpdate throws SharedRuntime ID missing error
I am trying to develop an excel addin using Office JS Api and Angular. I want to achieve enable/disable ribbon controls functionality in desktop version.
when I use Office.ribbon.requestUpdate method ...
- 324
1
vote
1
answer
275
views
Replace and redline certain substrings from a paragraph in Word using Office.js in Add-In
I have a paragraph present in the Word (Office 365). I can replace the whole paragraph, but I wanted to replace and redline only certain substrings in the paragraph.
Note:- By redline, I mean that the ...
- 37
3
votes
1
answer
141
views
Show text on ribbon in excel office js
I am developing excel-addin using angular and Office JS API.I want to display a text message in angular toast and normal text on the right side of the ribbon/menu bar of excel.
I want functionality ...
- 324
0
votes
3
answers
58
views
Sometimes Dialog Box content is not display
async function openDialog(event) {
let url = 'localhost:4200/#/openDialog';
await Office.context.auth.getAccessTokenAsync(gettoken);
function gettoken(res) {
...
0
votes
0
answers
41
views
Force refresh from outlook web addin to show changes made by graph api (attachments added)
I've got an add in for outlook which is successfully updating the attachments via the graph API. However, it doesn't show up in outlook desktop client unless you close the client and re-open it and ...
- 1,070