Displaying Spreadsheet ranges on a MindManager map

[ajwilcox]

There are two choices in MindManager:

1. Use MindManager's simple built in spreadsheeting facility.  This will also display the data as charts.

2. Link to a range in an Excel spreadsheet.

You could have many topics on a MindManager map with data from one or several spreadsheets.  For instance one topic could have Sales another Costs and another Profit.  As data changes in one range say Sales, the results can be seen Costs (assuming there are variable ones) and Profits.  The map has to be refreshed to see these changes.  Just press F5.   

[ajwilcox]

I was having some difficulty displaying a wide MindManager spreadsheet.  Mindjet support provided the resolution to this problem.

Select the topic
Right Click the spreadsheet
Select Spreadsheet (at the top of the drop down)
Spreadsheet Properties
and adjust the size.

You can also enable sorting, control the display of column and row headings, and color alternate rows from this property page.

Yet to solve the problem that row summations stop at column Z.  That is sum(b2:z2) works but sum(b2:az2) does not include cells aa2 to az2.

Have you had that problem?

[ajwilcox]

Mindjet have acknowledged there is a problem with wide spreadsheets.  Its on there Fix It list.

Have you been able to hide the row (1, 2, 3, etc.) and column headers (A, B, C etc.) in the Excel Range view?