[Equest-users] Copy/Paste in eQUEST Spreadsheet Mode

[Rohner, Curt]

You can't copy and paste every cell.  Some are locked and prevent that function.

But don't despair.

Simply

Ctrl+C the desired material to copy over from excel while in excel.

Ctrl+Alt+V the material into the desired cells in the spreadsheet mode in eQuest.

Now here is the trick. Immediately

Ctrl+C again the material in the spreadsheet in eQuest

Without moving or doing anything else

Ctrl+V

And there you go.  I know it sounds ridiculous but it does work.

Remember

Ctrl+Alt+V
Ctrl+C
Ctrl+V

Don't do too much in too large a model.  It can take some time for eQuest to change all the values in the inp and can look like the program is stalled while it is in fact working but can (and has for me) taken a couple of hours to finish all the changes.

CURT ROHNER, LEED AP BD+C, EIT
Energy Services

Cannon Design

crohner at cannondesign.com<mailto:aborgese at cannondesign.com>

From: equest-users-bounces at lists.onebuilding.org [mailto:equest-users-bounces at lists.onebuilding.org] On Behalf Of Pasha Korber-Gonzalez
Sent: Friday, September 23, 2011 4:02 AM
To: Robby Oylear
Cc: equest-users at lists.onebuilding.org
Subject: Re: [Equest-users] Copy/Paste in eQUEST Spreadsheet Mode

HI Robby-

eQuest looks like a spreadsheet but doesn't act like one.  Don't mistake it for a spreadsheet.   You can copy/paste but you can only do it one cell at a time.

Cheers,
Pasha
On Thu, Sep 22, 2011 at 3:48 PM, Robby Oylear <robbyoylear at gmail.com<mailto:robbyoylear at gmail.com>> wrote:
Has anyone had any success with using the method below for copy/paste into eQUEST spreadsheet mode?  Once I've pasted the values into eQUEST it appears as if it's worked, but as soon as you allow the spreadsheet to update (by entering a value in any cell for example), all of the pasted values disappear and the old values are still present.

http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/2010-November/006688.html

Thanks,
-Robby

_______________________________________________
Equest-users mailing list
http://lists.onebuilding.org/listinfo.cgi/equest-users-onebuilding.org
To unsubscribe from this mailing list send  a blank message to EQUEST-USERS-UNSUBSCRIBE at ONEBUILDING.ORG<mailto:EQUEST-USERS-UNSUBSCRIBE at ONEBUILDING.ORG>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110923/5ca53ed8/attachment.htm>