Tutorial by Examples: d

Highlighting Duplicate Values With Range("E1:E100").FormatConditions.AddUniqueValues .DupeUnique = xlDuplicate With .Font .Bold = True .ColorIndex = 3 End With End With Highlighting Unique Values With Range("E1:E100").FormatConditions.AddUniqueVa...

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...

This example shows how you might handle users interacting with modals on a 1-1 basis. //client side function modals(socket) { this.sendModalOpen = (modalIdentifier) => { socket.emit('openedModal', { modal: modalIdentifier }); }; this.closeModa...

This getting started assumes you are working with create-react-app, or something equivalent using Babel and all the goodies out there. Also check out the great documentation right here. First, install react-router-dom: npm install react-router-dom or yarn add react-router-dom. Then, create a com...

InputBox, password, Enter your Password,, HIDE,, 100 Loop, { if (errorlevel = 1) return if (password = "password") { MsgBox, The password is correct. return } else if (password != "password") { MsgBox, The password is incorrect. InputBox, password, Enter yo...

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...

WarehosueEntity findWarehouseById(@Param("id") Long id); List<WarehouseEntity> findWarehouseByIdIn(@Param("idList") List<Long> warehouseIdList);

Sending The Request Header $uri = 'http://localhost/http.php'; $ch = curl_init($uri); curl_setopt_array($ch, array( CURLOPT_HTTPHEADER => array('X-User: admin', 'X-Authorization: 123456'), CURLOPT_RETURNTRANSFER =>true, CURLOPT_VERBOSE => 1 )); $out = curl_exec($ch...

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; } ...

Gradle Setup : build.gradle(Module: app) compileOptions { sourceCompatibility JavaVersion.VERSION_1_8 targetCompatibility JavaVersion.VERSION_1_8 } jackOptions { enabled true } What is the Stream API ? Stream is a new abstract layer introdu...

import Json.Decode as JD import Json.Decode.Pipeline as JP type PostType = Image | Video type alias Post = { id: Int , postType: PostType } -- assuming server will send int value of 0 for Image or 1 for Video decodePostType: JD.Decoder PostType decodePostType = JD.int |&...

If you want to notify other clients/users throughout the application ,you not need to worry about the connection because signalr new connection is created every time you visit other pages in the web app. we can leverage the users feature of signalr to achieve the same. see the example below: Here...

program ForLoopWithContinueAndBreaks; {$APPTYPE CONSOLE} var var i : integer; begin for i := 1 to 10 do begin if i = 2 then continue; (* Skip this turn *) if i = 8 then break; (* Break the loop *) WriteLn( i ); end; WriteLn('Finish.'); end. Outpu...

std::lock uses deadlock avoidance algorithms to lock one or more mutexes. If an exception is thrown during a call to lock multiple objects, std::lock unlocks the successfully locked objects before re-throwing the exception. std::lock(_mutex1, _mutex2);

We will look at a simple dispatch event with the example usage. (ns myapp.events (:require [re-frame.core :refer [reg-event-db]])) ...

One problem with the PIVOT query is that you have to specify all values inside the IN selection if you want to see them as columns. A quick way to circumvent this problem is to create a dynamic IN selection making your PIVOT dynamic. For demonstration we will use a table Books in a Bookstore’s dat...

program WhileEOF; {$APPTYPE CONSOLE} uses SysUtils; const cFileName = 'WhileEOF.dpr'; var F : TextFile; s : string; begin if FileExists( cFileName ) then begin AssignFile( F, cFileName ); Reset( F ); while not Eof(F) do begin ...