| T O P I C R E V I E W |
| OndrejMM |
Posted - 01/20/2009 : 6:32:35 PM
Hi
This might be a bizarre question, but anyway,… lets say that I've just done a simple calculation using LabTalk “col(C)=col(A)+col(B)”, but of course in 4 weeks time I don’t remember what the kind of numbers are in the col(C)! If I do the same with the “Set Values” option I can always find what was done with the particular column, but I don’t know how to get this information if I used LabTalk,… does the origin remember which kind of operation was done on the particular column?
Cheers, Ondrej
|
| 5 L A T E S T R E P L I E S (Newest First) |
| couturier |
Posted - 01/22/2009 : 04:49:21 AM
quote:
imagine that col(A) was imported from file C:\example.txt
Such info (as many others) are available if you check "Show organizer" in workbook grey area. |
| OndrejMM |
Posted - 01/21/2009 : 8:02:15 PM
yeh, I think no one will try to split one formula like this: col(c)=(col(a)+col(b))^2-col(X), to more simpler, I just wanted to point out that more than one formula can be applied to one column, and then it might be confusing,... (I think)
imagine that I do something with the col(C) today, and in 6 months time I actually decide that I want to do some more calculations on the col(C), but I don’t think that I will want to rewrite all already applied operations + add new ones just because in another 6 months time I want to see the whole formula which has been applied to the col(C),…
maybe, if an additional operation is applied to the same column the information held in “formula$” should be updated, maybe as follows:
col(C) = col(A) +col(B);
> col(C).formula$= “col(A) +col(B)” //show formulas
col(C)=col(C)-col(X)
> col(C).formula$=”col(A)+col(B); col(C)-col(X)” // show formulas
and a problem is that people are doing complicated calculations between many worksheets and workbooks, so I really think it would be good to keep track of all applied operations,… and mainly it is important to keep it simple, because we just want to see very quickly what was done on the particular column in the worksheet,...
and,...
imagine that col(A) was imported from file C:\example.txt, then the “formula$” may say that the column was imported from C:\example.txt:
> col(A).formula$=”C:\example.txt”
yeh, sorry I tend to overcomplicated things,… I just think that it will be useful if we know whether the column was imported from some file or it was calculated from data in the worksheet by some formula/s,…
Cheers
Ondrej
|
| couturier |
Posted - 01/21/2009 : 08:38:29 AM
I like the idea of formula$. If you're going to add such a property, maybe it is good to also include a before_formula$ property.
The part about the many formulas can be solved in writing in one shot the full stuff, like:
col(c)=(col(a)+col(b))^2-col(X);
or by using the before formula script.
I think keeping an history of everything may be a bit overcomplicated. |
| OndrejMM |
Posted - 01/21/2009 : 12:26:34 AM
Hi CP
it looks okay,… just maybe try to do it even more simple, because people may use it quite often as a number of LabTalk user increases…
maybe as follows: formula col(C)
but thinking about it, …. it might happen that someone will use many formulas on the same column, e.g.:
col(c)=col(a)+col(b);
col(c)^2;
col(c)=col(c)-col(X);
I think, it would require to know the column’ history,… like:
- date when the column was created (10/02/2008)
- the source file (C:\file\example.txt)
- formula/s
col(c)=col(a)+col(b);
col(c)^2;
col(c)=col(c)-col(X);
maybe make new X-function, e.g. “colinfo” with different properties “date”, “file”, “formulas”,….
but, maybe I’ve just overcomplicated it :-), I’m sure you will find a good way to do it,…
cheers
|
| cpyang |
Posted - 01/20/2009 : 10:41:53 PM
Currenly, there is no such thing.
So if we provide LT access to set/get col formula, then it will be good enough? Like
range a=col(c);
a.formula$="col(b)-col(a)";
This new property can be both set and get, will that be good enough?
CP
|
|
|
