If you create an Excel file using an HTML Table, then it exists a way to format the cells based on some CSS rules. Some examples can be found on this blog post. I spent some time trying to figure out how to display correctly the dates, whatever your regional settings are ; for exemple […]
Auteur/autrice : Aymeric
Pure Javascript Drag and Drop cross browser from IE8
I was looking for a simple JavaScript to drag a div element around, and that would work with IE8 and without any third party libraries (like jQuery). It’s been very difficult to find a simple code ! Finally http://news.qooxdoo.org/mouse-capturing saved me with some code… but there was still a problem with IE8 due to the […]
How to expand Sharepoint 2013 calendar by default [JavaScript]
This code has been tested for Sharepoint 2013 only. It permits to expand by default (so as soon as the page is loaded) the events in the Month calendar view. See here a solution for Sharepoint 2010. Tested with IE8 and Firefox 41. You’ll have to add the below JavaScript code into your calendar page: […]
Transform pseudo currency to number in JavaScript
In JavaScript I want to change some formatted numbers to a regular number. The code might be look like that: var aNb=[ 1500, « 1,500 », « 15,00 », « 1,500,000 », « 1,500,000.25 », « 1000.25 », « 1 000 000 »]; for (var i=0; i < aNb.length; i++) { var nb = aNb[i] + « »; if (nb.split(« , »).length <= 2) nb = nb.replace(/,(\d{2})$/, ».$1″); nb = nb.replace(/[^\d\.\-]/g, […]
Force CORS headers in Firefox to allow cross domain calls
This guy created a Firefox extension to force the CORS (access-control) headers from a call. This is very useful when you want to do a JavaScript/AJAX query over another website that doesn’t allow the cross domain calls. His code is on github. I’ve the XPI compiled version on my blog (into a ZIP file) found […]
Sharepoint Workflow: Check if a field is empty [Sharepoint 2010]
The Sharepoint workflows are powerful but sometimes stupid… If you want to: Check if a Date Field is empty, then you can use a String Workflow Variable that contains your Date Field as a Short Date (SP2013) (or a String for SP2010), and then compare it to « 1/1/0001 » (or « 1/1/0001 12:00:00 AM » for SP2010) Check […]
« class-phpmailer out of memory using GuiForm » avec WordPress
Ayant un WordPress sur 1and1 j’ai été confronté à un « out of memory » sur le fichier class-phpmailer.php à cause d’un appel AJAX d’un formulaire créé avec GuiForm. Je ne peux pas faire grand chose côté serveur à cause de l’hébergement partagé… Donc j’ai fouillé comment contourner le problème. Il va s’agir de modifier le fichier […]
Afficher correctement les caractères dans les fichiers de logs [Unix]
Lorsqu’on regarde ses fichiers de logs Apache (par exemple), on peut se retrouver face à des caractères dont l’encodage est bizarre… par exemple « là » donnera « l\xe0 ». Pour afficher correctement les caractères dans votre console (en l’occurrence j’utilise Putty en encodage Latin1), il faut utiliser la commande suivante, trouvée sur StackOverflow : tailf /var/log/apache2/error.log | while […]
Windows 10 et Cortana : lancer les recherches sur Google au lieu de Bing sous Firefox
Microsoft essaie d’imposer son moteur de recherche, mais je continue à préférer Google…. Du coup quand Cortana sous Windows 10 nous redirige sur Bing, ça m’agace… Sous Firefox on peut utiliser l’extension Redirector puis appliquer les règles suivantes : Example URL : https://www.bing.com/search?q=*&* Include Pattern : https://www.bing.com/search?q=*&* Redirect To : https://www.google.de/#safe=off&q=$1 Pattern Type : Wildcard […]
Android 5.1.1 system rw Operation not permitted
I was trying to update my Sony Xperia Z3 Compact from Android 5.0.2 (rooted) to Android 5.1.1, and everything worked well except that I got this issue : mount: Operation not permitted when I was trying to put in write mode the system folder. Also I tried SDFix and I got the error « Update failed, […]