Basic-Excel-R-Toolkit icon indicating copy to clipboard operation
Basic-Excel-R-Toolkit copied to clipboard

Published 20 hours ago • verified publisher icon sdllc

Unable to use Exported R Functions

Open norway123 opened this issue 6 years ago • 11 comments

Hi all,

I have a slight problem: I am unable to use the functions I create in the BERT console. In the "Quick guide" on your webpage it is described how you can select "Exported R Functions" in the "Insert Function" menu. This way I can type e.g. R.EigenValues in Excel and thus make use of my self defined function. However, the "Exported R Functions" does not appear in the list in the "Insert Function" menu, and thus my functions are not available in Excel.

Any ideas?

norway123 avatar Apr 03 '18 10:04 norway123

Do you have the example functions, or no functions at all? Are there any errors in the console?

duncanwerner avatar Apr 03 '18 17:04 duncanwerner

The example functions are not visible in the "Insert Functions" menu. However, I have the example functions in the folder My Documents -> BERT2 -> examples.

No errors in the console.

norway123 avatar Apr 04 '18 06:04 norway123

Hi I am having the same issue. Just installed BERT and the fuctions created don't show up in Excel. Win 7- Excel 2010

makdrive2 avatar Apr 06 '18 02:04 makdrive2

it;s like BERT is not exporting any fucntion at all to Excel

makdrive2 avatar Apr 06 '18 02:04 makdrive2

We've identified a problem if your home directory (where we install functions) is on a remote directory. Switching to a local directory will work. We may not be able to watch remote directories, but we can at least read the file on startup. We'll fix that in an update in the next few days.

duncanwerner avatar Apr 06 '18 02:04 duncanwerner

Thanks!

norway123 avatar Apr 06 '18 10:04 norway123

Hi I am having the same issue. Just installed BERT and the fictions created don't show up in Excel. Win 7- Excel 2010. BERT is not exporting any function at all to Excel.

yuxuzi avatar Apr 15 '18 16:04 yuxuzi

Same issue here both on Windows 10 and Windows7. Installing locally on c:\bert does not solve the issue.

atocharnaud avatar May 22 '18 14:05 atocharnaud

I just have experienced the same issue. It seems the problem is not where the script files are located but rather the fact that account is connected to Microsoft.com or not.

If the account is Microsoft-linked account, then it does not work no matter where on disk one places the files. It works however for the local users without any problem by default.

onpikono avatar Jun 09 '18 21:06 onpikono

After a haitus with BERT (1) I am finally ready to use it again, and installed BERT (2) only to have this same issue. Is there any workaround that will cause the functions to register?

I can run the Excel add-in to open the BERT console.

I can open the example excel-scripting.r and run it and it works.

however no excel functions are exported.

how to diagnose?

malcook avatar Dec 08 '18 07:12 malcook

@onpikono - @atocharnaud @yuxuzi @norway123 @makdrive2 @duncanwerner - I resolved this (or similar) issue for myself and another - see if my guidance does not help you as well - take a look at:

https://github.com/sdllc/Basic-Excel-R-Toolkit/issues/160

malcook avatar Dec 16 '18 08:12 malcook