Removed the URL user and URL user password parameters

Owned by Nisha Shantilal
Last updated: Apr 14, 2022
3 min read

This page describes the parameters removed, changes, and how the app handles these changes in Excel for Confluence - Server and Cloud version.

Parameters removed

The URL user and URL user password parameters are removed from Excel for Confluence and are no longer available in the Excel macro.

Parameter removal is effective and available in:

  • Excel for Confluence - Server (version 7.3.0 and above)

  • Excel for Confluence - Cloud

Excel for Confluence app updates

The Excel for Confluence app now uses only Profile for the new macro configurations. You can use a Profile to access Excel data from a remote location without exposing any sensitive information.

  • Upgrade the app and use Profile to access the Excel data from external sources without exposing sensitive information such as a password.

  • The macro editor does not display the URL user and URL user password parameters.

  • Pre-configured macros using the URL user and URL user password parameters are supported. The Confluence page retains the values of the URL user and URL user password parameters in the Storage Format.

Follow the steps given below to create a Profile and configure the Excel macro using the Profile.

Create a Profile to access the external sources

Administrators create a Profile by defining a set of parameters, such as the base URL of the location for the Excel data, User, Password, and other relevant information to access the specified location. For more information, refer to Create a profile with a URL.

Use Profile to access the Excel data

To configure the Excel macro to use Profile:

  1. Select the Profile from the Profile drop-down.

  2. Enter the relative URL in the URL to Excel file parameter.

For more information, refer to:

How the change impacts the pre-configured macro?

The removal of parameters does not impact the existing macro configurations or pre-configured macros. Below are the various configuration changes to help you consider and plan the Excel macro configuration.

Retain the pre-configured Excel macro

  • Retain the pre-configured Excel macro with the URL user and URL user password parameters without any change.

  • Though the macro editor does not display the parameters, the Confluence page still retains the values of the URL user and URL user password parameters. The app fetches the parameter values from the Storage Format to retrieve the data from the remote location.

Modify the pre-configured Excel macro parameter values

Modify any of the parameter values such as Page for attachment, Name of attachment, Name of attachment in the path, Profile, or URL to Excel file in the pre-configured macro. The app considers the updated value of the parameters to fetch the data.

 

 

Copy the pre-configured Excel macro

The behavior of the newly copied macro remains the same as the original pre-configured macro.

You can:

  • copy the pre-configured macro on the same or another Confluence page.

  • copy the page containing the pre-configured Excel macro in the same space or another space.

References

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.