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
 All Forums
 Origin Forum for Programming
 LabTalk Forum
 Grey workbook cells

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
ds755 Posted - 12/30/2019 : 7:47:28 PM
Origin Ver. and Service Release (Select Help-->About Origin): Origin 2019
Operating System: Windows 8.1

Hello,

I have noticed that some workbook cells are grey, and the assignment commands in LabTalk behave strangely.

In the image below, the grey cell cannot be edited with "col(J)[1]=30;", but "cell(1,10)=30;" works.

Could you please help me understand why this happens?

Thank you

5   L A T E S T    R E P L I E S    (Newest First)
ds755 Posted - 01/07/2020 : 5:16:45 PM
quote:
Originally posted by Chris D

Hi,

I have your OPJU. Can you provide a series of col()[] examples and what you expect to be the output?



Thanks,
Chris Drozdowski
Originlab Technical Support





Hi Chris,

For example you can type: col(J)[1]=30; in the command line and see what happens. If you do "Set As Begin", as Yuki mentioned, the values assigned by my script will appear on the unused cells. Of course, the question is why is my script unable to assign values to unused cells.
adamgreengr Posted - 01/05/2020 : 08:00:59 AM
I also need series of col()[] examples and what you expect to be the output?


<a href="https://www.packntrade.co.uk/">CakeBox</a>
Chris D Posted - 01/02/2020 : 08:26:23 AM
Hi,

I have your OPJU. Can you provide a series of col()[] examples and what you expect to be the output?



Thanks,
Chris Drozdowski
Originlab Technical Support
ds755 Posted - 12/31/2019 : 10:16:10 AM
Hi Yuki,

I am reading the webpage below and beginning to understand.

https://www.additive-net.de/en/software/support/minitab-support/minitab-faq-graphiken/584-software/originlab/origin/v2019/6151-origin-2019-improved-handling-of-empty-cells

The "Set As Begin" works and the values appear normally. So, why are these cells registered as "unused cells" by my script, as opposed to "missing value cells"? This is something I need to figure out. And why does the col(J)[1] command fail when used on unused cells?

I uploaded the bug in a project file, so that the company can study it.

https://www.dropbox.com/s/e5htezql3g1tx3d/bug.opju?dl=0
yuki_wu Posted - 12/30/2019 : 10:21:31 PM
Hi,
You might set the second row of Column J as begin by accident, so you can select the grey cell( or the whole first row) then right click to select Set as Begin. You are allowed to set the cell value via “col(J)[1]=30;” now.

You mentioned "col(J)[1]=30;" and "cell(1,10)=30;" results in inconsistent results. I think this is a bug and I have reported it to our developer (ID: ORG-21311).

Regards, Yuki
OriginLab

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000