The most useful linux command

history XXX

XXX indicates the number of lines

Android Studio Shortcut

Keyboard Commands

The following tables list keyboard shortcuts for common operations.

Note: This section lists Android Studio keyboard shortcuts for the default keymap. To change the default keymap on Windows and Linux, go to File > Settings > Keymap. If you're using Mac OS X, update your keymap to use the Mac OS X 10.5+ version keymaps under Android Studio > Preferences > Keymap.

Table 1. Programming key commands

Action	Android Studio Key Command
Command look-up (autocomplete command name)	CTRL + SHIFT + A
Project quick fix	ALT + ENTER
Reformat code	CTRL + ALT + L (Win) OPTION + CMD + L (Mac)
Show docs for selected API	CTRL + Q (Win) F1 (Mac)
Show parameters for selected method	CTRL + P
Generate method	ALT + Insert (Win) CMD + N (Mac)
Jump to source	F4 (Win) CMD + down-arrow (Mac)
Delete line	CTRL + Y (Win) CMD + Backspace (Mac)
Search by symbol name	CTRL + ALT + SHIFT + N (Win) OPTION + CMD + O (Mac)

Table 2. Project and editor key commands

Action	Android Studio Key Command
Build	CTRL + F9 (Win) CMD + F9 (Mac)
Build and run	SHIFT + F10 (Win) CTRL + R (Mac)
Toggle project visibility	ALT + 1 (Win) CMD + 1 (Mac)
Navigate open tabs	ALT + left-arrow; ALT + right-arrow (Win) CTRL + left-arrow; CTRL + right-arrow (Mac)

[Excel] Change the columns index from letter to number

When you open a spreadsheet by defautl the columns are indexed by letters: 

But if you want to change the format and put the index in numbers, here's how:

• Open your spreadsheet
• Click on the orb button
• Click on Excel Options and move to the Formula tab.
• Go to the "Working with formulas" section
• Check the "R1C1 reference style"
• Note that: Upon hovering your mouse cursor on it, you shall get all the information about this feature.
• Click on OK

How to initialize Android program to be portrait or landscape

If you want to disable orientation changes of the phone then you may use this code in the manifest

<activity android:name=".class_name"

//if you want your screen in portrait

android:screenOrientation="portrait" >

//if you want you screen in landscape mode

android:screenOrientation="landscape" >

and if you want your phone to change orientation but prevent the process from restarting then you can use the onConfigurationChanged method in your class:

@Override
public void onConfigurationChanged(Configuration newConfig) {
   // ignore orientation change
   if (newConfig.orientation != Configuration.ORIENTATION_LANDSCAPE) {
       super.onConfigurationChanged(newConfig);
   }
}

How to copy database file from android

Using Android Studio, click the android device button located in the toolbox menu

Then navigating to the storage folder under the name of your device (on the left panel)

The data is stored in one of the folder that your app pointed to (check your code for this location)