09 June 2014Rosetta Studio v4.5 Available for Downloading

Version 4.5 of Rosetta Studio™ is now ready for
downloading. This version contains
several significant new features and enhancements to existing features.

The major new feature of this version is the ability to
automatically execute user created PowerPoint® or Excel® macros.

The ability to preview data tables directly from the Data Pool has been added with controls
for zooming and navigating within the Preview
Window.

Transposition of simple tables has been added as a table
option for Generate/Update.

Major speed improvements have been made to the population of
jobs that frequently pull data from different data pools.

Details on a WebEx introduction of version 4.5 are included
below. RSVP to confirm your
participation.

The relevant updated manual sections are indicated in red.

New Features

Automatic Execution of Macros

Rosetta Studio™ will now allow you to automatically run macros upon completion of Populate, Update, or Generate. Both PowerPoint® and Excel® macros are
supported. Macros can be run on entire
files or on ranges of slides. Users may
choose to delete the macro upon execution.

Populate – Upon completion of populate, Rosetta Studio™ will execute a macro that you have
embedded in your shell. You may choose a
starting function and have the macro executed on the entire report or on
selected slides or worksheets. The macro
can be removed from the file after execution.

Batch Populate – Execution
of macros within Batch Populate
work the same as they do in Populate
with the exception that the starting function must be called Main.

Generate – Generate will append your output to a file that
contains your macro. The macro will then
be executed and removed if specified.
The macro can be run on the entire presentation or on specific slides or
worksheets.

Update – Execution of macros within Update works in
a similar fashion to how they work in Populate. Once the update is completed
the macro is executed. In order for this
to work you would need to leave the macro embedded upon the completion of Generate.

Note that the
security options within Excel® and PowerPoint® must be set to allow for the
execution of the macros.

Running Macros automatically
1.3.6

Preview Data Tables

Data tables can now be previewed directly from the Data Pool. It is no longer necessary to open a data
table in the Data Editor to view its
contents. A data table selected in the Data Pool can be opened in the Preview Window by right clicking and
selecting ‘Preview Table’.

The Preview Window
will display the entire data table selected including any hiding applied to
that table.

Once a data table is open in the Preview Window a number of new functions become available including
a zoom slider and scroll bars to navigate horizontally and vertically around
the table.

Right and left arrows allow you to move through the Data Pool in the preview window.

Preview Data
Tables 2.5.19

Reset All Hiding

An option has been added to reset hiding across the entire Data Pool or for any number of selected
tables. This new option is located in
the Data Pool toolbar.

Reset Hiding
2.6.7

Transpose Tables

An option, flip axes, has been added to Table Options to allow tables to be transposed when generated. This is similar to flip axes in chart
options. Stubs will be displayed as
banners and vice versa.

This option will only work with tables that have a single
layer of banner text. If you hide the
upper levels it will work.

Table Options/General
Options/More Table Options 3.8.2

Batch Import

The Import option now supports the selection of multiple
files. Use the shift/ctrl keys to
highlight several files (of the same import type) and import them
simultaneously.

Importing Data
Tables 2.2

Enhancements to Existing Features

Enhancements to the Preview Window

The features
added to the Preview Window for data
tables will work on charts, tables, text boxes, slides and templates.The
zoom slider and scroll bars will allow you to navigate around the object or
slide that you have loaded in the Preview
Window.

The forward and backward arrows will allow you to change the
objects or slides in the Preview Window. If you have clicked on a slide in the Report Window the arrows will move one
slide at a time forwards or backwards.
If you have selected an object within a slide the arrows will move
between objects on that slide.

An Edit icon has been added which, if selected, will open
the object or slide being previewed for editing.

The Preview Window 3.5.1

General Options - Code Help

The Code Help display option in the Data Editor has been changed to a toggle button to switch the Code
Help display off and on.

We have also added an option to display Code Help by
default. This option is located in the
Data tab in General Options found on The Ribbon. When this option is enabled, any tables
opened in the Data Editor will have
the Code Help display turned on.

General
Options/Data 3.12.4

Generate to an Existing File

As a result of the work done with macros,
it is now possible to generate to the end of an existing file that does not
contain a macro.

Faster Populate Times across Multiple Data Pools

When using Populate with tags that
draw from multiple Data Pools the
time required for population has been decreased. This will be most noticeable when
slides/worksheets contain large numbers of tags referencing different Data Pools (i.e., nested tags). In these cases populate time reductions of
75% or more have been recorded.

Permanent Rounding

By default Rosetta Studio™ only changes the display value
when rounding, keeping the true value intact.
A new option has been added to permanently change the true value in
addition to changing the display value.

When performing calculations Rosetta Studio™ uses the true
value. Permanent rounding will allow the
calculations to match the display values.

Note that this is a permanent change to the value.

Data Format
Options 2.5.16

Adjustments to Reporter/mrTables Import (.mtd)

The Reporter/mrTables import engine now provides options to
display the table text, the variable text, or both to be included as the table
title. On import a single dialog box is
displayed which allows the user to define which option they would like to
choose, rather than a series of popup boxes.

Import Options
Specific to Desktop Reporter/mrTables Files 2.2.2

Conditional Hiding – Ignore Hidden Data

Conditional hiding now allows users to perform conditional
hiding actions on only shown data (ignoring hidden data). Prior to this option being implemented,
conditional hiding evaluated an entire row or column based on the defined
condition. With this option enabled only
the relevant (shown) data is analysed.

2.6.8
Conditional Hiding

Minor
Improvements

-Text
Encoding of Imported Files

A new option has been added to
General Options to allow for specifying the language for text encoding of
imported files.

-Slide
Count Starts at ‘0’ in PowerPoint®

PowerPoint® reports that have slide counts starting at ‘0’ are
properly identified in the Slide Range selection fields when updating or
populating a report.

-Automatic Selection of Edited Color Options

When editing a Color Map or
Color Palette in Report Options the last edited color option is automatically
selected upon exiting the option.

-Tagging Offsets with Tag Ranges

When tagging by text, tagging
offsets and tag ranges can be used together to perform calculations using
functions.

Retrieving files that are saved
to network drives are now supported in Batch Populate job lists.

-Populate Formatting Correction

The use of value rounding with
populate formatting (/*round=#*/ or /*drop=#*/) no longer drops the zero on the
resulting output.

-Various UI improvements to improve window views

-Various bug fixes and improvements

Version 4.5 WebEx Sessions

Join us for a WebEx meeting to review the new features included
in v4.5

Please choose one of the following meetings and RSVP via
email to support@rosetta-intl.com. Meeting details will be sent after receiving confirmation. Should you not be able to attend either WebEx
please contact support@rosetta-intl.com
and request a recorded copy of the WebEx.

Downloading Rosetta Studio 4.5

To obtain your copy of Rosetta Studio 4.5 your system
administrator will need to login to the Rosetta Studio website http://www.rosetta-intl.com/Account/LogOn and download the appropriate bit version of
Rosetta Studio 4.5 using your company credentials.

Any existing versions of Rosetta Studio that are already
loaded will need to be uninstalled. If
you need any instruction on uninstalling or accessing/downloading from the
website please contact support@rosetta-intl.com.

The website also has a download link to the Rosetta Studio 4.5
manual. This is a great resource for
troubleshooting Rosetta Studio or learning more about a specific option or suite. Refer to the sections below for assistance.

PowerPoint® and Excel® are
Registered Trademarks of Microsoft Corporation.

Rosetta Studio™ is a
registered trademark of ATP Canada Software & Services Ltd. All other trademarks are trademarks of their
respective owners. This document may not
be reproduced or distributed without express written consent of Rosetta Studio™
Intl.