January 9, 2013
This version uses SpreadsheetGear 2010 (6.0.3.190), NetAdvantage 2011, Volume 1 (11.1.20111.2042), and Aspose.Cells 7.0.3.0.
The release notes for this version contain the following sections:
AutoBuild Tool Controller
Excel, Essbase Excel, and SQL Excel View Types
Office 2010 Style Library and the Essbase Selector Tree
Selectors
View Metadata Editor
View Template Designer
Workbook Script Editor
Workbook Script Functions, Methods, Properties, and Event Links
Workbook Script Tool Controller
AutoBuild Tool Controller
- Fixed issue encountered when a workbook script cancels the build in the AfterBuild event, yet the AutoBuild tool controller still uncovers the view. (#1150)
Excel, Essbase Excel, and SQL Excel View Types
- Added the *OutlineVisible* property, which controls whether the outline symbols are shown for all template and cascade worksheets. The property can be set to True, False, or Default. When set to Default, the visibility setting in the Excel template is used. (In Excel 2010, the "Show outline symbols if an outline is applied" setting can be edited in the Excel Options dialog under Advanced / Display options for this worksheet.) (#1152)
Office 2010 Style Library and the Essbase Selector Tree
- The Office 2010 Style Library, which is the style used by the metadata_starter_kit applications, contains the appearance definition used by the Essbase Selector Tree. The definition defines the background color of the active node in the tree as the same color used as the background of a selected node. This can be visually misleading. To avoid any confusion, the STARTER_KIT version of the Office 2010 Style Library (Blue) binary artifact has been modified to set the background color of the active node to be transparent. If you have an application that uses the Office 2010 Style Library, you can import the updated version from the metadata_starter_kit, which is installed in the Dodeca Framework metadata folder. For example, C:\Program Files (x86)\Applied OLAP\Dodeca Framework 6.4.0.3768\metadata\metadata_starter_kit.zip.
If you need more information or assistance, contact support@appliedolap.com.
Selectors
Added the ability to specify the toolbar to which a selector is added on a selector-by-selector basis
_Since a selector can be used to represent a setting that is not considered a point-of-view selection, you may want to layout the selectors in different toolbars. _
By default, all of the selectors that are configured for a view are added to the toolbar that has "View" as the key. To allow selectors to be added to a toolbar other than the default, the Configure Selectors dialog now supports the ability to specify a toolbar ID for a selector. If the ViewToolbarConfigurationID has been specified for the view, the toolbar ID dropdown list contains all the toolbar keys defined in the toolbar configuration.
Helpful Hint
The View toolbar (i.e. the toolbar with the Key set to "View"), which is the default selector toolbar, is flagged as the Main menu bar in all of the view-related toolbar configurations that are included in the metadata starter kit. Only one Main menu toolbar is allowed in a toolbars configuration.
The main menu bar has the following characteristics:
- The main menu bar is always visible.
- The main menu bar fills the entire row, such that no other toolbar will appear on the same row.
All of the tools in the toolbar are always visible. Tools are wrapped to multiple rows when the toolbar width cannot accommodate all of the tools.
View Metadata Editor
- Added the Open (Excel) View Wizard and Open (Excel) View Template Designer tools to the View Metadata Editor. These tools are enabled when the selected view is an Excel, Essbase Excel, or SQL Excel view. (#1142)
View Template Designer
- Fixed issue with the Name Manager encountered when a defined range "RefersTo" value contains a formula, such as OFFSET or an IF condition. When the range is selected in the list of defined names, an error similar to following is displayed: grid_AfterSelectChange failed. WorkbookViewControlImplementation.SelectRange failed. "B35,0,11,1,1)" is not a valid range name or reference for sheet "Sheet1". (#1156)* *
Workbook Script Editor
- Fixed issue in the Find dialog, which did not always find multiple occurrences of the same string. For instance, when multiple instances of the same method are called within a given procedure, only the first occurrence of the method is found. (#1159)
Workbook Script Functions, Methods, Properties, and Event Links
Fixed Issue: BuildRangeFromScript Method — Issue encountered when the method inserts columns and the CopyFromRange contains multiple columns. Only a single column is inserted for each value generated by the script.
Resolution: The number of columns inserted is now computed based on the number of values generated by the script multiplied by the number of columns in the CopyFromRange. (#1149)
- Modified SetProtection Method — Added Password argument for the Workbook overload. The argument is used in conjunction with the StructureProtected argument to prevent the user from unprotecting the structure. (#1155)
- New Method: RenameWorkbook allows the name of a specified workbook to be changed. This method should typically not be used to change the name of the view’s workbook. (#1157)
RenameWorkbook was implemented to allow the view’s workbook to contain external references, which should be dynamically resolved at runtime. The source workbook is stored as a binary artifact, and is loaded during the AfterWorkbookOpen event using the LoadWorkbook method. Since the loaded workbook name is based on the binary artifact ID and version, and not the workbook name referenced by the view’s workbook, RenameWorkbook is used to rename the loaded workbook, so that the references can be resolved.
- New Function: ActiveSheetNumber returns the one-based index for the active sheet.
Function Usage: @ASheetNumber() (#1154)
- New Function: SelectorMemberAlias returns the alias(es) of the selected members for the specified Essbase selector. If a given member does not have an alias, the member name is returned. (#1153)
Function usage: @SMbrAlias(<SelectorID>, [<Delimiter>])
- New Function: SelectorMemberName returns the name(s) of the selected members for the specified Essbase selector. (#1153)
Function usage: @SMbrName(<SelectorID>, [<Delimiter>])
- New Function: SheetCount returns number of sheets in the active workbook.
Function Usage: @SheetCount() (#1154)
WorkbookScript Tool Controller
- Fixed issue encountered when the tool controller is associated with a state button: With the CheckedPropertyName and ValuePropertyName tool arguments both specified, the button’s state immediately resets to the previous state when the user checks/unchecks the button. (#1148)