Please fix this bug. We use Jira-Server

Ten years old! TEN YEARS! What's even the point of having these bug tickets if they're never going to be addressed? 

Can't state how much time I wasted trying to get this to work before searching the web. Didn't know if it was a timing or indexing issue or what. The work around is a PITA since we update our spreadsheets frequently but we're glad to have found the work around. Clearly since this ticket is still open, it is still broke. We're running 7.19.5. Not holding my breath for a fix if this was really Created: 25/Nov/2013 6:49 AM.

Found workaround of HD Nguyen, works in 7.13.1 (didn't test row=1/col=1):
The Excel macro is not honoring row and column limits

Still an issue for us. Annoying. 

It's still the same in version 7.9.1. I think they would have no plan to fix non-serious issues. They might focus more on cloud version... That's sad...

Issue affects Confluence still in version 7.3.4. Does anybody know if it is fixed or not happening anymore in a newer version for Confluence Server?

Bug persists.  Recreating entire confluence page helps to reflect your changes but not a good workaround.  Cannot edit last row/last col after initially adding the macro to page.

Hello Nick, thank you for your hint. I'll try to create again the Confluence page. That's better than nothing.

I have sometimes found that recreating the confluence page can solve the bug ...but only temporarily ... the bug returns after further updates to the excel file

Hello, same situation here. I really need to be able to select the rows and columns needed.

What's the current status? Is there any chance to solve this issue soon?

Seven years?! Are you guys kidding me? 

This issue is very annoying - is there an expected date to resolve it?

I also have this problem .. the behaviour is inconsistent and unpredicatable

Indeed, after 7 years this serious bug should be addressed.

Given the many comments above, I'm surprised it is still prioritized as low.

Could someone from Atlassian at least give us a target date for a fix?

So what's the story here? Why has this bug been out there for nearly 7 years?

adding my vote this very annoying

Also happening on Confluence Server 7.0.2

Very annoying

Cannot even add rows or columns now

Will this be fixed?

I would agree, this would be awesome to add into a page but frustrating it doesn't work. What would be ideal is if when you limited it, it would add a scroll bar to the side allowing someone on the page to find what they need. 

I see that this bug was marked "Won't Fix" in February 2015, presumably because the View Excel macro had been deprecated.

However in January 2019, the decision to deprecate the macro was reversed. See CONFSERVER-39829.

So I would ask that you please reconsider fixing this bug.

The bug is serious. It impedes use of the View Excel macro, and (as you have now recognized) this macro is essential for many users.

Office Excel macro Column and Row values are ignored in 6.12.2.

If same issue it's not working in 6.12.2.

Users concerned about this critical bug in the View Excel macro may be interested in what I learned from Atlassian support recently. First they said the problem may have been "improved" by recent changes. However after questioning, they determined that the problem does remain in the latest release, Confluence Server 6.10. When asked about a roadmap for fixing it, they said: "There isn't a roadmap/ETA decided for the bug report or a plan to fix it in the next 12 months".

Does anyone have any ideas for a workaround? Are there any 3rd party add-ons that can help? Or failing that, does anyone know of alternatives to Confluence that support this functionality?

I am confused WHY this is no longer supported. I saw some documentation on a preview macro, but how does that replace the function of displaying certain data from a specific sheet in excel? I can display a sheet but it displays a large number of rows, which makes it basically impossible for me to display more than one sheet on a page. If there was a way to put that macro inside another confluence macro that put a frame around it with a vertical scroll bar I might be ok, but I can't find such a macro. There may be ways to have a horizontal scroll bar but not vertical.

So : why isn't this being fixed?
What upcoming feature purports to replace the functionality?
Is there a workaround for the large-number-of-displayed-rows problem with another macro or confluence wizardry?

BTW I am on cloud....

Hi jsn

The Office Excel Macro has been deprecated as of Confluence 5.9 and hence the Confluence Team will not be looking into fixing this issue.
https://confluence.atlassian.com/display/DOC/Confluence+5.9+Upgrade+Notes#Confluence5.9UpgradeNotes-Discontinuedordeprecatedfeatures

Sorry for the inconvenience

Hi Natasha.

I'm seeing this problem on Confluence 5.8.10. The Office Excel macro simply ignores the Last Row argument when rendering the Excel spreadsheet to the page. Any official fix for this in the works?

Best regards
Jacob Saaby Nielsen

Thanks for the feedback here.

As part of Confluence 5.7, we've released a new file previewer; clicking a file that's been inserted into a page will load it in the new previewer. You can still access the old viewfile macros by going to the "+" menu and choosing "Other Macros" or by typing {excel}.

Any further improvements to do with embedding and previewing files will be made on top of the new previewer, rather than the old view file macro that this issue pertains to.

Regards,
Natasha Prasad
Confluence Product Manager

and another word of caution (this is for Confluence to fix ASAP as it is a security risk):

If you group a few rows or columns in Excel, and then password protect the file, you will be unable to see these rows/columns again unless you know the password.

However once you post the locked file in Confluence (i.e. using the scenario above, just by dragging an Excel file from the desktop and dropping inside an editing Wiki page), Confluence will show the entire contents of the spreadsheet, including the rows/columns that are password protected!

Says a lot about Microsoft really, and how dedicated they are to security

Hi all,

I have found a solution without having to delete and recreate the page:

Use Firefox
Edit the wiki page with the embedded excel file
Edit the excel attachment
Set # of rows, columns as parameters (your number + 1 will be the number of columns/rows visible)
Save the wiki page
Click on "Edit Document" on the wiki page
Enable Editing (Excel)
Save (this is the most important part) and Close
Refresh the wiki page. You should be able to see only the rows/columns you've set in step 4.

We are using Confluence 5.5.6 but it may work for earlier versions as well. Pls let me know if this works for you.

voted. we are planning to use Confluence 5.4.4, too.

We have the same issue (ignores the changes to the lastrow/lastcolumn values) on 5.4.4. As noted above, the fix is to delete and recreate the page with the same info and Spreadsheet, but with the last row/column info different. This is a major issue, limiting how we can use Confluence, and if not resolved we will need to find other solutions for this.

I have the same problem with version 5.1.4.

Have to delete the attachment, rename it, and upload it with the new name. Then create the macro on the first try.

same issue. confluence 5.5.2

This is a major pain in the butt for us. We use an Excel spreadsheet to plan leave (we are a small company and Team Calendars would be too heavy for us).

Every time we would like to add a week or two of planning, we want to change how much of the Excel file is rendered... But can't. Not without removing the macro and the attachment, re-uploading the attachment under a different name, and re-adding the macro. So much manual work...

Using 5.3.1

I've noticed that this is especially noticeable (or perhaps a separate related bug) if you try and display the same Excel sheet more than once on a page. The 1st configuration is repeated each time throughout the page. E.g. If I set the first instance to display the 1st row (set to 0) then all subsequent attempts to display the Excel sheet on that page will only show the first row, regardless of how the macro is configured.

Essentially I'm seeing the behaviour as described by Peter Kramp above.

As this is the best way Confluence allows users to display complex table based information, I'm surprised it's listed as a minor issue. This will be very debilitating for many customers who reply on displaying Excel info on their Confluence pages.

We work with Confluence 5.4.1 and the OfficeConnector 3.1.4 or (3.1.4.1)

You have only one shot: Attach the Excel Sheet to the page, configure the ExcelMacro (rows, colums, sheet) and save the page. That works fine. But ...

... you can't edit the columns, even when you delete the macro on the page. No way. You must delete the attachment, rename it and attach it again with a different name.

Actually it ignores the changes to the lastrow/lastcolumn values.

If you create a new page, attach a new excel, insert the macro and add values to lastrow/lastcolumn while inserting the macro, it will show the correct rows, columns. If you want to change the values after that, nothing will happen, it will display the initial rows/columns.

Confluence 5.1.5 is affected as well.

I have a similar issue. I create a 3 x 2 table and it leaves off the third row. I am currently on 5.2.3.