Tutorial by Examples: v

ActiveWorkbook vs. ThisWorkbook

ActiveWorkbook and ThisWorkbook sometimes get used interchangeably by new users of VBA without fully understanding which each object relates to, this can cause undesired behaviour at run-time. Both of these objects belong to the Application Object The ActiveWorkbook object refers to the workbook ...

excel-vba • Common Mistakes

ScriptableObjects are serialized in editor even in PlayMode

Extra care should be taken when accessing serialized fields in a ScriptableObject instance. If a field is marked public or serialized through SerializeField, changing its value is permanent. They do not reset when exiting playmode like MonoBehaviours do. This can be useful at times, but it can also...

unity3d • ScriptableObject

dplyr's single table verbs

dplyr introduces a grammar of data manipulation in R. It provides a consistent interface to work with data no matter where it is stored: data.frame, data.table, or a database. The key pieces of dplyr are written using Rcpp, which makes it very fast for working with in-memory data. dplyr's philosoph...

R Language • dplyr

Tuning JVM Memory Usage Parameters for Gradle

You can set or increase memory usage limits (or other JVM arguments) used for Gradle builds and the Gradle Daemon by editing $GRADLE_USER_HOME/.gradle/gradle.properties (~/.gradle/gradle.properties by default), and setting org.gradle.jvmargs. To configure these limits only for a specific project, e...

gradle • Gradle Performance

Clone recursively

1.6.5 git clone <url> --recursive Clones the repository and also clones all submodules. If the submodules themselves contain additional submodules, Git will also clone those.

Git • Cloning Repositories

Using VBA string constants

VBA defines a number of string constants for special characters like: vbCr : Carriage-Return 'Same as "\r" in C style languages. vbLf : Line-Feed 'Same as "\n" in C style languages. vbCrLf : Carriage-Return & Line-Feed (a new-line in Windows) vbTab: Tab Character vbNul...

VBA • String Literals - Escaping, non-printable characters and line-continuations

Declare a variable-width string variable

Dim surname As String 'surname can accept strings of variable length surname = "Smith" surname = "Johnson"

VBA • Declaring and assigning strings

Text Overflow

The text-overflow property deals with how overflowed content should be signaled to users. In this example, the ellipsis represents clipped text. .text { overflow: hidden; text-overflow: ellipsis; } Unfortunately, text-overflow: ellipsis only works on a single line of text. There is no way...

CSS • Typography

RecyclerView Basics

This is an example of using Android Support Library V7 RecyclerView. Support libraries are generally recommended because they provide backward-compatible versions of new features, provide useful UI elements that are not included in the framework, and provide a range of utilities that apps can draw o...

Xamarin.Android • RecyclerView

Global variables

To declare a single instance of a variable which is accessible in different source files, it is possible to make it in the global scope with keyword extern. This keyword says the compiler that somewhere in the code there is a definition for this variable, so it can be used everywhere and all write/r...

C++ • Scopes

Primitive Types Cheatsheet

Table showing size and values range of all primitive types: data typenumeric representationrange of valuesdefault valuebooleann/afalse and truefalsebyte8-bit signed-27 to 27 - 10-128 to +127short16-bit signed-215 to 215 - 10-32,768 to +32,767int32-bit signed-231 to 231 - 10-2,147,483,648 to +2,147,...

Java Language • Primitive Data Types

Simple variable

All variables in powershell begin with a US dollar sign ($). The simplest example of this is: $foo = "bar" This statement allocates a variable called foo with a string value of "bar".

PowerShell • Variables in PowerShell

Removing a variable

To remove a variable from memory, one can use the Remove-Item cmdlet. Note: The variable name does NOT include the $. Remove-Item Variable:\foo Variable has a provider to allow most *-item cmdlets to work much like file systems. Another method to remove variable is to use Remove-Variable cmdlet...

PowerShell • Variables in PowerShell

Adding a spinner to your activity

In /res/values/strings.xml: <string-array name="spinner_options"> <item>Option 1</item> <item>Option 2</item> <item>Option 3</item> </string-array> In layout XML: <Spinner android:id="@+id/spinnerName" ...

Android • Spinner

A View Bound to Existing HTML

Assuming this HTML in the page: <body> <div id="myPage"> </div> </body> A view can be bound to it with: var MyPageView = Backbone.View.extend( { "el": "#myPage", "template": _.template( "<p>This is m...

backbone.js • View

View's initialize function

initialize is called by Backbone right after a View is constructed. Optional parameters The initialize function receives any arguments passed to the view's constructor. Commonly, the options hash that is used to pass the view's default options: ['model', 'collection', 'el', 'id', 'attributes', 'c...

backbone.js • View

Defining Variadic Functions

A Clojure function can be defined to take an arbitrary number of arguments, using the symbol & in its argument list. All remaining arguments are collected as a sequence. (defn sum [& args] (apply + args)) (defn sum-and-multiply [x & args] (* x (apply + args))) Calling: =&gt...

clojure • Functions

Overview

In Vue.js, conditional rendering is achieved by using a set of directives on elements in the template. v-if Element displays normally when condition is true. When the condition is false, only partial compilation occurs and the element isn't rendered into the DOM until the condition becomes true. ...

Vue.js • Conditional Rendering

v-if / v-else

Assuming we have a Vue.js instance defined as: var vm = new Vue({ el: '#example', data: { a: true, b: false } }); You can conditionally render any html element by including the v-if directive; the element that contains v-if will only render if the condition eval...

Vue.js • Conditional Rendering

v-show

The use of the v-show directive is almost identical to that of v-if. The only differences are that v-show does not support the <template> syntax, and there is no "alternative" condition. var vm = new Vue({ el: '#example', data: { a: true } }); The basic u...

Vue.js • Conditional Rendering