officejs | UNG 2.0 project aims
kandi X-RAY | officejs Summary
kandi X-RAY | officejs Summary
UNG 2.0 project aims to create a browser based office environment completely independent of any server technology. (Mirror of https://lab.nexedi.com/nexedi/officejs ; Please submit patches and issues there )
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of officejs
officejs Key Features
officejs Examples and Code Snippets
Community Discussions
Trending Discussions on officejs
QUESTION
I am looking for a way to add a notification banner when the user selects an email in Outlook. I've written a basic task pane OfficeJS admin but this requires the user to click an add-on button and keep the taskpane visible.
Is there a way to listen for such an event without requiring user (admin) interaction? Thanks!
...ANSWER
Answered 2021-Jun-10 at 11:05There is no way to get a task pane visible automatically for a selected item.
You can vote for such feature or suggest a new one at http://aka.ms/M365dev-suggestions.
QUESTION
I have an office addin project that uses shared runtime. I recently found this error when I try to open the task pane with Office.addin.showAsTaskpane()
from function execution.
The weird thing is that if I remove all custom functions of this add-in from the workbook, I will be able to open task pane again; also, I try copying all sheets from the workbook that has this issue to a new workbook, and everything works fine, I can open task pane on a new workbook.
So, I'm not sure if this error is related to a workbook-specific settings, or are there any APIs that I have to use to set AppRuntimeState. Has anyone found this error before? This seems like an error from officejs api, but I'm not sure what the root cause is because I can't find any apis about SetAppRuntimeState.
...ANSWER
Answered 2021-Apr-19 at 18:08This error occurs when you try to call showAsTaskpane()
without using shared runtime. The workbook with the issue may be referencing an older version of your add-in manifest.
Please double check that shared runtime is correctly enabled and that you are calling it from a method that is part of the shared runtime. One easy way to verify is to try accessing a variable that is set in your task pane's context.
QUESTION
ANSWER
Answered 2021-Apr-12 at 22:40Sorry, that functionality is not currently available with the Office JavaScript library. But it is an interesting suggestion. You can suggest it at Microsoft Q&A Office Add-ins Dev.
QUESTION
I'm working on an Outlook add-in using OfficeJS.
There does not seem to be a setAsync method on Office.context.mailbox.item.body when reading a message. I can understand why this generally makes sense.
Is there any way an add-in can alter the body text when reading a message?
I do not want to alter the original message on the server.
...ANSWER
Answered 2020-Oct-30 at 14:54Currently the feature: Manipulate Message in Read Mode, you requested, is not a part of the product. We track Outlook add-in feature requests on our user-voice page. Please add your request there. Feature requests on user-voice are considered, when we go through our planning process.
QUESTION
We have an excel add in with user roles based functionalities. We have an idea of creating a sample workbook with all the feature access for demo purpose. Do we have any unique identifiers for workbooks in excel ? If exists how can we access them using officejs. We did a research in officejs documentation and found out that Worksheets inside a workbook has unique identifiers. The disadvantage is that these id will be reused when the worksheet is deleted and new worksheet is created.
...ANSWER
Answered 2020-Sep-25 at 16:16yes you can use the office.document.url
property to use to identify the workbook URL.
In addition, you can also set/get a custom property on the worksheet level:
QUESTION
Officejs excel's OnSelectionChange listner does not work for the first time on a new sheet. But this happens only when we open the sheet for the first time. After which it works fine. Could anybody help me out to understand the working.
Update: This happens only in Excel web
Update: Please find the video attached for reference https://drive.google.com/file/d/1dBXH74Plu5TwA6ViUf6KlgI8CJZQscPg/view?usp=sharing
...ANSWER
Answered 2020-Sep-30 at 07:13I just want to make sure that viewers will have an answer for this if anyone is facing the same problem. It is a issue in office js Excel API. It has been raised internally. Have a good day.
QUESTION
We have completed development of an Excel addin using the officejs API's. During the process of deploying it to App source we got a feedback that the addin shows blank screen when there is a slower internet connection. When we tried to debug it we got the following error ( when 3G Slow option is set in chrome ).
Uncaught Error: Office.js has not fully loaded. Your app must call "Office.onReady()" as part of it's loading sequence (or set the "Office.initialize" function). If your app has this functionality, try reloading this page.
But the same addin works fine when the internet speed is decent. Below is the piece of code that we have used to bootstrap the angular application.
...ANSWER
Answered 2020-Sep-01 at 05:19After a long investigation my collegues found out that the application size had significant impact on loading the extension inside excel after adding the following line of code in build script we were able to fix this
QUESTION
I am looking for a way to automatically change an email address or be able to add a CC based on a condition. Is there an OfficeJS API call for outlook that lets me "edit" an email address or is able to add a CC based on a button click?
...ANSWER
Answered 2020-Aug-19 at 20:09In Compose Mode recipients can be accessed via Office.context.mailbox.item.to or cc. There are both getAsync() and setAsync() functions on those.
https://docs.microsoft.com/en-us/javascript/api/outlook/office.recipients?view=outlook-js-preview
You can also subscribe to the RecipientsChangeEvent to find out when a user has changed it.
Recipients can be accessed but not changed in Read Mode
QUESTION
I am using this OfficeJs API to save metadata associated with excel add in app, and I am wondering how big data the setting can support in Excel add in, we notice when the setting get to a few MB, it doesn't get saved. Office.context.document.settings.set('mySetting', 'mySetting value');
...ANSWER
Answered 2020-Jun-23 at 07:08For Outlook add-ins the maximum size of the storage is 32 Kb. I suppose the same limitation exists for other Office applications.
However, you may consider using other possible techniques for storing your data. Use members of the Office JavaScript API that store data as either:
- Custom XML stored in the document. See Excel.CustomXmlPart.
- Use techniques provided by the underlying browser control: browser cookies, or HTML5 web storage (localStorage or sessionStorage).
Read more about that in the Persisting add-in state and settings article.
QUESTION
I am writing a Word add-in using office-js that generates an index. It uses the following code to create a section break at the end of the document, and then writes the index there:
...ANSWER
Answered 2020-Apr-09 at 14:30Yes, it's a bit round-about, but it can be done.
As you intimate, the actual section break appears not to be part of the section.body
's Range
. So the trick is to get the point immediately before that, at the end of the prior section's range, as demonstrated by the following code snippet. (Tested in ScriptLab.)
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install officejs
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page