Kategorien
Allgemein

Confluence Excel Macro: Last Row and Column is Not Working

If you encounter the issue, that the „last row“ and „last column“ setting is not working in Confluence´s Excel macro, this is a pitty. As to find in the comments of the official bug report (including steps about how to reproduce) at Atlassian (https://jira.atlassian.com/browse/CONF-31741), they won´t fix this issue, because the Excel macro is deprecated.

Since I´m using the macro quite heavily, I´ve played a bit around and found the following workaround that might be also working for you:

  1. Add your Excel attachment
  2. Add the Excel macro
  3. Set last row/ column
  4. Save the page
  5. Edit the page
  6. Add a new version of your Excel attachment
  7. Save the page

Now the settings in „last row/ column“ are applied correctly.