OnInit: this is really amazing thing in ionic2 or we can say in AngularJs2. With the same above example we can see what is ngOnInit is. So you are ready with the service method, now in your view/page you want that student list data available as soon as your view is going to appear, this should be th...
Log into a Google Account and click New > More > Google Forms.
Build the form fields required using the editor.
If the form was built with an account that is part of an organisation then click on the cog and unselect the option that only members can complete the form.
Set the form to save t...
The value of GOOGLE-FORM-PREFILLED-URL should look something like this:
https://docs.google.com/forms/.../?usp=pp_url&entry.1739003583=labelname1
jQuery('#googleFormButton').click(showGoogleForm)
jQuery('#googleFormButton').attr('googleFormsURL', 'GOOGLE-FORM-PREFILLED-URL')
Add a new function called showGoogleForm and adapt the follow code to suit. Note for simplicity this example does not contain any error checking which should be added in a production environment.
The url should look something like this:
https://docs.google.com/forms/.../?usp=pp_url&entry.17391...
To work with Json using C#, it is need to use Newtonsoft (.net library). This library provides methods that allows the programmer serialize and deserialize objects and more.
There is a tutorial if you want to know details about its methods and usages.
If you use Visual Studio, go to Tools/Nuget P...
Before reading some code, it is important to undersand the main concepts that will help to program applications using json.
Serialization: Process of converting a object into a stream of bytes that can be sent through applications. The following code can be serialized and converted into the previ...
You can receive a json from anywhere, a file or even a server so it is not included in the following code.
static void Main(string[] args)
{
string jsonExample; // Has the previous json
Author author = JsonConvert.DeserializeObject<Author>(jsonExample);
}
The method ".Dese...
Remove all conditional format in range:
Range("A1:A10").FormatConditions.Delete
Remove all conditional format in worksheet:
Cells.FormatConditions.Delete
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 ...
You need to include the Pagination.php in your page/s.
require_once 'Paginator.php';
$Paginator = new Paginator('mysql:host=localhost;dbname=ng_app', 'root', '000000');
$Paginator->setItemLimitPerPage(4);
$Paginator->setTable('comments');
$Paginator->createPages(); // this will creat...
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...
