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

[Charles Land]

I just tried this out of curiosity and it didn't work....  I found I had to have a value there prior to trying this operation (just a zero worked fine) and I had to click on the box and then hit the down arrow and then up to make the box have a black outline. And then the values would past in using Ctrl+Alt+V.  Otherwise the values were not showing up as red text and would delete as soon as I entered my next value.  Also steps three and four just made it go away.  Are you using windows 7?  Im on XP.  This may be the difference.

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

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/76b1de1b/attachment.htm>