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
 Origin Forum
 Column Label Rows: setting and treating as text

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
AKazak Posted - 06/02/2020 : 11:59:59 AM
OriginPro 2020b (64-bit) 9.7.5.184
Windows 7 Pro x64 SP1

Greetings!

If I put value "01" in a custom (user) Column Label Row is automatically treated by Origin as a number, but not as a text.
How do I set it to be a text, instead of a number?

Thank you.


---
AK
4   L A T E S T    R E P L I E S    (Newest First)
Castiel Posted - 06/05/2020 : 06:37:06 AM
quote:
Originally posted by AKazak

quote:
Originally posted by YimingChen

Hi,

Can you first change column format to Text?

James


It works if I change the column's format to Text.
However, if I revert to format setting back to Text & Numeric, I get the same as on the screenshot above.


---
AK


If the rows range is fixed, you can leave the F(x) empty and set column values in "Before Formula Scripts":

for(int i = 1; i <= 9; i++)
{
    Cell(i, j)$ = wcol(j)[Test]$;
}




                                          &&&&&&&&&
                                        &&&
                                       &&
                                      &  _____ ___________
                                     II__|[] | |   I I   |
                                    |        |_|_  I I  _|
                                   < OO----OOO   OO---OO
**********************************************************
AKazak Posted - 06/03/2020 : 07:02:30 AM
quote:
Originally posted by YimingChen

Hi,

Can you first change column format to Text?

James


It works if I change the column's format to Text.
However, if I revert to format setting back to Text & Numeric, I get the same as on the screenshot above.


---
AK
YimingChen Posted - 06/02/2020 : 4:07:31 PM
Hi,

Can you first change column format to Text?

James
AKazak Posted - 06/02/2020 : 12:23:03 PM
In other words: how do I force text in a Column Label Row cell.
My test shows that Origin treats any numeric-like value as a number:



---
AK

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