| T O P I C R E V I E W |
| bmmaoso |
Posted - 09/15/2004 : 05:13:08 AM
Origin Version 6.0
Hi,
I have a column with hh:mm:ss dd/mm/yy (when I import the data the format is text and numeric) but I want to set this column with time format to do analysis. When I do it manually with format time and subformat hh:mm:ss origin set the seconds as 00.
with labtalk:
wks.col.format=3;
wks.col.subformat=3; (but it set the seconds to zero, too)
Thank you for your help
Maria Isabel
Edited by - bmmaoso on 09/15/2004 08:02:44 AM |
| 4 L A T E S T R E P L I E S (Newest First) |
| bmmaoso |
Posted - 09/20/2004 : 05:22:41 AM
Thank very much you Laurie, I solved my problem. |
| Laurie |
Posted - 09/17/2004 : 10:38:43 AM
Hi Maria,
The problem is that Origin doesn't know about the custom date format so when you set the column to date with "wks.col1.format=4;", Origin doesn't recognize this as a date so you get a missing value and then by the time you tell it what format to use with "wks.col1.subformat=21;" it is too late because it cannot convert a missing value now to this format.
So you will need to set this column format and save the worksheet template, you can then uncheck the "Automatic Determination of column types" checkbox in the ASCII Options dialog. The import won't change the format of the column on import and it should work ok.
OriginLab Technical Support |
| bmmaoso |
Posted - 09/17/2004 : 03:53:31 AM
Hi Laurie!
I change the custom and when I change the format it works, however when I want to graph the format is only (dd/mm/yy).
I try to do it with labtalk:
**wks.col1.format=4;
**wks.col1.subformat=21;
But it show the data as null values.
**work -e format; //I can select the format and subformat.
But again I obtain null values.
**work -f 1 4; //format date
but I obtain null values.
Do you know another way to change the column format with labtalk?
Thank you very much for your help
Maria Isabel
|
| Laurie |
Posted - 09/15/2004 : 1:52:56 PM
This format is not one of the built-in Display formats for Date & Time. Select Tools:Options to open the Options dialog. On the Miscellaneous tab, you can define your own Custom Date Formats. These will then appear in the list when you choose Date from the Worksheet Column Format.
When you plot the data, you can then choose to display the Tick Labels as just Time. You can do this from the Axis dialog, opened by double-clicking on the axis dialog.
OriginLab Technical Support |
