Spreadsheet edit

6 posts / 0 new
Last post

I would like to know what the easiest way to change an entire column in DDedit Spreadsheet, instead of going into each zone and editing a single parameter at a time

Erik Weiss's picture
Offline
Joined: 2011-09-30
Reputation: 0

In my way:

Option 1, using "user define" function

Option 2, editing the inp file in a text editor, "find" and "replace"

grammy's picture
Offline
Joined: 2010-12-09
Reputation: 0

Option 1:

right click on the cell you want to change, and select the "Edit/View user
default...", then you can input the value in "user-defined default value:"
or "user-defined default expression:"

Option 2:

I hope you can do it by yourself...

grammy's picture
Offline
Joined: 2010-12-09
Reputation: 0

Sometimes you can right click on the top entry and use the Set Default to
change an entire column. I say sometimes because sometimes it works for me
and sometimes it doesn't. I have not had the time/opportunity to figure out
why. Other then that Ctrl C and Ctrl V work pretty good when you are in the
spreadsheet mode.

Carol

cmg750's picture
Offline
Joined: 2010-10-05
Reputation: 0

You may want to consider using excel, but there's one small trick. I
recently answered this question with images on a forum:

http://energy-models.com/forum/energy-modeling-software/equest/equest-and-excel#comment-205

Bob F's picture
Offline
eQUEST UserLEED EA Credit 1 TrainingTRACE 700 User
Joined: 2010-06-30
Reputation: 18

That's pretty cool, Bob. I didn't catch that the first time so thanks for
sharing again!

Carol

cmg750's picture
Offline
Joined: 2010-10-05
Reputation: 0