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.

2 Antworten auf „Confluence Excel Macro: Last Row and Column is Not Working“

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.

Schreibe einen Kommentar

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

Diese Website verwendet Akismet, um Spam zu reduzieren. Erfahre mehr darüber, wie deine Kommentardaten verarbeitet werden.