5,768 questions
1
vote
0
answers
38
views
Filter on worksheet columns re-triggering excel office.js custom functions even when it is not volatile functions
Excel re-triggers custom functions created in office.js api addin, but from documentation it should only re-trigger the formulas which are volatile function and in office.js api to specify custom ...
- 324
-1
votes
1
answer
52
views
Gathering and pulling data from an Excel file into a Word file [closed]
Trying to develop a Word add-in such that when provided an Excel file, it can access said file and gather the contents of cells (already known/specified by default, not by the user) and then insert ...
- 27
-4
votes
0
answers
40
views
Outlook OnAppointmentSend event triggering for regular emails instead of only appointments [closed]
I'm developing an Outlook add-in using Smart Alerts with the OnAppointmentSend event. The add-in is supposed to validate and process only appointments/meetings, but the loading message "Add-in is ...
0
votes
1
answer
56
views
Outlook Office addin onMessageSendHandler on Mac and Web
I'm currently struggeling to get my onMessageSendHandler to work on Outlook Web and Mac. When the user sends a message, I want the user to have the option to open taskpane instead of sending the mail. ...
- 1
0
votes
0
answers
53
views
New Outlook ignores (or overrides) button image and text labels in manifest
We have a published Outlook Add-In that has been in the Microsoft Store for quite a few years.
We now noticed that, when switching to the New Outlook, that our primary button that appears in the ...
- 31
3
votes
0
answers
89
views
How to properly insert an image into an image placeholder shape in PowerPoint?
I have a taskpane add-in which lists a set of images, and has a button to insert images into the current slide. In other words, my add-in mimics the built-in stock images taskpane.
In the built-in ...
- 480
0
votes
0
answers
114
views
Office JS displayDialogAsync Error : TypeError TypeError: Cannot read properties of undefined (reading 'register')
I'm developing a webAddin on Excel and I'm having an issue, I have a taskpane that opens from the button in the ribbon, but I wanted to change to a Display, I have this code in the commands.js
...
0
votes
0
answers
67
views
How to get text from all selected cells in a table?
I'm working on a Word add-in using the Office JS API and am building a converter that changes the selected text into a different format.
I’m not encountering any issues when the selection is a ...
1
vote
1
answer
56
views
Office 365 PowerPoint add-in not showing up online, but works on desktop [closed]
We built Office Add-Ins for Outlook, Word and PowerPoint. They mostly look and work OK on the desktop and online. We load them via Admin Portal => "Integrated apps". This works for ...
- 12.8k
1
vote
1
answer
126
views
How to hide / show slides?
I am trying to add a sideload add-in doing some automation in powerpoint.
I couldn't find a command or property in the powerpoint office add-in to hide/show slides.
Does anyone know how to hide / show ...
0
votes
0
answers
49
views
Office Outlook Add-in not opening the compose SourceLocation when redacting a new email
We are building a new Office Add-in for Outlook, but we are not capable of opening the correct SourceLocation when redacting a new email. Our manifest does have the ExtensionPoint for the compose ...
- 1
0
votes
1
answer
64
views
Outlook addin with office.js giving Host error with code 5000 for item.sendAsync()
I'm trying to send an email using the Outlook's office.js API's item.sendAsync() method which triggers on custom send button added on taskpane from a task pane add-in. However, I'm getting a Host ...
- 101
0
votes
1
answer
37
views
Add-in Error due to an updated manifest being available in the Add-in store
I published a new manifest version to the add-in store, and since then one of my users sees the following error.
This user is in a company whose IT department manage availability and installation of ...
- 21
2
votes
0
answers
56
views
excel office.js addin custom formulas are showing #Name error
Excel office.js custom formulas are showing #name error even if add-in is installed.it is working for some scenarios but not working for some for same formulas it is giving #name error what could be ...
- 33
2
votes
0
answers
72
views
Excel office.js addin is showing pop-up for accept and continue even after installing add-in multiple times
Excel showing accept and continue pop-up multiple times even after installing. it shows pop-up in middle of some operation and if it is not clicked on accept it uninstalls add-in. it was not showing ...
- 324
0
votes
0
answers
38
views
Office.js WebAddIn - How to set worksheet Outline setting for summary rows above detail?
I'm migrating a VSTO Excel AddIn to WebAddIn.
In C# I can place the outline expand/collapse buttons above the grouped rows by setting:
worksheet.Outline.SummaryRow = XlSummaryRow.xlSummaryAbove;
By ...
- 21
0
votes
0
answers
32
views
Service Worker is terminated immediately after event.completed, so final network call never runs (Classic Outlook Win32 & New Outlook for Mac)
Summary
I have an Outlook on-send add-in that modifies the current message and then calls event.completed({ allowEvent: true }). Right before completing, I post a final message to a Service Worker so ...
- 11.4k
3
votes
0
answers
96
views
Why is my Unified Manifest Add-In working in New Outlook but NOT in Classic Outlook?
I've created an Outlook Add-In using the Unified Manifest. It is working nicely in New Outlook, however even though my task pane buttons display, the Add-In does NOT work in Classic Outlook.
Any ideas ...
- 1,484
1
vote
1
answer
89
views
Office JS Partition Key - What is it partitioning by?
In my testing on the desktop, Office.context.partitionKey is undefined.
In the docs, it states:
Gets a partition key for local storage. Add-ins should use this
partition key as part of the storage ...
- 30.1k
1
vote
0
answers
77
views
Custom Format footer with Office Script
I'm using Office Scripts for Excel on the web and trying to insert a logo image into the footer and apply custom text formatting (font, size, and color).
So far, I've successfully set the font and ...
- 123
0
votes
0
answers
45
views
How to open Taskpane automatically on Browser on Excel with Office JS?
Is it possible for Excel to automatically show the task pane as soon as the workbook opens in the browser?
I followed the steps in the link, and only Word automatically opens the task pane with the ...
0
votes
0
answers
142
views
Outlook Add-in Sideloading fails with AADSTS500200 on Personal Account & NoMailboxAndNoLicenseAssignedError on Org Account
Hello Stack Overflow Community,
I am developing an Outlook Add-in using the official Yeoman generator (yo office) with React and TypeScript. I am currently blocked during the development and testing ...
- 1
1
vote
0
answers
65
views
Word Addin - Get version from the manifest file
We have developed a Word Add-in using Angular and are currently using OfficeJS for performing Word-related operations.
We want to programmatically access the manifest version (i.e., the version ...
- 1,474
1
vote
0
answers
65
views
Taskpane is not loaded when opening PPT and it was left opened
I have developed a web-based add-in for Powerpoint/Word/Excel using Fluent UI React. The add-in has a taskpane with different tabs.
I have noticed that in PowerPoint Mac if I close the app with the ...
- 480
0
votes
1
answer
106
views
Outlook OfficeJs Addin - Webmail does not show "TabDefault" button
I'm developing Outlook AddIn and I have a taskpane for MessageReadCommandSurface with one button.
That works fine in Outlook Windows Desktop Classic, I see button on the ribbon.
However, on outlook ...
- 11
1
vote
1
answer
79
views
Unable to use open extension on drive items
I am trying to make use of the following Microsoft Graph API endpoint to add an extension to a .pptx file:
POST https://graph.microsoft.com/v1.0/drives/{drive-id}/items/{item-id}/extensions
Content-...
- 13
0
votes
0
answers
162
views
Why is my addin working in outlook classic but not in the new outlook/outlook web?
I created a outlook addin following the samples in the microsoft documentation with the unified manifest.
The addin works perfectly in outlook classic but in the new outlook, the ribbon buttons don't ...
- 13
1
vote
1
answer
76
views
Resolve a range specification with worksheet name in Excel JS API?
Given these legal Excel range specifications as strings:
SheetName!A1
'Sheet Name'!A1
'Sheet!Name'!A1
'Sheet''Name'!A1
'''Sheet Name'''!A1
'Sheet''!Name'!A1
is there a way to get a Range object ...
- 304k
-1
votes
1
answer
50
views
Override native Drag-and-drop to allow insert images with better resolution
I have a Powerpoint taskpane add-in with a list of images. Right now I have an insert button to add the selected images into the current slide like in built-in Stock images. I added an onDragEnd ...
- 480
0
votes
0
answers
45
views
Outlook Addin for Outlook for IOS
I have written an Office.js Outlook Addin which is working for Outlook Desktop, New Outlook and Outlook for Web. The addin launches a task pane.
I want to extend this to Mobile particularly for ...
- 177
0
votes
0
answers
88
views
Eyedropper on windows can not pick a color from a taskpane add-in
I have been working on a add-in that provides a color palette that users can use to pick custom shades of a particular color. Although, on the browser and on MacOS the eyedropper can hover over the ...
- 480
0
votes
0
answers
51
views
InvalidArgument Error when using copyToNotebook() in OneNote JavaScript API
I usually create OneNote APIs while looking at this site (https://learn.microsoft.com/ja-jp/javascript/api/onenote?view=onenote-js-1.1), but I'm having trouble with copyToNotebook().
It says that the ...
0
votes
0
answers
84
views
makeEwsRequestAsync return error 9020 in Outlook web or menu item is getting null in (classic view) when creating an .eml file using Office.js?
let mailbox: any = Office.context.mailbox.item;
let envelope = `
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope
xmlns:xsi=&...
1
vote
1
answer
206
views
How to set a hardcoded formula to dynamic in Excel office script?
I're recorded an action in office script and this is one part that was recorded.
selectedSheet.getRange("AN4:AN5").setFormulas([["=AN2-AM2"],["=AN3-AM3"]]);
I wanted to ...
- 757
1
vote
2
answers
202
views
How to get last column in specific range in Office Script?
I have values in range A1:E10 and I'd like to get the next empty column in that range (excluding headers). In this case last column used is "C" and next empty column would be "D".
...
- 757
1
vote
0
answers
80
views
How to replace images in a Word document using Office.js while preserving formatting and layout?
I'm developing a Word Add-in using Office.js (with an ASP.NET Core backend and Angular frontend). I need to fill in values—including images—into content controls in an existing Word document template.
...
0
votes
0
answers
55
views
Notifications in PowerPoint add-ins
I'm using Office.addin.showAsTaskpane() to open my PowerPoint taskpane add-in on a particular tab via custom Ribbon buttons. The problem is when a user click a button there is no immediate feedback to ...
- 480
0
votes
0
answers
247
views
Is it possible to sideload Office web extension manifest.xml in production mode?
I am developing an Office Add-in using Office.js. This new extension will be a re-implementation of an old COM Office extension. The problem I am facing right now is how to install the extension for ...
0
votes
1
answer
61
views
Create a basic web content add-in without Visual Studio and a Windows machine
I'm trying to develop a Content Add-in following the official documentation. The implementation section states that only few changes are needed:
For the OfficeApp element, set the xsi:type attribute ...
- 480
1
vote
0
answers
69
views
How to delete attachments in Exchange On-Prem add-in using Office.js (makeEWSRequestAsync or alternative)?
I’m developing an Outlook add-in for an Exchange On-Premises (On-Prem) environment. The goal is to allow users to delete email attachments directly from the add-in.
However, I’ve run into the ...
- 11
1
vote
0
answers
54
views
Unable to get attachment with office.js
I am building an Outlook web add-in using Office.js and I need to fetch email attachments programmatically in Outlook Web App (OWA).
However, I encountered the following error:
The operation is not ...
- 11
0
votes
0
answers
32
views
PowerPoint JS API: Can't Create Lines with Negative Slope Using addLine
We are encountering a technical issue with the PowerPoint JavaScript API when attempting to create lines with negative slope (lines that go upward from left to right). Despite various approaches, we ...
0
votes
1
answer
68
views
Insert Word document into Outlook email using office.js
Is it possible to insert a Word document into an Outlook email using office.js?
I know how to do it using VBA/VSTO but am struggling in office.js
I can see that HTML can be inserted, but I'm unsure ...
- 1,484
0
votes
0
answers
52
views
How to do logging in Office JS Dialog for Excel Addin?
I have an excel addin which opens a dialog. How do I see the logs from the .html page or JS code that actually calls .displayDialogAsync to show the dialog?
For instance, I have a MyFunctions.html ...
0
votes
0
answers
43
views
How to use an InfoLabel in a Field?
I'm trying to use an InfoLabel in a Field as shown here
import * as React from "react";
import {
Field,
InfoLabel,
Input,
LabelProps,
} from "@fluentui/react-components";
...
- 480
0
votes
1
answer
62
views
Send Selected Email with Attachments to Specific Email ID in New Outlook Web Add-in
I'm developing a web add-in for the new Outlook and need to send the currently selected email to a specific email address, including any attachments. I used the Yeoman Office generator to create the ...
0
votes
0
answers
57
views
How to find and highlight the exact word in Office JS word plugin
I am working on a word add-in project for Office JS. I have been trying to implement the specific word highlight using my tool. So when a user selects any word from my tool it will get selected on the ...
0
votes
0
answers
56
views
How to tag documents on client-side for autoopen taskpane?
I have the following Add-in only manifest (React/TypeScript Task pane project made using Yeoman):
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<...
- 33
0
votes
1
answer
95
views
Deleting attachment of mail via Office js <= 1.5 or from EWS call
I am developing an Outlook add-in using Office.js for an Exchange On-Premises server. Due to the limitations of Exchange On-Prem, the supported Office.js version is 1.5 or lower. Unfortunately, in ...
- 11
1
vote
2
answers
100
views
How to pass args to a ShowTaskpane action?
I have a PPT add-in taskpane with multiple tabs. Some of them are hidden using a drop menu. I also have a custom Tab section in the Ribbon and I would like to add a button there for each tab, so when ...
- 480