[Equest-users] Copy and paste in spreadsheet

[Fred Betz]

I’ve seen this too in eQUEST 3.64.

There are some groups of values you can copy and paste several at a time, there are some that you can copy and paste one cell at a time, and then there are some that won’t let you copy and paste at all.

The last item seems somewhat random as I’ll have 100+ zones in a model and a handful of spaces or zones won’t let me copy and paste in the spreadsheet view in some models. I have to edit those values by opening the space or zone dialog box, and enter the value there rather than from the spreadsheet view. A few other modelers in my office have had this problem arise randomly as well.

If anyone has a resolution to this item, it’s a random nuisance that I’d appreciate if it were resolved.

Fred


Fred Betz  PhD., LEED AP ®BD&C
Senior Sustainable
Systems Analyst



AEI | AFFILIATED ENGINEERS, INC.
5802 Research Park Blvd. | Madison, WI  53719

P: 608.236.1175 | F: 608.238.2614
fbetz at aeieng.com<mailto:fbetz at aeieng.com>  |  www.aeieng.com<http://www.aeieng.com/>



From: Robby Oylear [mailto:robbyoylear at gmail.com]
Sent: Monday, June 16, 2014 10:57 AM
To: Matthew Baron
Cc: equest-users at lists.onebuilding.org
Subject: Re: [Equest-users] Copy and paste in spreadsheet

Still not clear at what step the process is failing for you.  Copying from a default set of values to an overridden set of values should work.

On Mon, Jun 16, 2014 at 8:31 AM, Matthew Baron <mbaron at wendelcompanies.com<mailto:mbaron at wendelcompanies.com>> wrote:
I was copying the default value to an overridden (red) value, it worked individually just not in groups.

Thanks,
Matthew J. Baron, PE
[wendel EM]

Wendel, 140 John James Audubon Pkwy, Suite 201, Buffalo, NY 14228
p 716.688.0766<tel:716.688.0766>   f 716.625.6825<tel:716.625.6825>   e mbaron at wendelcompanies. com   w wendelcompanies. com

ARCHITECTURE    ENGINEERING    PLANNING    ENERGY SERVICES    CONSTRUCTION MANAGEMENT

CONFIDENTIALITY NOTICE: This email transmission is confidential and is intended only for the person(s) named above. Its contents may also be protected by privilege, and all rights to privilege are expressly claimed and not waived.  If you have received this email in error, please call us immediately and destroy the entire email. If this email is not intended for you, any reading, distribution, copying or disclosure of this email is strictly prohibited.

Please consider the environment before printing this email.

From: Robby Oylear [mailto:robbyoylear at gmail.com<mailto:robbyoylear at gmail.com>]
Sent: Monday, June 16, 2014 11:12 AM
To: Matthew Baron
Cc: equest-users at lists.onebuilding.org<mailto:equest-users at lists.onebuilding.org>
Subject: Re: [Equest-users] Copy and paste in spreadsheet

Make sure the values you're trying to paste over are in red text.  You cannot use that sequence of commands to paste over default values (green, blue).  I haven't installed 3.65 due to the issues people have been having with it, but it's likely operator error over an issue with 3.65.

I actually use cntrl + shift + v to paste into eQUEST, then select the pasted data, copy it, and paste it again with standard cntrl + v command.

Can you describe what's not working for you? Are the values being pasted into eQUEST but they just aren't sticking?

-Robby



On Mon, Jun 16, 2014 at 7:51 AM, Matthew Baron <mbaron at wendelcompanies.com<mailto:mbaron at wendelcompanies.com>> wrote:
Hi All,
Looking through the archives on this issue and found this http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/2011-September/033704.html

Obviously these directions are not working for me… anyone know if this is possible in 3.65?

Thanks,
Matthew J. Baron, PE
[wendel EM]

Wendel, 140 John James Audubon Pkwy, Suite 201, Buffalo, NY 14228
p 716.688.0766<tel:716.688.0766>   f 716.625.6825<tel:716.625.6825>   e mbaron at wendelcompanies. com   w wendelcompanies. com

ARCHITECTURE    ENGINEERING    PLANNING    ENERGY SERVICES    CONSTRUCTION MANAGEMENT

CONFIDENTIALITY NOTICE: This email transmission is confidential and is intended only for the person(s) named above. Its contents may also be protected by privilege, and all rights to privilege are expressly claimed and not waived.  If you have received this email in error, please call us immediately and destroy the entire email. If this email is not intended for you, any reading, distribution, copying or disclosure of this email is strictly prohibited.

Please consider the environment before printing this email.


_______________________________________________
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/20140616/9237342a/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3940 bytes
Desc: image001.png
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20140616/9237342a/attachment.png>