The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 wcellcolor		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

mwambach

6 Posts
Posted - 08/23/2016 :  6:48:44 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hi!

I would like to use wcellcolor to highlight certain rows in a worksheet. Somehow the use of variables in the code didn't work. Does anyone have a suggestion how to do this?

e.g.: 'wcellcolor [i+5] color(orange);'

Cheers!

AmandaLu

439 Posts
Posted - 08/23/2016 :  10:46:15 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi mwambach,

The input of wcellcolor X-Function is a range. So you will need to use the correct range notation. For example, if you want to color a range from 5th row in 1st column to 10th row in 2nd column, you can use script:

wcellcolor 1[5]:2[10] color(orange);

Please refer to this page for how to use range notation:

http://www.originlab.com/doc/LabTalk/Tutorials/Tutorial-Range-Notation


Thanks,
Amanda
OriginLab Technical Service
Edited by - AmandaLu on 08/23/2016 10:48:22 PM
Go to Top of Page

mwambach

6 Posts
Posted - 08/24/2016 :  12:25:46 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks, Amanda!
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000