Excel export and priorities

  • 1
  • Question
  • Updated 7 years ago
  • Answered
A client was pleased to be able to export to Excel from Mindjet but was frustrated by a topic priority not appearing in the spreadsheet.

The topics without sub-topics transferred the priority level to a cell in their row of the spreadsheet.

A topic with a priority marker and sub-topics did not do this. We hid or deleted the sub topic, repeated the export and it worked.

I struggled to explain this behaviour at the time but the explanation came to me later. My explanation is this:

Like the MS Project export, a topic with sub-topics is a summary task with tasks. The values of the summary task are generated from those in the tasks e.g. Total duration. You can't fix the priority of the summary task, it is the "average" of its task's priorities.

The Excel export works in a similar manner. Am I correct in my explanation?
Photo of Andrew Wilcox

Andrew Wilcox, Champion

  • 1041 Posts
  • 184 Reply Likes

Posted 7 years ago

  • 1
Photo of Michael Deutch

Michael Deutch

  • 438 Posts
  • 77 Reply Likes
Hi Andrew. I'm afraid your answer is incorrect.

There are three types of spreadsheet exports:
1) Pivot
2) Table
3) Outline.

For the Pivot and Table exports, the rows are compressed. The diagrams in the Export to Spreadsheet Settings dialog illustrates this as you select the different radio button options. The priority presented is associated with the last descendant from the parent topic in the row. (Hope this makes sense).

The only view that has a row for each and every topic is the Outline export. If you select that option, each topic including the 'parent' topics will have its associated priority in the output.

Give each variation a shot and let me know if that answers your question.