-
Bug
-
Resolution: Fixed
-
Low
-
7.19.23, 8.5.11, 8.9.3
-
6
-
Severity 3 - Minor
-
10
-
Issue Summary
If an .xls file is added to the Office Excel macro and the Worksheet Name macro parameter is specified, the macro does not display the expected content and instead displays an error message:
We can't preview this file. You'll have to download the file to view it.
This is reproducible on Data Center: (yes) / (no): Yes
Steps to Reproduce
- Create a page, attach an Excel file (.xls), and then save the page.
- Edit the page and insert Office Excel Macro.
- While inserting the file, enter the Worksheet Name parameter based on the sheet name of the Excel file, as shown in the screenshot below:
- Click the save button and update the page.
Expected Results
The content of the designated sheet should be appropriately displayed on the Confluence page.
Actual Results
Once the page is saved, the macro displays an error message on the Confluence page, as shown below:
The logs will display the following error message:
2024-06-26 13:12:55,145 ERROR [http-nio-8090-exec-5 url: /confluence/rest/office/1.0/view; user: admin] [com.benryan.rest.ConverterMacroResource] getContent The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (eg HSSF instead of XSSF) -- referer: https://localhost:8090/confluence/display/TEST/new+xls+file+page | url: /confluence/rest/office/1.0/view | traceId: 75fa95e96ee302a8 | userName: admin
Workaround
Note: The issue can't be reproduced in 7.19.20.
As a workaround, we can perform either one of the following steps:
- Edit the Excel macro on the page to remove the value of the Worksheet Name parameter.
- Convert the file extension from .xls to .xlsx and re-upload the file to the page.
- is duplicated by
-
-
- Closed
-
-
-
- Gathering Impact
-
- is related to
-
-
- Closed
-
- mentioned in
-
![[Extranet] Page](/images/icons/generic_link_16.png "[Extranet] Page")
Page
Failed to load
[CONFSERVER-96032] Can't preview .xls file on "Office Excel" macro if the Worksheet Name parameter is specified
Hi 0bce4ade8c4f and npn@netic.dk,
On the back of your feedback we went and tested our fix again. We're unable to replicate the issue you're seeing, so we suspect there's some other issue that looks like this, or some edge situation we're not aware of.
Can you please reach out to Support and link them this message and provide an example document along with reproduction steps (please don't put it here as this is a public forum anyone can access). We'll look into it from there.
For now I'll leave this one as fixed until we can assess the cause of the issue.
Thanks,
James Ponting
Engineering Manager - Confluence Data Center
f9221957a5e4 - I Agree, my disapointed employees report the same....
The problem still occurs in Confluence 8.5.14. It does not seem to be solved yet and the ticket should be reopened.
A fix for this issue is available in Confluence Server and Data Center 8.5.14
Upgrade now or check out the Release Notes to see what other issues are resolved.
A fix for this issue is available in Confluence Server and Data Center 7.19.26.
Upgrade now or check out the Release Notes to see what other issues are resolved.
Hello Atlassian, can you please raise the priority of this issue?
Hundreds of pages became dysfunctional due to the bug and the described workaround unfortunately does not work for us because the Worksheets are needed and it is not realistic to completely redesign all these Excel sheets.
Thank you very much.
Please note that the workaround is not sufficient.
There are multiple sheets in our workbooks and we are trying to display different sheets from that workbook in a single confluence page.
If we are unable to specify the sheet by name, only the last viewed sheet is shown.
Hi jponting
Kan drop mov files here - but my "users" send me it. Fetch it at https://www.mos-eisley.dk/download/attachments/4161541/Screen%20Recording%202024-09-30%20at%2012.10.21.mov?api=v2 (my personal Confluence)
I can add that:
Close Confluence
Do:
cd /pack/confluence-data
rm -rf /pack/confluence-data/bundled-plugins
rm -rf /pack/confluence-data/plugin-cache/
rm -rf /pack/confluence-data/plugins-osgi-cache/
rm -rf /pack/confluence-data/plugins-temp/
rm -rf /pack/confluence-data/bundled-plugins_language/
Start Confluence
Solves the issue.... every time