April 19, 2012
This version uses SpreadsheetGear 2010 (6.0.3.190), NetAdvantage 2011,
Volume 1 (11.1.20111.2042), and Aspose.Cells 7.0.3.0.
Dodeca-essbase Service
- The dodeca-essbase service is now available for Essbase 11.1.2.2. and
APS 11.1.2.2. (#1084)
Essbase Excel Views
- Fixed issue encountered with a cascaded Essbase Excel view when the
SummarySheetAdd property is True and a sheet referenced by the
(automatically generated) formulas on the summary sheet contains a
single quote. (For instance, this could occur when a cascaded member
name contains a single quote.) This issue results in the following
error: Unable to build the view. Unable to do cascading. Unable to do
build the cascade summary sheet.
WorkbookViewControlImplementation.SetCellFormula failed. Invalid cell
formula. (#1085)
Excel, Essbase Excel, and SQL Excel Views
Fixed issue encountered when the view contains a protected worksheet
with Excel groups, and the row and column headings are not displayed.
When the user attempts to expand or collapse a group, the "Operation
cannot be performed on a protected worksheet" error is generated.
(#1087)
View Hierarchy Metadata Editor
- The Add View and Insert View dialog, which allows the selection of one
or more views, now supports sorting the View ID or View Name column by
clicking the column header. (#1086)
Workbook Script Functions, Methods, Properties, and Event Links
- Fixed issue with BuildRangeFromScript (all overloads) — When the
EnterNumbersAsText argument is True, numeric values appear in the cell
with a single quote in front of the number. (#1080)
Fixed issue with workbook script shared properties not being shared
with the target view when using any the following tool controllers:
(#1083)
OpenViewUsingActiveWorksheetAndSelectorStateToolController
OpenViewUsingActiveWorksheetStateToolController
OpenViewUsingSelectorStateToolController
OpenViewUsingViewStateToolController
- SetHyperlink — E-Mail overload: Added the following optional
arguments: CopyTo, BlindCopyTo, and Body. These arguments can be used to
specify the recipient(s) to receive a copy of the email, the
recipient(s) to receive a blind copy, and the content of the email,
respectively. (#1082)
New Method: The WriteLogMessage method supports the ability to write
messages to a log file from a workbook script. The method-specific
arguments include the following:
- Message — The message to write to the log.
- IncludeTimestamp — If True, prepends the message with a timestamp.
- Filename — The name of the file, which defaults to dodeca.log.
- Folder — The folder to write the log file, which defaults to the
user’s home directory. Note that the @SpecialFolder(<FolderID>)
function can be used to return the directory path to a system special
folder on the client. (#1081)
Dodeca Framework