Comments (12)
Hi @nadeemAshfaq Thanks for reporting this issue, could you share us your code about this custom function? We're trying to repro your issue.
from office-js.
Hi @shanshanzheng-dev this is how my JSDoc written
and when I run npm build this is how my JSON file looks like
It works fine on the desktop and gets (A:A) as a parameter but when I try the same thing in Excel online it returns "#CALC!"
from office-js.
Hi @nadeemAshfaq could you please share your custom function?
from office-js.
Do you want me to share the whole code with you?
from office-js.
Yes, if possible. Because we try to repro your issue and that helps us investigate root cause. Meanwhile, could you share your repro steps? Thanks.
from office-js.
Yes, if possible. Because we try to repro your issue and that helps us investigate root cause. Meanwhile, could you share your repro steps? Thanks.
Sorry I cannot share my full code here I think I already provided the necessary information
from office-js.
OK, Thanks. We'll be looking into this issue. We'll report back if we have an suggestion for you.
from office-js.
any update?
from office-js.
@nadeemAshfaq Thanks for the waiting and reporting this issue. It has been put on our backlog #9120326. We will update once we have some progress.
from office-js.
@nadeemAshfaq Currently, the custom function has a limitation in online that the max cells number for input parameter should be less or equal to 10000. So we'd like to suggest you split your inputs when you use it.
from office-js.
@nadeemAshfaq Currently, the custom function has a limitation online that the max cell number for the input parameter should be less or equal to 10000. So we suggest you split your inputs when you use it.
Okay, thanks for this information. Is there any chance in the future that it takes (A: A)?
from office-js.
Thanks for the good questions. The item to expand the limitation is in our backlog but no plan to fix it in the short term. We recommend you to upvote or submit a new Tech Community New Ideas item, this will give us visibility of the commonality of it and will help with our prioritization. If we end up working on this issue, we will re-activate as needed.
from office-js.
Related Issues (20)
- body.clear() not working for content controls HOT 3
- How to make slide active Or How to insert image using index HOT 4
- Addin sample not showing in new look outlook and browsers. HOT 5
- Identifying Usage of New Outlook in Office-js Add-ins HOT 1
- Not able to sideload outlook addin. in macbook there is no option to add the manifest file HOT 5
- Inserting Signature with the OnMessageSend event duplicates the signature
- The identity API is not supported for this add-in in online Word HOT 2
- Excel Online: calculation state can get stuck in Pending state when workbook contains charts HOT 3
- IP Address Range Needed for Microsoft Office Add-in Validation Process
- Office API messageParent Outlook on android doesn't work
- NAA: Unable to acquire access token for event-based activation (onMessageSend) HOT 2
- Outlook addin using Bootstrap modal or offcanvas bleeds through on Mac version of Outlook. Classic and New Outlook for Mac. HOT 2
- [Word API] Document.compare: ability to specify Original and Revised document?
- Outlook NAA issue: "Something went wrong. [7q6cl]" Error HOT 5
- Web Outlook provides improper attachment data if attachment is still uploading to the email HOT 2
- [Question] Is it safe to use `CustomFunctions.delayinitialization()`
- New Outlook - emails stuck in outlook at queued or draft status HOT 3
- context.application.createDocument works only first time HOT 1
- WorkBook level Define name is getting corrupted while reopening excel using base64
- In Outlook, getAllInternetHeadersAsync works on an item in the Inbox, but not the sent folder
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from office-js.