Tutorial by Examples: in

Vertical Index Match =INDEX(A1:A3,MATCH(E2,C1:C3,0))

Horizontal Index Match =INDEX(A1:C1,MATCH(E2,A3:C3,0))

Hiding Softkeyboard is a basic requirement usually when working with EditText. The softkeyboard by default can only be closed by pressing back button and so most developers use InputMethodManager to force Android to hide the virtual keyboard calling hideSoftInputFromWindow and passing in the token o...

Ext.define('App.Duck', { extend: 'Ext.Component', alias: 'widget.duck', initComponent: function () { this.callParent(arguments); this._quack(); }, _quack: function () { console.log('The duck says "Quack!"'); this.fireEvent('quack...

// gets the Class objects from the net.mminecraft.server package with the given name public Class<?> getNmsClass(String name) throws ClassNotFoundException { // explode the Server interface implementation's package name into its components String[] packageArray = Bukkit.getServer()....

public class CustomSurfaceView extends SurfaceView { @Override public boolean onTouchEvent(MotionEvent e) { super.onTouchEvent(e); if(e.getPointerCount() > 2){ return false; // If we want to limit the amount of pointers, we return false //...

There is more than one way to do it: Using the package manager: sudo apt install perl Installing from source: wget http://www.cpan.org/src/5.0/perl-version.tar.gz tar -xzf perl-version.tar.gz cd perl-version ./Configure -de make make test make install Installing in your $h...

As we said before, we go with the open-source version. For Windows you can choose strawberry or DWIM. Here we cover the strawberry version, since DWIM is based on it. The easy way here is installing from the official executable. See also berrybrew - the perlbrew for Windows Strawberry Perl

You can assert that parameters have certain values with requires. int fib (int i) requires (i > 0) { if (i == 1) { return i; } else { return fib (i - 1) + fib (i - 2); } } fib (-1); You won't get any error during the compilation, but you'll get an error wh...

This is an official MATLAB example Consider the following code: month = [1;1;2;3;8;1;3;4;9;11;9;12;3;4;11]; temperature = [57;61;60;62;45;59;64;66;40;56;38;65;61;64;55]; maxTemp = accumarray(month,temperature,[],@max); The image below demonstrates the computation process done by accumarray in...

If you bind a buffer to GL_PIXEL_UNPACK_BUFFER then the data parameter in glTexImage2D is a offset into that buffer. This means that the glTexImage2D doesn't need to wait for all the data to be copied out of the application's memory before it can return, reducing overhead in the main thread. glGen...

Active Record Transactions can be applied to Model classes as well as Model instances, the objects within the transaction block need not all be instances of same class. This is because transactions are per-database connection, not per-model. For example: User.transaction do account.save! prof...

Using Oracle SQL’s NVL2() function, you can create a display column which contains one value if a field contains data and another value if a field does not contain data. For example, in an Entity search, turn the presence of a primary e-mail address into a text display column: NVL2( {email} , 'YES...

Firebase handles notifications differently when the app is in background (killed process) and when in foreground (active). When your app is in the background, notification messages are displayed in the system tray, and onMessageReceived is not called. For notification messages with a data payload...

Dockerfile is used to configure the custom image that we will be building with the web-application codes. Create a new file Dockerfile in the root folder of project and then put the following contents in the same FROM php:7.0-apache COPY /etc/php/php.ini /usr/local/etc/php/ COPY . /var/www/html/ ...

Building image is not something specific to php, but in order to build the image that we described above, we can simply use docker build -t <Image name> . Once the image is built, you can verify the same using docker images Which would list out all the images installed in your system. ...

Once we have an image ready, we can start and serve the same. In order to create a container from the image, use docker run -p 80:80 -d <Image name> In the command above -p 80:80 would forward port 80 of your server to port 80 of the container. The flag -d tells that the container should r...

The typedef keyword is a specifier, so it applies separately to each declarator. Therefore, each name declared refers to the type that that name would have in the absence of typedef. int *x, (*p)(); // x has type int*, and p has type int(*)() typedef int *x, (*p)(); // x is an alias for in...

C++11 The syntax of using is very simple: the name to be defined goes on the left hand side, and the definition goes on the right hand side. No need to scan to see where the name is. using I = int; using A = int[100]; // array of 100 ints using FP = void(*)(int); // pointer to...

<http:listener-config name="HTTP_Listener_Configuration" host="localhost" port="${http.port}" doc:name="HTTP Listener Configuration"/> <db:mysql-config name="MySQL_Configuration" host="${db.host}" port="${db.port}"...