Tutorial by Examples: for

The first function, using an array, is much faster If called without the optional parameter, will default to .ThisWorkbook.ActiveSheet If the range is empty will returns Cell( 1, 1 ) as default, instead of Nothing Speed: GetMaxCell (Array): Duration: 0.0000790063 seconds GetMaxCell (Find ...

Deleting rows is slow, specially when looping through cells and deleting rows, one by one A different approach is using an AutoFilter to hide the rows to be deleted Copy the visible range and Paste it into a new WorkSheet Remove the initial sheet entirely With this method, th...

The procedures bellow will temporarily disable all Excel features at WorkBook and WorkSheet level FastWB() is a toggle that accepts On or Off flags FastWS() accepts an Optional WorkSheet object, or none If the ws parameter is missing it will turn all features on and off for all WorkSh...

Example shows 5 items per row: <div *ngFor="let item of items; let i = index"> <div *ngIf="i % 5 == 0" class="row"> {{ item }} <div *ngIf="i + 1 < items.length">{{ items[i + 1] }}</div> <div *ngIf="i + 2 &l...

While you are not allowed to use *ngIf and *ngFor in the same div (it will gives an error in the runtime) you can nest the *ngIf in the *ngFor to get the desired behavior. Example 1: General syntax <div *ngFor="let item of items; let i = index"> <div *ngIf="<your cond...

int DVRowLimit = (Int16.MaxValue); CellRangeAddressList cellRangeFieldsType1 = new CellRangeAddressList(1, DVRowLimit, targetFirstCol, targetLastCol); XSSFDataValidationConstraint dvConstraint = (XSSFDataValidationConstraint)validationHelper.CreateDateConstraint(OperatorType.BET...

dvConstraint = (XSSFDataValidationConstraint)validationHelper.CreateTimeConstraint(OperatorType.BETWEEN, "=TIME(0,0,0)", "=TIME(23,59,59)");

string emailValidationFormula = GetEmailValidationFormula(targetFirstCol); CellRangeAddressList cellRangeFieldsType5 = new CellRangeAddressList(1, DVRowLimit, targetFirstCol, targetLastCol); dvConstraint = (XSSFDataValidationConstraint)validationHelper.CreateCustomConstraint(emailValidation...

There are a number of properties that can be applied to sections of RichText. var title = cell.RichText.Add("This is my title"); // Data Type: bool // Default Value: false title.Bold = true; // Data Type: System.Drawing.Color // Default Value: Color.Black title.Color = C...

One can use the command-line launching facility is when one wants to customize some aspects of the way MySQL Workbench operates. MySQL Workbench has the following common command line options: --admin instance - Launch MySQL Workbench and load the server instance specified. --query connection - ...

var assert = require('assert'); describe('String', function() { describe('#split', function() { it('should return an array', function() { assert(Array.isArray('a,b,c'.split(','))) }); }); });

Information about vertex attributes can be retrieved with the OGL function glGetProgram and the parameters GL_ACTIVE_ATTRIBUTES and GL_ACTIVE_ATTRIBUTE_MAX_LENGTH. The location of an active shader attribute can be determined by the OGL function glGetAttribLocation, by the index of the attribute. G...

Information about active uniforms in a program can be retrieved with the OGL function glGetProgram and the parameters GL_ACTIVE_UNIFORMS and GL_ACTIVE_UNIFORM_MAX_LENGTH. The location of an active shader uniform variable can be determined by the OGL function glGetActiveUniform, by the index of the ...

LibGDX is designed in a way that you can write the same code and deploy it on several different platforms. Yet, there are times when you want to get access to platform specific code. For an instance, if you have leaderboards and achievements in your game, you may want to use platform-specific tools ...

There is a bug/fix for boost 1.64, the bug only affects Windows, apparently. reference: https://github.com/klemens-morgenstern/boost-process/issues/90 and https://github.com/klemens-morgenstern/boost-process/commit/74814e46c1614850a8e447fd689c21cf82f36ceb in file boost\process\detail\windows\a...

These locators should be used as a priority when possible, because they are more persistent to changes in an application then locators based on css or xpath, which can easily break. Binding locator Syntax by.binding('bind value') Example View <span>{{user.password}}</span> <s...

If you have your data with each month of data arranged in rows like so: start by creating quarterly sums in the adjacent columns, D & E in our example. Start with the third row in the new column or the first quarter you want to create, in this example we'll use March 31st (2000-03-31). Use t...

Here is how to create your own singleton class for toast messages, If your application need to show success, warning and the danger messages for different use cases you can use this class after you have modified it to your own specifications. public class ToastGenerate { private stati...

This example requires FormsModule and ReactiveFormsModule. Please import them in your application/module. import {FormsModule, ReactiveFormsModule} from '@angular/forms'; input-form-example.html <form class="example-form" (ngSubmit)="submit(addForm.value)" [formGroup]=&qu...

This example requires FormsModule and ReactiveFormsModule. Please import them in your application/module. import {FormsModule, ReactiveFormsModule} from '@angular/forms'; autocomplete-overview-example.html: <md-input-container> <input mdInput placeholder="State" [mdAutocom...