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
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum for Programming
 LabTalk Forum
 Sort Rows With Graphs Embedded
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Mulvenna

Germany
46 Posts

Posted - 10/30/2013 :  09:12:19 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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

greg

USA
1379 Posts

Posted - 10/30/2013 :  10:34:07 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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];)
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000