# **Excel:** formula delimiters not recognized

## Problem

Excel failed to recognize delimiters in my formulas, and would interpret everything as being in the first argument to a function that accepts multiple arguments.

## Solution

 1. CMD: `control international`
 2. Click "Additional Settings…"
 3. Make sure the "List separator" is only one character

# **Git CLI:** unable to find editor

## Problem

Trying to run Git commands requiring an editor break with an error:

```
hint: Waiting for your editor to close the file... error: cannot spawn /usr/bin/vim: No such file or directory
error: unable to start editor '/usr/bin/vim'
Please supply the message using either -m or -F option.
```

## Solution
Make sure the `vim` executable is on your path and set the `core.editor` configuration to point to it.

```
git config --global core.editor vim
```

# **Git CLI:** apparent Cygwin DLL version mismatch

## Problem

Running commands like `git help remote` results in an error:

```
2 [main] sh (69208) C:\Program Files\Git\usr\bin\sh.exe: *** fatal error - cygheap base mismatch detected - 0x27511F01410/0x166A9271410.
This problem is probably due to using incompatible versions of the cygwin DLL.
Search for cygwin1.dll using the Windows Start->Find/Search facility
and delete all but the most recent version.  The most recent version *should*
reside in x:\cygwin\bin, where 'x' is the drive on which you have
installed the cygwin distribution.  Rebooting is also suggested if you
are unable to find another cygwin DLL.
      1 [main] sh 69364 fork: child -1 - forked process 69208 died unexpectedly, retry 0, exit code 0xC0000142, errno 11

/mingw64/libexec/git-core/git-sh-setup: fork: retry: Resource temporarily unavailable
```

## Solution

Windows Defender's Exploit Protection module prevents the executable(s) in `C:\Program Files\Git` listed in the error message from executing properly. In my case, the executables that needed to be added as exceptions were:

  - `C:\Program Files\Git\usr\bin\basename.exe`
  - `C:\Program Files\Git\usr\bin\bash.exe`
  - `C:\Program Files\Git\usr\bin\env.exe`
  - `C:\Program Files\Git\usr\bin\sed.exe`
  - `C:\Program Files\Git\usr\bin\sh.exe`
  - `C:\Program Files\Git\usr\bin\uname.exe`

Adding the listed executables as program exceptions and re-running the command until the error messages disappear should resolve the issue.

 1. Go to "Exploit Protection": **Windows Security** > **App & browser control** > **Exploit Protection** > **Program Settings**
 2. Click on **Add program to customize** and select **Choose exact file path**
 3. Select the executable listed in the error message
 4. Scroll to the **"Force randomization for images (Mandatory ASLR)"** section and make sure the checkbox for **Override system settings** is checked, and the switch is in the **Off** position

# **Flutter:** adb fails to get device properties

## Problem

Trying to debug a Flutter application from Visual Studio Code on a physical device has a fatal error:

```
Error retrieving device properties for ro.product.cpu.abi:
```

## Solution

Windows Defender's Exploit Protection module prevented `adb` from executing properly.

 1. Go to "Exploit Protection": **Windows Security** > **App & browser control** > **Exploit Protection** > **Program Settings**
 2. Click on **Add program to customize** and select **Choose exact file path**
 3. Select your **`adb.exe`** executable which in my case was `C:\Android\Sdk\platform-tools\adb.exe`
 4. Scroll to the **"Validate heap integrity"** section and make sure the checkbox for **Override system settings** is checked, and the switch is in the **Off** position