Skip to content

Releases: sdllc/Basic-Excel-R-Toolkit

Preview Release

28 Feb 19:13
Compare
Choose a tag to compare
Preview Release Pre-release
Pre-release

This is a preview release of version 2 of BERT. You are welcome to try it, and we would love your feedback. However please note the following:

  • This installer does not include R (or Julia, which we also support). You will need a separate R installation. If you have an existing BERT install, you can use that version of R (as long as it's 3.4.0 or later).

  • The installer for V2 is completely separate from old BERT installers, so if you install it it will not remove old BERT. It also uses a different functions directory (Documents/BERT2). We don't recommend running BERT1 and BERT2 at the same time; you should probably disable BERT1 in Excel before using this one. (Use options > add-ins > COM Add-ins to disable).

  • We support both 32-bit and 64-bit Excel, but only on 64-bit Windows.

  • This installer is not an MSI (it's an EXE).

BERT2 Preview Release

27 Feb 20:06
Compare
Choose a tag to compare
BERT2 Preview Release Pre-release
Pre-release

This is a preview release of version 2 of BERT. You are welcome to try it, and we would love your feedback. However please note the following:

  • This installer does not include R (or Julia, which we also support). You will need a separate R installation. If you have an existing BERT install, you can use that version of R (as long as it's 3.4.0 or later).

  • The installer for V2 is completely separate from old BERT installers, so if you install it it will not remove old BERT. It also uses a different functions directory (Documents/BERT2). We don't recommend running BERT1 and BERT2 at the same time; you should probably disable BERT1 in Excel before using this one. (Use options > add-ins > COM Add-ins to disable).

  • Only 64-bit Excel is supported right now (we will add 32-bit Excel support later).

  • This installer is not an MSI (it's an EXE).

BERT2 Preview Release

27 Feb 00:23
Compare
Choose a tag to compare
BERT2 Preview Release Pre-release
Pre-release

This is a preview release of version 2 of BERT. You are welcome to try it, and we would love your feedback. However please note the following:

  • This installer does not include R (or Julia, which we also support). You will need a separate R installation. If you have an existing BERT install, you can use that version of R (as long as it's 3.4.0 or later).

  • The installer for V2 is completely separate from old BERT installers, so if you install it it will not remove old BERT. It also uses a different functions directory (Documents/BERT2). We don't recommend running BERT1 and BERT2 at the same time; you should probably disable BERT1 in Excel before using this one. (Use options > add-ins > COM Add-ins to disable).

  • Only 64-bit Excel is supported right now (we will add 32-bit Excel support later).

  • This installer is not an MSI (it's an EXE).

Update for R-3.4.3

11 Jan 18:14
Compare
Choose a tag to compare

Changes:

  • Update R to 3.4.3
  • Fix for returning list-of-lists

The last build made changes to returned arrays, which improved excel support but broke support for returning list-of-lists to VBA, which broke our VBA example. This fix should restore support for that case.

Update for R 3.4.2 and Excel Arrays

10 Oct 19:56
Compare
Choose a tag to compare

Changes:

  • Update R to 3.4.2

  • Change array behavior as in #74.

    Excel arrays are no longer padded (or truncated). To avoid seeing #N/A errors when returning an array smaller than the Excel range, use the function pad.excel.array.

Update for #74

05 Oct 14:47
Compare
Choose a tag to compare
Update for #74 Pre-release
Pre-release

Testing update for #74, fixes frame issue

Test build for #74

29 Sep 16:04
Compare
Choose a tag to compare
Test build for #74 Pre-release
Pre-release

Test for #74, remove array truncation and padding

Console Updates

10 Aug 19:34
Compare
Choose a tag to compare

Changes:

  • Console now preserves changes to unsaved files on close.
  • Also preserve editor state on close/reopen.

Update to R 3.4.1

16 Jul 00:10
Compare
Choose a tag to compare

Changes:

  • Updated R to version 3.4.1 (2017-06-30) -- "Single Candle"
  • Added timeout in file download to prevent hanging
  • Removing CRANextra repo by default
  • Console updates

Bugfixes and updates

05 Jul 13:52
Compare
Choose a tag to compare

Changes:

  • Added BERT.version from #57.
  • Fix for watching files (icase name matching) from #26 and possibly #58
  • Fix for functions returning matrices into Excel arrays