(C) 2009 - 2014 by Mourad Louha · All rights reserved

All posts tagged Excel 2010

If you are using SkyDrive for storing your Office documents, you have probably already discovered the features for sharing your files with other people. And perhaps you have also read on some blogs how to embed an Excel file to your website. Recently, the Excel Team has created the possibility to interact with an embedded Excel file by using JavaScript.

In this blog post, I will describe how to embed and interact with an Excel file from SkyDrive. For this, I uploaded a web app compatible version of my workbook for my Excel formula translations and then I implemented some JavaScript Code to change values in the embedded file.

The workbook includes five worksheets: “Info” just includes some info’s about me, “Formulas” lists the formulas in the different languages, “Compare” can be used for comparing the formulas in two languages, “Languages” includes the list of available languages and “Resources” allows to select between the three languages German, English and French for the interface of the workbook. My goal was now to allow to the user to select the two languages for comparing the formulas and to switch from one interface language to another.

Learn and explore

Microsoft has recently launched the website “Excel Mashup”, where in addition to learning materials and tutorials you will also find some very interesting code samples. The site also lists the most important links to the MSDN documentation about the JavaScript object model, methods and properties for the Excel Services.

Read more

We have released the French version of our multiple year calendar template for Excel 2007 and Excel 2010. The calendar includes the official holidays for France. However, due to some regional differences for the holidays, you may activate or deactivate some entries.

The calendar can be downloaded from the follwing page, providing an overview of all current releases and translations of the calendar: “Overview of the Excel 2007 and Excel 2010 Calendar Templates for 2011

We will publish are more detailled manual in french (as included in the calendar templat) as soon as possible. The manual will the be downloadable as a PDF file.

Each calendar template contains a language and country code representing the language used by the template and the targeted country. For example, the code “DE-DE” is used for German and Germany and “EN-US” is used for English and the United States. The download files and the calendar files themselves also include this code in their names. And we have already entered the most important official holidays for each targeted country in the respective calendar templates.

Manuals for the calendar templates

I have published an online version of the manuals for the calendar templates in English and in German to this and the German sister blog. The manuals are describing the features and functions of the calendars. A shortened version of the manuals is also included in the calendars.

Language Manual Download
English Link to the blog post NA
French NA NA
German Link to the blog post NA

Download of the calendar templates

The following versions are currently available for download. Please note, that we are using a script which checks the referrer sent by the browser for ensuring that the download link is called from our site. Normally, the common browsers are sending the referrer from the last visited site by default. However, if you or someone else has disabled this function, the script redirects you back to the homepage when clicking on the download link. In case you cannot enable the referrer in your browser, please send me an e-mail to vba(at)maninweb(dot)de. I will then send you the calendar template either via e-mail or create a special download link for you.

Language Country Code Download
Englisch USA EN-US Version 1.10 – Build 200111
French Belgium FR-BR Version 1.10 – Build 200111
  France FR-FR Version 1.10 – Build 200111
German Austria DE-AT Version 1.10 – Build 200111
  Germany DE-DE Version 1.10 – Build 200111
  Liechtenstein DE-LI Version 1.10 – Build 200111

If you would like to inform us about an error in the calendar template or send us suggestions and wishes for the next versions of the calendar template, please use the comment function in this post. Finally, we would like to thank all users who had downloaded and are using our template.

 

We have modified and improved the calendar by adding a new option for selecting the date format from a list. Common German, English and French date formats are include in the calendar. You can also add up to two user specific date formats to the resource sheet.

The setting concering the date format is only from interest, if you are using an operating system which does not cover the fate formats included in the calendar. For example, if you are using an Italian version fo Windows, the English date format “MM/DD/YYYY” may not work. So, you may then enter your date format to the resource sheet. You can reach this sheet by clicking on the “Next” icon from the settings sheet.

We have also updated the detailled documentation for the calendar in the article „Excel 2007 and 2010 Calendar for 2011 (EN-US)“. The download link remains unchanged and you can download the file from the previously mentionned article.

 

Please note that I have modified the content of this article by adding the detailed description for the calendar and that I have shortened the article “Our contribution to the Microsoft 2011 Calendar Contest – US-Version” which previously included the description. The reason for this is that I would like to avoid confusions between the versions of the country specific calendars and want to keep in sync with the German and English articles.

On the occasion, when developing the German version of the calendar, I have added some new features to the calendar and updated the US-Version. And I have also fixed some minor bugs and extended the holiday calculation algorithms. These algorithms automatically calculate the dates of the holidays for the selected year, both fixed to a date and relative to each other. So, in general, there is no need to reenter the holidays each year.

Update on 01/05/2012: Please note, that the calendar can also be used for 2012. Just modify the year on the settings sheet.

At this point I would firstly like to thank Andreas for also testing the new version. And also thank Claudia for her support to the design. Of course, the current version for the calendar can be downloaded at the end of this article.

The calendar, originally developed for the Microsoft Office Calendar 2011 Contest, was made in Excel 2010 and has a similar layout to the Excel Soccer World Cup 2010 Planner, which has been downloaded over 375,000 times from its website. A navigation bar on the top of each sheet in the calendar allows you to easily navigate through the calendar.

Excel Calendar 2011

Read more

Like in my previous post, I found this strange behaviour when testing some sample files for my next article about PowerPivot in a computer magazine. In some cases, Excel 2010 does not correctly display the selected cell, especially if you are freezing rows. This behaviour does not appear in Excel 2007.

To reproduce the error, you may first create a new workbook in Excel 2010 and store the file. It does not matter whether you choose the old file format XLS or the new modern XLSX format. I created the two sheets „Fixed“ and „Standard“ in my workbook and formatted some cells as you can see in the screenshots below. Please note, that only Excel 2010 in German is currently available for me, but I think, this will be suffisent for the demonstration.

Excel 2010

The areas I to IV are containing merged cells. And the pane was freezed between row 7 and 8. If you select cell D2 by clicking with the mouse on this cell, then select the worksheet „Standard“ and go back to the sheet „Fixed“, the selected cell is correctly displayed.

An interesting effect occurs if you click on other cells. The follwing series of screenshots shows this behaviour of Excel 2010. First, I selected area I, as you can see below:

Read more