The Origin Forum

File Exchange

Try Origin for Free

The Origin Forum

All Forums

Origin Forum for Programming

LabTalk Forum

wks.col.setformat uses wrong subformat index

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:

Message:

* HTML is OFF
* Forum Code is ON

Smilies

[quote][i]Originally posted by AKazak[/i]
[br]OriginPro 2021 (64-bit) Beta 4 9.8.0.138
Windows 7 Pro x64 SP1

Greetings!

I want to set custom date format for a worksheet column and try to understand an example from https://www.originlab.com/doc/LabTalk/ref/Wks-Col-obj#Set_Custom_Date_FormatCustom_Date_FormatDate_Format.2C_Customization:
[code]
// Surround non-date characters in specifier by single quotes:
wks.col2.SetFormat(4, 22, yyyy'.'MM'.'dd);
[/code]

Here subformat is set to 22, but the same page above tells:
[quote]Subformat options as listed in the Display drop-down list of the Worksheet Column Format dialog box (in the Origin GUI, select Format pull-down menu, then select Column ... option to open this dialog). To get the appropriate number of the option you want, simply count down from the top of the list of Display options. Make sure the desired Format has been selected first.[/quote]

Here is my Display drop-down list:
[img]https://my.originlab.com/ftp/forum_and_kbase/Images/2020-09-02_21h21_49.png[/img]

The Custom Display option has a serial number (from top to bottom) of [b]24[/b], but not [b]22[/b].

Does the online help stay behind the Origin development or here is some different logic?

---
Andrey
[/quote]

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
AKazak	Posted - 09/02/2020 : 2:24:25 PM OriginPro 2021 (64-bit) Beta 4 9.8.0.138 Windows 7 Pro x64 SP1 Greetings! I want to set custom date format for a worksheet column and try to understand an example from https://www.originlab.com/doc/LabTalk/ref/Wks-Col-obj#Set_Custom_Date_FormatCustom_Date_FormatDate_Format.2C_Customization: // Surround non-date characters in specifier by single quotes: wks.col2.SetFormat(4, 22, yyyy'.'MM'.'dd); Here subformat is set to 22, but the same page above tells: quote: Subformat options as listed in the Display drop-down list of the Worksheet Column Format dialog box (in the Origin GUI, select Format pull-down menu, then select Column ... option to open this dialog). To get the appropriate number of the option you want, simply count down from the top of the list of Display options. Make sure the desired Format has been selected first. Here is my Display drop-down list: The Custom Display option has a serial number (from top to bottom) of 24, but not 22. Does the online help stay behind the Origin development or here is some different logic? --- Andrey
3 L A T E S T R E P L I E S (Newest First)
minimax	Posted - 09/22/2020 : 04:19:47 AM Hi AKazak, index for 9-2-2020 (Global Custom1) is 20; index for 09:21:37.0000 (Global Custom2) is 21; index for Custom is 22; index for 2020-W36 is 23 (new in Origin 2021); index for 2020-W36-2 is 24 (new in Origin 2021); Those 2 is another kind of "custom" format. To modify those 2 format, go to Tools - Options - Miscellaneous Tab - Custom Dates Formats Group, the 2 editboxes.
AKazak	Posted - 09/03/2020 : 01:34:11 AM quote: Originally posted by cpyang Custom is special, so some later implementation inserted some additional entries but Custom=22 must stay the same due to people's existing codes. CP So 22 corresponds to Custom Display. How do I then pick 22nd and 23rd list items from the top, that are "9-2-2020 (Global Custom1)" and "09:21:37.0000 (Global Custom2)"? --- Andrey
cpyang	Posted - 09/02/2020 : 4:15:58 PM Custom is special, so some later implementation inserted some additional entries but Custom=22 must stay the same due to people's existing codes. CP

The Origin Forum

Snitz Forums 2000