Excel Ticker

Excel Ticker

27. September 2011
by Mourad Louha
0 comments

Server failure on this domain on 09/26/2011

Unfortunately, my provider 1&1 experienced some network configuration problems on 09/26/2011 that have led to a server failure from approximately 14:45 to 16:45 and from 19:45 to 21:30 o’clock (Central Europe time).

Not only this domain was affected, but also several other domain hosted on this server like the German Excel Ticker, the Website about my services, the Excel Formula Translator or the German Office365-Forum.

According to the 1&1 blog, the failure was caused by a faulty network configuration, which in turn was caused by a software.

23. September 2011
by Mourad Louha
0 comments

Excel workbook including the formula translations for 32 languages as a byproduct of the Excel Formula Translator

While implementing the Excel Formula Translator in PHP, I created an Excel workbook including all my translations of the Excel formulas, error codes and arguments of the CELL() and INFO() functions. I thought, it would be a good idea to offer the file for free at the end of this article. Please do not hesitate to send me an e-mail or leave a comment here, if you find an error in one of the translations.

To extract the formulas in the different languages, I had firstly inserted all available formulas in a column in the “Formulas” worksheet of the workbook. For this, I used the English version of Excel, as English is my reference language and I sorted all formulas in alphabetical order. Of course, as I am usually using the German version of Excel, I had to install the English language pack.

Excel Formula Translator

Continue Reading →

22. September 2011
by Mourad Louha
0 comments

Online Excel Formula Translator Version 1.50

I recently released version 1.50 of my free online Excel Formula Translator. The translator can be used to translate both single Excel Formulas and combined complex formulas. For example the formula =PROPER(MID(A1;FIND(“.”;A1)+1;FIND(“@”;A1)-FIND(“.”;A1)-1)) to extract the first and last name from an e-Mail address is translated to =NOMPROPRE(STXT(A1;TROUVE(“.”;A1)+1;TROUVE(“@”;A1)-TROUVE(“.”;A1)-1)) in French.

MSDN actually provides 43 language packs for Microsoft Office 2010, which I downloaded and installed in a virtual machine. I then compared the Excel functions, the Excel error codes and the arguments of some specific functions to the English version. And I have found 32 languages which have differences and included these languages in the translator.

Excel Formula Translator

However, in some languages the differences are minimal. For example, the only difference I found in the Japanese language pack is the DOLLAR() function which was replaced by YEN(). Another example is Thai, where the only difference is the argument “System” for the INFO() function. So, for these languages, the translator will in most cases return the same result as for English.

Continue Reading →

3. July 2011
by Mourad Louha
0 comments

Excel Add-In for listing all trusted documents and folders in Office

Occasionally I am also active in the French Microsoft Office TechNet forum, on one hand to practice my French and on the other hand just out of curiosity. Some time ago, someone asked there whether it is possible to retrieve a list of all trusted documents of Word 2010.

Unfortunately the Trust Center of Office 2010 does not offer a possibility to see which documents have been added to the trusted list of documents.

Trusted Folder and Documents

So I had the idea to implement a free Excel Add-In and list all trusted documents in an Excel sheet. And, when I am at it, I thought it should be a good idea to implement a function for listing all trusted folders too. And I should include the trusted documents and folders for PowerPoint, Word and Excel from Office 2007 and Office 2010.

Continue Reading →

3. July 2011
by Mourad Louha
0 comments

Start of our forum for Office365 at www.office365-forum.de

Two days ago (July 1st, 2011), we started our forum for a German speaking audience and unlocked the user registration. We would like to thank to all developers from “Simple Machines” for creating a great forum software which is easy to administer and also already has a pleasant default layout.

Office365 Forum

We have created categories including forums for the Office Web Apps and for the e-Mail, calendar, team and communication features of Office365. A category offers forums for discussions about the administrative tasks in Office365. Another category is provided for collecting tips and tricks, book and website recommendations from our users and for linking to news from Microsoft about Office365.

The next steps will be to create a specific design, of course standards compliant, and to add some interesting features for the forum. I am also preparing the migration to a new provider as the current provider unfortunately does not satisfy my needs.

 

18. June 2011
by Mourad Louha
0 comments

Forum for the Excel Soccer World Cup Planner

The forum forum.excel-soccer-2011.de for the Excel Soccer World Cup Planner was officially released by me today. Like the Excel Soccer World Cup Planner, the forum is available in the three languages German, Englisch and French. You can ask questions there about the planner and, of course, post bug reports or suggest new features for the next versions of the planner. A subforum collects all ideas from our users. The forum will also remain active after the Womens’ World Cup this year and be available for future versions of the planner.

I would also like to announce another forum, which will not be related to the planner but to another very interesting product and theme. I have already reserved all domains for this forum and will write more about it the next days, so please stay tuned.