Xcelsius message Loading Scheme

The original Article is from workshop.

XLF file: http://www.clariba.com/blog/wp-content/uploads/2010/11/test_v3.zip

Online Demo: http://www.clariba.com/blog/wp-content/uploads/2010/11/loading-message_solution.swf.

The biggest problem in xcelsius development is performance. For performance problems, you can modify the connection options and query to reduce the number of components in xcelsius or the number of formulas in Excel. however, xcelsius still takes a long time to load. in fact, formulas such as sumif and Vlookup take several seconds. since the waiting time cannot be reduced, make the waiting interface more friendly. Use the progress bar (loading progress!

I created a loading button. When you click this button, the progress bar is displayed first and then the data is displayed. However, the progress of this data is not a real response to the loading progress, you can download the XLF file. note that the trigger point is completed in Excel instead of the control in xcelsius.

The components I use are as follows:

> Combo box1: Filter and select data and insert it to the specified destination (use filtering row settings)

> Combo box2 (hidden under combo box1): Combo box2 works only when the play button is clicked, because the filter row must be visible. it was strange to Use combo box2 at first, because destination maps two rows and two columns, so the combo box must always select 1 to display the title. then, Use combo box1 to select the value of the row and map it to the spreadsheet table.

> Spreadsheet table: Only displays results.

> Play control: it controls combox2 and loads messages, and selects auto rewind (automatic rewind ).

> Background: Only for a real loading status, be sure to select block mouse events.

> Text label: it is equivalent to a prompt message, and the content can be modified at will.

> Horizontal progress bar: indicates that the loading progress is not a real progress.

It is really good to use control play and progress bar to simulate the progress. I never thought of using this method before. At least it gives the report a better user experience and can be used in future projects.