About 1,473,768 results (2,244 milliseconds)
non-threadsafe function called on non-main thread
https://groups.google.com/g/exceldna/c/kxRMieVCINM May 18, 2021 ... I am using ExcelDna v1.1.1 and I register the functions by setting ExplicitRegistration="true" in the config and calling ExcelRegistration.
Need help translating an Excel function to Google Sheets - Google ...
https://support.google.com/docs/thread/108897696/need-help-translating-an-excel-function-to-google-sheets?hl=en May 6, 2021 ... This basic (not basic) formula works in excel - but when you cut and paste it to Google sheets you get an error message.
Google Sheets function list - Google Docs Editors Help
https://support.google.com/docs/table/25273?hl=en Google Sheets function list ; Financial, FVSCHEDULE, FVSCHEDULE(principal, rate_schedule) ; Financial, INTRATE, INTRATE(buy_date, sell_date, buy_price, sell_price ...
Non-blocking async Excel Functions
https://groups.google.com/g/exceldna/c/f7ZjKc_8bfY Call some long running async function that will make an external api call; #GETTING_DATA is returned; This should be non-blocking for the main Excel thread ...
Detect If Formula Was Invoked Via F2+{Enter} Or Double-click+{Enter}
https://groups.google.com/g/exceldna/c/LUYIvHED1RM Apr 19, 2023 ... This is a very basic example and uses reactive extensions. try using following code and the excel formula =Clock.Live("aaa") and =Clock.F2("aaa ...
EXP and Logarithmic Functions producing inconsistent results ...
https://support.google.com/docs/thread/134530829/exp-and-logarithmic-functions-producing-inconsistent-results-between-excel-and-sheets?hl=en Nov 9, 2021 ... Here's a link to a basic spreadsheet where I show the problem along with screenshots of corresponding values from Excel: https://docs.google ...
Quick key to paste just formulas? - Google Docs Editors Community
https://support.google.com/docs/thread/12252546/quick-key-to-paste-just-formulas?hl=en Aug 18, 2019 ... Seems like a pretty key and basic function (in Excel I use it constantly) so I'm surprised I can't find it in Sheets. Thanks. Details. Sheets ...
Exposing ExcelDNA static functons to VBA
https://groups.google.com/g/exceldna/c/eMf9d7gTgV4 My Main project derives from IExcelAddIn and my UDFs are created as ... The Excel-DNA worksheet functions can be called directly from VBA with Application.
Re: ThreadSafe RTD
https://groups.google.com/g/exceldna/c/CWZfjO21JJQ If calls to Excel's RTD function cal only be made from the main thread, then calls to Excel-DNA's ExcelAsyncUtil.Run and ExcelAsyncUtil.Observe functions ...
What's the best way of writing back to a function's input arguments?
https://groups.google.com/g/exceldna/c/JboktODEvIE Oct 26, 2011 ... the functions to be array functions and thought I could hook into ... the main Excel thread might be busy. So you need some error handling
Function Intellisense Not Displayed When Using External Xml File
https://groups.google.com/g/exceldna/c/vIbV4Ho83HY The project is centered around exposing a large number of wrapped RTD functions to Excel and to utilize the ExcelDna. ... Here is the main entry point of the add- ...
Excel Formulas Not Working in Google Sheets - Google Docs ...
https://support.google.com/docs/thread/219934507/excel-formulas-not-working-in-google-sheets?hl=en Jun 8, 2023 ... Skip to main content. Google Docs Editors Help ... The problem is that you need to convert the "Excel exclusive" formulas to "Excel and Google ...
Keep Showing Previous Values in Excel while Waiting for Async ...
https://groups.google.com/g/exceldna/c/xLoCVXxN53w Jun 17, 2021 ... The main problem is that the following FsAsync.FsAsyncUtil ... I am building excel functions to get external data via API. Those ...
Spilling with Excel DNA
https://groups.google.com/g/exceldna/c/wUhDrO_ecVw Apr 13, 2023 ... This works for most excel functions, but does not work for any Excel DNA functions. To test I made a basic function: [ExcelFunction] public ...
Advanced filter function in Excel - Google Docs Editors Community
https://support.google.com/docs/thread/9779002/advanced-filter-function-in-excel?hl=en Jul 12, 2019 ... Once filtered, I can view them all in my main spreadsheet and make edits to information on that row. This is why exporting data into another ...
Custom Functions in Google Sheets | Apps Script | Google for ...
https://developers.google.com/apps-script/guides/sheets/functions Skip to main content ... That is, built-in spreadsheet functions that return a different result each ...
How to see formula calculation steps in Google Sheets? - Google ...
https://support.google.com/docs/thread/7547557/how-to-see-formula-calculation-steps-in-google-sheets?hl=en Jun 6, 2019 ... In microsoft Excel there is an 'Evaluate Formula' button. Is there an equivalent in Google Sheets? What should be my approach when trying for figure out what's ...
I need to edit filter function results to inflect the new value to the main ...
https://support.google.com/docs/thread/14279941/i-need-to-edit-filter-function-results-to-inflect-the-new-value-to-the-main-sheet?hl=en Sep 13, 2019 ... If I'm understanding your question correctly, on the secondary sheet, column U is populated with data from the main sheet by a formula. And ...
Migrating from Excel to Sheets and having issues with formulas ...
https://support.google.com/docs/thread/5121708/migrating-from-excel-to-sheets-and-having-issues-with-formulas?hl=en Apr 29, 2019 ... ... spreadsheets the structure of the data can be very important. Also when converting from Excel to Gsheets sometimes there is a simpler ...
Converting excel formulas into google sheet formula - Google Docs ...
https://support.google.com/docs/thread/55810540/converting-excel-formulas-into-google-sheet-formula?hl=en Jun 27, 2020 ... ... excel in to google sheets some functions don't work. I was ... main table from the tables below and from new tables that I might ...