Search grid content on a board: Users can now search for, and navigate easily to, data they are interested in on a board grid. This matches the existing functionality available on worksheets.
Filter an expanded grid on a worksheet: Users can now filter the expanded secondary grid on a worksheet. This enables them to access the data they need on both the primary and the secondary grids on a worksheet, so they can compare and zero in on the areas that matter.
Context selector item selection: We have updated page header context selectors so the builder can now select which items they want end users to be able select from in the list. For example, the builder could set the line items they want to make available for end users to select on the page. We will be enhancing this in the future to also support the ability to filter the contents of a context selector.
Line items in forms: Page builders can integrate line items from selected modules into forms alongside list properties. Submitting a form now completes a two-step process where the new list item is created and then line item values are submitted into the chosen module against the new list item. Read more about creating forms with line items on Anapedia.
Form field validation: Using a toolbox of intuitive validation rules, page builders can guide users into submitting the correct data on their first attempt in the forms. Define fields as mandatory and decide whether they should accept letters, numbers, special characters or a combination - all with simple messaging for users when they complete their forms. You can read more about defining allowed character sets on Anapedia.
ALM enhancements: Improved robustness of ALM sync and introduction of restore point identifiers "Begin sync revision" and "End sync revision failed" to model History. These markers enable the identification of compatible restore points before or after an unsuccessful sync.
Dynamic Cell Access (DCA) enhancements: For DCA enabled cells, data imports are enhanced to update only the cells based on the respective users' dynamic cell access.
User Experience enhancements: New capability for model builders to open "line item subsets". An "Open button" is now available for "line item subsets", delivering functionality similar to open for "general lists".
Chart improvements: We've made improvements across all our current chart types: combo, pie, waterfall, line, bar, column & area charts - you now have better axis labels, animations and interactions.
Context selectors: You can now select a column header to change your context on a board or worksheet
Data entry: You can now enter all types of data in a grid as we released date input, the final data type.
You can now double tap on a cell to edit
We added a clear button for date entry on grids
An error message is displayed when invalid characters have been entered for number cells
We released the following improvements:
Re-open the app using biometrics after a period of inactivity
Easier access to tappable area when selecting lists or dimensions
View correct data when selective access to lists is applied
In addition, we fixed crashes so they won’t happen when:
Hitting the back chevron when navigating through a time dimension for context
Attempting to open additional insights panel
Drill down: Enable users to drill down on any cell value to either see the formula and inputs to the formula or the break down of the value. This allows users to see how the numbers are calculated to give them confidence in the figures and how they are derived. This is similar to the F8 drill down feature in classic today. The initial version will support a single level drill down but we will iterate to allow multiple-levels as in classic today.
Board PDF Export: Users will be able to export a board page to pdf as an image to share with colleagues or take a snapshot of a particular point in time.
Context selector filtering: Building on the select items for page header context selectors we are also adding the ability to filter page header context selectors. This allows builders to make the contents of the context selector dynamic based on a set of filter rules.
Share a page: In the New UX you will have the ability to share a page to one or many colleagues who have access to that page. They will receive an email with a link and be directed straight to the page.
Landscape mode: You will now be able to go into landscape mode for context selection, list inputs, grids on boards, charts, KPI & text cards.
Pinch & Zoom: You will be able to zoom in on charts and scroll through the data
Improved look and feel: In March, we will start improving the look and feel of the administration page to align with the New UX. There will be no changes to functionality, but you’ll notice that the page starts to look sleeker
The versions are aimed at enabling you to upgrade and move away from the soon-to-be-deprecated versions (Excel 2.6, 3.0 and PowerPoint 1.4) before 31 May.
As already announced last month, we would like to highlight:
End of Windows 7 support for Excel and PowerPoint add-ins. On January 14, 2020 Microsoft stopped updating or providing support for Windows 7. We are following this move by stopping the support of Windows 7 for our add-ins. This decision enables us to dedicate all our time and effort to improving the add-ins for users of more recent Windows versions. As a result, users of Windows 7 will still be able to use previous and new versions of the add-ins and there is no action to take for them. The consequences are that bugs associated to Windows 7 might not be resolved. The mitigation for users would be to consult with their IT organization to move on from Windows 7. Find out about the system requirements for the current version of Excel add-in and PowerPoint add-in.
Sunset of Excel add-in 2.6, 3.0 and PowerPoint add-in 1.4. The deprecation deadline has been extended to 31 May, 2020 to give you more time to upgrade to the new versions. Please check our previous what’s new blog post for more information.
Upgrade notification: If you are on Excel add-in 3.2 or 3.3 or PowerPoint add-in 1.5, you will be alerted of the availability of the new version via an upgrade notification when you open Excel. If you choose to upgrade, it will uninstall the prior version and install Excel add-in 3.4 or PowerPoint add-in 1.6 respectively. Please check your company policy before attempting to upgrade. Files refreshed in a new version are not compatible with prior versions anymore so we recommend taking a copy of the files first.
Your current version: See this Anapedia article to understand how to check your current office add-in version.
Proxy support. You asked for proxy support in this request in the Idea Exchange. If your company uses a proxy server, you can now set up the settings in the add-in.
Multi-sheet connection. Create a report composed of multiple worksheets from a single connection. You will be able to save time if you were using the cloning functionality to do this manually.
Fix to known issues:
Excel crashing. Workbooks open in multiple versions of the Excel add-in will no loger crash Excel. We, however, recommend that you refresh the workbooks are refreshed on the same version of the add-in, as we do not support compatibility with previous versions.
Missing read-write connection drop-down. You will be able to seamlessly upgrade to the next version with the upgrade notification. The notification, received by all users of the add-in, has been improved so you can silence it for a given amount of time. If you do not want your end-users to upgrade, we recommend you communicate this to them so they do not upgrade through the notification.
Saved view over 1 million cells. You can now create a new connection to a saved view where the total cell count is over 1 million. Please note you still have to account for the usual considerations.
Cell shift in v3.0 to v3.1 migration. You will be able to seamlessly migrate from v3.0 to v3.1 and above.
Proxy support.You asked for proxy support in this request in the Idea Exchange. If your company uses a proxy server, you can now set up the settings in the add-in.
Conserved line item formatting. Format your data in Anaplan (with %, $ or another format) and it will be displayed in PowerPoint in the same format to create great presentations.
In early April 2020, an updated landing page will unite all of your Anaplan content, models and New UX apps into one, quick and easy home page. You’ll notice that the look and feel of the landing page is different but all the same capabilities are there, and more. To learn more about the "Home" page and how it enables a seamless journey for a user across all of their Anaplan content, see this blog post.
In April, SSO users who click on an Anaplan link will be able to login and land on the destination URL, instead of landing on home landing page. This will work for both Classic and New UX links. This will also mean SSO users will be able to login on the Anaplan login page.
March 14th, 1:00-5:00 pm PT
March 28th, 1:00-5:00 pm PT