Tutorial by Examples: f

Highlighting Top 5 Values With Range("E1:E100").FormatConditions.AddTop10 .TopBottom = xlTop10Top .Rank = 5 .Percent = False With .Font .Bold = True .ColorIndex = 3 End With End With

With Range("E1:E100").FormatConditions.AddAboveAverage .AboveBelow = xlAboveAverage With .Font .Bold = True .ColorIndex = 3 End With End With Operators: NameDescriptionXlAboveAverageAbove averageXlAboveStdDevAbove standard deviationXlBelowAverageBelow ...

Range("a1:a10").FormatConditions.AddIconSetCondition With Selection.FormatConditions(1) .ReverseOrder = False .ShowIconOnly = False .IconSet = ActiveWorkbook.IconSets(xl3Arrows) End With With Selection.FormatConditions(1).IconCriteria(2) .Type = xlConditionValueP...

String hostName = args[0]; int portNumber = Integer.parseInt(args[1]); try ( Socket echoSocket = new Socket(hostName, portNumber); PrintWriter out = new PrintWriter(echoSocket.getOutputStream(), true); BufferedReader in = new BufferedReader( new Inpu...

Basically to apply a theme for SearchView extracted as app:actionViewClass from the menu.xml, we need understand that it depends completely on the style applied to the underlying Toolbar. To achieve themeing the Toolbar apply the following steps. Create a style in the styles.xml <style name=&qu...

public class JSEngine { /* * Note Nashorn is only available for Java-8 onwards * You can use rhino from ScriptEngineManager.getEngineByName("js"); */ ScriptEngine engine; ScriptContext context; public Bindings scope; // Initialize t...

class Person { constructor(firstname, lastname) { this._firstname = firstname; this._lastname = lastname; } get firstname() { return this._firstname; } set firstname(name) { this._firstname = name; } get lastname() { return this._lastname; } ...

Processlist This will show all active & sleeping queries in that order then by how long. SELECT * FROM information_schema.PROCESSLIST ORDER BY INFO DESC, TIME DESC; This is a bit more detail on time-frames as it is in seconds by default SELECT ID, USER, HOST, DB, COMMAND, TIME as time_second...

A for loop iterate through items in an array program ArrayLoop; {$APPTYPE CONSOLE} const a : array[1..3] of real = ( 1.1, 2.2, 3.3 ); var f : real; begin for f in a do WriteLn( f ); end. Output: 1,1 2,2 3,3

This sample used to common function for all type object serialization and deserialization. using System.Runtime.Serialization.Formatters.Binary; using System.Xml.Serialization; namespace Framework { public static class IGUtilities { public static string Serialization(this T obj) ...

This is similar to Docker-machine or minikube which are used to learn Docker and Kubernetes. It will run a virtual machine containing everything you need to test openshift-origin. Here is the documentation from openshift-origin and how to install it on any OS here I'll write doc for Debian-lik...

When a remote session is created via the New-PSsession cmdlet, the PSSession persists until the current PowerShell session ends. Meaning that, by default, the PSSession and all associated resources will continue to be used until the current PowerShell session ends. Multiple active PSSessions can b...

File exists: Sub FileExists() Dim fso as Scripting.FileSystemObject Set fso = CreateObject("Scripting.FileSystemObject") If fso.FileExists("D:\test.txt") = True Then MsgBox "The file is exists." Else MsgBox "The file isn't exist...

Copy: Sub CopyFile() Dim fso as Scripting.FileSystemObject Set fso = CreateObject("Scripting.FileSystemObject") fso.CopyFile "c:\Documents and Settings\Makro.txt", "c:\Documents and Settings\Macros\" End Sub Move: Sub MoveFile() Dim fso as Scri...

Create: Sub CreateFolder() Dim fso as Scripting.FileSystemObject Set fso = CreateObject("Scripting.FileSystemObject") fso.CreateFolder "c:\Documents and Settings\NewFolder" End Sub Copy: Sub CopyFolder() Dim fso as Scripting.FileSystemObject Set fso...

videoView.setVideoURI(Uri.parse("http://example.com/examplevideo.mp4")); videoView.requestFocus(); videoView.setOnCompletionListener(new MediaPlayer.OnCompletionListener() { @Override public void onCompletion(MediaPlayer mediaPlayer) { } }); videoView.setO...

To let RestTemplate understand generic of returned content we need to define result type reference. org.springframework.core.ParameterizedTypeReference has been introduced since 3.2 Wrapper<Model> response = restClient.exchange(url, HttpMethod.GET, ...

F() expressions can be used to execute arithmetic operations (+, -, * etc.) among model fields, in order to define an algebraic lookup/connection between them. Let model be: class MyModel(models.Model): int_1 = models.IntegerField() int_2 = models.IntegerField() Now lets assum...

To have a look of the different functionalities of the hybris platform, you can use the install recipes. For this, just download the HYBRISCOMMXXXX_X-XXXXXXXX.ZIP and extract it to you local device. Than go through the following steps: The <recipe_names> you can find under the folder \hybris\...

The first standalone R script Standalone R scripts are not executed by the program R (R.exe under Windows), but by a program called Rscript (Rscript.exe), which is included in your R installation by default. To hint at this fact, standalone R scripts start with a special line called Shebang line, ...