How to copy a formula to a range of cells using built-in spreadsheet?

  • 2
  • Idea
  • Updated 3 years ago

I'd like to use the simple built-in spreadsheet feature in MindManager 2016 when only simple calculations are needed (rather than attaching or linking to an Excel spreadsheet).  However, there is one feature that I've not been able to figure out based on experimentation and available documentation.

I'll explain what I need by describing what is easily available in Microsoft Excel.  When creating a formula in a cell, I often need to copy that formula to a range of rows or columns.  Excel will automatically adjust the formula for each row or column where the formula is copied.  I have not figured out how to replicate this feature in the built-in MindManager spreadsheet.

Can this be done using the built-in MindManager spreadsheet?  I should hope so, because it's a very basic spreadsheet feature.

Photo of Ashok Kumar

Ashok Kumar

  • 18 Posts
  • 1 Reply Like

Posted 3 years ago

  • 2
Photo of Shilpa Kabra

Shilpa Kabra, Official Rep

  • 125 Posts
  • 31 Reply Likes
Hi Ashok,

Currently there is no settings to copy the formula to other rows or column inside built in Spreadsheet feature in MindManager.
I am going to change this thread from a Question to an Idea,for future consideration to add this as a feature in MindManager.

Only options available with formula is shown in the screen shot below:



Thanks,
Shilpa
Photo of Ashok Kumar

Ashok Kumar

  • 18 Posts
  • 1 Reply Like
Thanks for the reply, Shilpa.  It's not what I was hoping to hear, but perhaps I might see this feature in a future version.