Problem

In Confluence, if a Excel file is rendered using the Office Excel macro, if a specific worksheet name is provided under the worksheet option, the macro throws "We can't preview this file" error. While if there is no selection provided, the macro displays whatever worksheet was open when the excel file was saved in Office.

Environment

.
Tested on Confluence 8.5.x

Steps to Reproduce

1. Create an excel file in Microsoft Office with multiple worksheets (atleast 3)
2. Save the file as office 1997 to 2003 xlsx file to ensure compatibility (Ensure the 3rd worksheet was on screen when file was saved).
3. Attach this file to a Confluence page and add an Office Excel macro. Do not provide any value to worksheet and save the page.
4. Edit the page and edit excel macro and provide a worksheet name under the "worksheet" option. Save the page.

Expected Results

1. For Step 3, the first worksheet of the excel file should be displayed as this is default.
2. For Step 4, which ever worksheet name was provided under "worksheet" should be displayed.

Actual Results

1. For Step 3, the worksheet which was on screen when the excel file was saved in office is displayed.
2. For Step 4, we are faced with "We can't preview this file" error.

Workaround

If you would like to display a specific worksheet, save the xlsx file in office excel with the intended worksheet in view mode.

Notes