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.

Dieser Beitrag wurde unter Allgemein abgelegt und mit , , , , , verschlagwortet. Setze ein Lesezeichen auf den Permalink.

2 Kommentare zu Confluence Excel Macro: Last Row and Column is Not Working

  1. Marcin Kozłowski sagt:

    Many thanks for this life-saving workaround! Can’t undesratnd why it’s not published by Atlassian along with their laconic „won’t fix – deprecated“ message.

  2. Ron Ben Yosef sagt:

    Thank you!

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert.