I’ve had this error pop up while trying to open Excel files (Excel 2007) after installing Live Office on several machines where it says “There was a problem sending the command to the program“. A couple other people ran into the same issue, so I’d like to post a quick solution.

1. Open the Excel program
2. Go to Excel Options
3. Go to Advanced
4. Go to General
5. Make sure “Ignore other applications that use Dynamic Data Exchange (DDE)” is unchecked.

That’s all!

This article talks about using the filtered rows technique instead of a VLOOKUP.
Not until Xcelsius 2008 came out, were we able to filter on multiple rows of data that matched 1 entry. So in order to accomplish this we would either have to use VLOOKUP or INDEX MATCH. Using this technique was very cumbersome and although filtered rows has been available for a while, I have been on a couple engagements where I still see VLOOKUPS in the excel spreadsheet!

Thus hopefully writing this article will get the practice of using filtered rows ingrained in the
Xcelsius Developers minds.

I’ve created a video below that shows 2 scenarios below using VLOOKUP and filtered rows. I’ve shown how much easier it is to use filtered rows and how much easier it is in the future to maintain.

I’ve also attached the source files from the 2 examples so you may do your own comparisons.

You may download the source files here

The Push Button is a powerful new feature in Xcelsius SP3 that allows developers to transfer source data from an arbitrary sized cell block to a destination cell block of the same size. This gives us a triggering type mechanism where we needed to jump through hoops in order to accomplish before.

I’ve attached a video and the example xlf source file which shows how to use the push button as a default/reset button.

If you have any additional examples that you would like to share, please post them on the comments section below.

Please download the source file here

Dynamic Color Binding is a great new feature in Xcelsius SP3 that allows developers to dynamically bind colors. This gives developers total flexibility on dynamically customizing their coloring schema during run time.

I’ve attached a video which shows a couple examples on using dynamic color binding.

If you have any additional examples that you would like to share, please post them on the comments section.

In this article I’ve attached a video that talks about the new Canvas Container feature in Xcelsius 2008 SP3.
I found that the Canvas container is very easy to use and provides the same functionality as the group method but allows the flexibility of moving objects in and out of the canvas very easily.

I totally recommend that Xcelsius developers use the Canvas container method to group objects instead of the old grouping method.

I am curious of the canvas container performance and if it is buggy as I have not experienced any problems yet, so please feel free to comment with your experiences.