| T O P I C R E V I E W |
| Mulvenna |
Posted - 10/30/2013 : 09:12:19 AM
Origin Ver. 8.6
Operating System:Windows 7
Hi,
A recently made a post about plotting against date. I have another problem regarding the same script, the data also first needs to be sorted by date but each row includes 4 embeded graphs relating to that particular row. When I use the sort command, the data sorts no problem but the graphs do not move. I understand that they are embedded in those particular cells but is there any way I can get the graphs to move with the data?
Thanks again in advance,
Mulvenna |
| 1 L A T E S T R E P L I E S (Newest First) |
| greg |
Posted - 10/30/2013 : 10:34:07 AM
Unfortunately, your version has a bug that does not handle sorting of a worksheet with embedded graphs. This was fixed in 9.0.
You should either make sure you sort before embedding your graphs or you will have to write a program that
1. Remembers which graph is embedded on what Date row
2. Opens each graph (e.g. win -a Graph1;)
3. Deletes the embedded image (e.g. col(C)[5]$ = "";)
4. Sorts the worksheet
5. Restores all the embedded graphs (e.g. insertGraph gname:=Graph1 embed:=1 cell:=[Book1]Sheet1!3[6:6];) |
|
|
