I have an Excel spreadsheet that I use in conjunction with a MindManager 2016 mind map. In the map, I have topics with custom properties. I'd like to read the values stored within the topics' custom properties and use those values in calculations in the associated Excel spreadsheet.
Is that possible?
While this is possible with MAP if you want to pull an Excel cell value into a Custom Property it is not currently possible to take an Extended Property created by MAP and feed that into Excel.
I'm looking at this for Ashok at the moment and I hope that we will be able to provide this functionality soon.
MAP 2.0 is now available - New user interface and 38 additional functions help you become a MindManager Power User FAST! Now with extended license plans for Enterprise and Education - Learn more at www.mapformindmanager.com
Apologies - Ashok didn't clarify in his original post that he was talking about Extended Properties. I thought by "custom properties" in the context of Excel he meant the Excel properties that you can create using MAP. These certainly can be synced in both directions between MM and Excel, which is a great feature.
There is one small issue at the Excel end, however. If you do edit the Excel topic property at the MM end and sync it to Excel, the modified file appears in the Excel Document Recovery pane. This isn't fatal but it is a bit distracting.
Nigel, while we are on this subject, do you know if it is possible to access the properties of a Google search map part to do the same thing? I'd love to be able to sync the "Look for" field with an Excel cell. This would also make it easier to add Google search parameters such as daterange to a search in MM (I've set up a calculator in Excel to convert dates to the daterange format; Google somewhat perversely only takes numeric values based on Julian calendar dates).