Recent articles on Medium

Syntax Highlighter test for Excel

To be more readable, code is usually “highlighted”: colorized. Unfortunately, as Excel is not a language, there no specific tool to highlight the formulas. Here is a list of try to find the nearest suitable highlighter.

#button {
	font-weight: bold;
	border: 2px solid #fff;
}

JS

=sum(Salary[Bonus])
=sum($D$2:$D$36)

Java

=sum(Salary[Bonus])
=sum($D$2:$D$36)

Perl

=sum(Salary[Bonus])
=sum($D$2:$D$36)

Delphi, pascal

=sum(Salary[Bonus])
=sum($D$2:$D$36)

Groovy

=sum(Salary[Bonus])
=sum($D$2:$D$36)

Powershel PS

=sum(Salary[Bonus])
=sum($D$2:$D$36)

Scala

=sum(Salary[Bonus])
=sum($D$2:$D$36)

Erlang

=sum(Salary[Bonus])
=sum($D$2:$D$36)

vb

=sum(Salary[Bonus])
=sum($D$2:$D$36)

Javascript for personal Sharepoint

In my organization, there is no direct link to our personal Sharepoint site. Only the team site is directly available from the office sidebar. Unfortunately, two different domain are used to host students and teacher depending on their email.

Here is a little script that I included in Moodle to let my student and other teachers access there microsoft sharepoint site.

Remarks:

  1. No form tag : The form tag make the page change when the user click submit. I wanted the page NOT to change.
  2. Double = : In the if, you have to use the “==”
  3. Not found : the string search returns -1 when nothing is found
<input id="myEmail" name="email" value="" type="text" /> <input style="background: blue; color: white;" value="sharepoint" onclick="
var myEmail = document.getElementById('myEmail');
var str = myEmail.value; var myLink = document.getElementById('myLink'); 
str = str.replace('.','_');
str = str.replace('@','_');
var domain = 'domain1';
if (str.search('domain1_com') == -1) { domain = 'domain2'};
var myUrl = 'https://'+domain+'-my.sharepoint.com/personal/'+str+'/_layouts/15/viewlsts.aspx?view=14';
if (str =='') {alert('saissisez votre mail / type your email')} else {window.open(myUrl, '_blank')}" type="submit" />

wordpress hello dolly

Here is one of the simplest plugin.
It includes (among other things):

  • variable declaration
  • echo something
  • css string inclusion in head

Source: https://plugins.trac.wordpress.org/browser/hello-dolly/trunk/hello.php

Quoted from:

Plugin Basics

<?php
/**
 * @package Hello_Dolly
 * @version 1.6
 */

/*
Plugin Name: Hello Dolly
Plugin URI: https://wordpress.org/plugins/hello-dolly/
Description: This is not just a plugin, it symbolizes the hope and enthusiasm of an entire generation summed up in two words sung most famously by Louis Armstrong: Hello, Dolly. When activated you will randomly see a lyric from <cite>Hello, Dolly</cite> in the upper right of your admin screen on every page.
Author: Matt Mullenweg
Version: 1.6
Author URI: http://ma.tt/
Text Domain: hello-dolly
*/


function hello_dolly_get_lyric() {
        /** These are the lyrics to Hello Dolly */
        $lyrics = "Hello, Dolly
Well, hello, Dolly
It's so nice to have you back where you belong
You're lookin' swell, Dolly
I can tell, Dolly
You're still glowin', you're still crowin'
You're still goin' strong
We feel the room swayin'
While the band's playin'
One of your old favourite songs from way back when
So, take her wrap, fellas
Find her an empty lap, fellas
Dolly'll never go away again
Hello, Dolly
Well, hello, Dolly
It's so nice to have you back where you belong
You're lookin' swell, Dolly
I can tell, Dolly
You're still glowin', you're still crowin'
You're still goin' strong
We feel the room swayin'
While the band's playin'
One of your old favourite songs from way back when
Golly, gee, fellas
Find her a vacant knee, fellas
Dolly'll never go away
Dolly'll never go away
Dolly'll never go away again";
        // Here we split it into lines
        $lyrics = explode( "\n", $lyrics );
        // And then randomly choose a line
        return wptexturize( $lyrics[ mt_rand( 0, count( $lyrics ) - 1 ) ] );
}


// This just echoes the chosen line, we'll position it later
function hello_dolly() {
        $chosen = hello_dolly_get_lyric();
        echo "<p id='dolly'>$chosen</p>";
}


// Now we set that function up to execute when the admin_notices action is called
add_action( 'admin_notices', 'hello_dolly' );
// We need some CSS to position the paragraph
function dolly_css() {
        // This makes sure that the positioning is also good for right-to-left languages
        $x = is_rtl() ? 'left' : 'right';
        echo "
        <style type='text/css'>
        #dolly {
                float: $x;
                padding-$x: 15px;
                padding-top: 5px;
                margin: 0;
                font-size: 11px;
        }
        </style>
        ";
}


add_action( 'admin_head', 'dolly_css' );


?>