3.0

3.0 | 8 ratings Rate this file 134 downloads (last 30 days) File Size: 5.44 KB File ID: #3477

graph_and_table

by Michael Robbins

 

22 May 2003 (Updated 12 Jun 2003)

No BSD License  

Creates a graph and a data table below it. The table is put in an activex control using the column.

Editor's Notes:

This file was a File Exchange Pick of the Week

Download Now | Watch this File

File Information
Description

Creates a graph and a data table below it.
  the table is put in an activex control using
  the column labels colhead
 
  This function is meant to be an example for CSSM and not
  to be used as is.
 
  It is meant to demonstrate ActiveX grid usage and works with
  MSFLEXGRID (which comes with Windows and doesn't allow editing)
  and SIMPLE GRID (which is available for free at
  http://adfsoft.hypermart.net/sgrid/ ).
 
  Use 'SGRID' for the whichgrid parameter to use
  simple grid, but you must first you must download it from the above
  website and register it. To register, find sgrid.ocx by clicking on
  the windows start button and selecting "find". Change your directory
  to its directory and type "regsvr32 sgrid.ocx"
    ___________________ ____________________
  | /\ | | /\ | X Y ##
  | /\ / \/\ /| | || || 1 1.0 ##
  | / \/ \_/\/ | ||\ ||/\|| 2 1.5 ##
  |_/_________________| || | | ||| 3 2.0 ##
  | X Y || || |/ | 4 1.6 ##
  | 1 1.0 || || | 5 2.0 ||
  | 2 1.5 ## | | 6 2.5 ||
  |__3__2.0__________|| |_________|__7__2.3_||
 
     horizontal split vertical split
 
  INPUTS DESCRIPTION DEFAULT VALUE
  x x data [1:10]
  y y data rand(size(x));
  colhead table header {'X','Y'};
  vertorhoriz vert or horiz split 0 %(vertical)
  figuretitle figure title 'graph_and_table'
  whichgrid MSFlexGrid or Simple Grid 'MSFlexGrid'
 
  OUTPUTS:
  h.fig handle to figure
  h.graph handle to graph
  h.line handle to data line
  h.grid handle to grid object
 
  USAGE:
  x=1:10;
  y=rand(size(x));
  colhead={'X','Y'};
  vertorhoriz=0; % vertical
  figuretitle='graph_and_table';
  h=graph_and_table(x,y,colhead,vertorhoriz,figuretitle);
  vertorhoriz=1; % horizontal
  h=graph_and_table(x,y,colhead,vertorhoriz,figuretitle);
  h=graph_and_table(x,y,colhead,vertorhoriz,figuretitle,'SGRID');
 
  IT'S NOT FANCY, BUT IT WORKS

Acknowledgements
This submission has inspired the following:
Keydown and Keypressed Events Demo
MATLAB release MATLAB 6.5 (R13)
Tags for This File  
Everyone's Tags
Tags I've Applied
Add New Tags Please login to tag files.
Comments and Ratings (12)
30 Dec 2003 John Robinson

Slick. One bug - the sgrid "font" property wants to be a handle, not a string. Not sure how to get around this now, so just commented that line (line 175) out of the sample. Also , formulas do not us the "=" token as in excel - e.g. a formula like "=A1+1" in excel would be written as "A1+1" in sgrid. Otherwise pretty cool.

25 Oct 2004 Xenya Petrova

hi!
1. got a question: how to you make msflexgrid run on the machine where you've got no vb or ms vc? it looks like simply registering an ocx is not enough.
2. why do you think that flexgrid allows no editing? you just write down a keydown and keypressed events and to it yourself.
3. thanks! was a real pleasure to play with your proggy

11 Feb 2005 Raúl Herrrera Avelar

Dear Michael Robbins,
I need help to made selection in control MS FlexGrid to save this how new variable. If you can say me where check properties, methods and actions of control.

Thank you

15 Apr 2005 Eric Shain

I can get it to work with MSFlexGrid, but when I print the figure, only the graph prints. The table doesn't print nor is it visible with a print preview. If I can't print the figure, it definitely makes it less useful.

12 Aug 2005 trash zone

i need command to build graph using mfc.

08 Feb 2006 HABIB REZA  
08 Jun 2006 zara laoure

Error in ==> two_axes_export>gui_mainfcn at 477
        gui_hFigure = feval(gui_State.gui_LayoutFcn, gui_SingletonOpt);

Error in ==> two_axes_export at 41
    gui_mainfcn(gui_State, varargin{:});

??? Undefined command/function 'actxcontrol'.

Error in ==> graph_and_table at 148
h.grid = actxcontrol(...

09 Feb 2007 said lahyani

hi i want to learn about matlab

25 Feb 2007 WALID ALI  
15 Dec 2007 Teguh Purnama Sidiq

very usefull, but unfortunately this error occur when i tried to run the program:

??? Error using ==> actxcontrol
Control creation failed. Invalid ProgID 'MSFlexGridLib.MSFlexGrid.1'

Error in ==> graph_and_table at 148
h.grid = actxcontrol(...

:(

09 Feb 2009 Yingyong Chen

Good work, however the same problem as Eric was pointing out that the grid does NOT print out, which makes it not quite as useful as it could be, as I have been looking hard for a solution in matlab to display tabulated data.

09 Feb 2009 Yingyong Chen

I have tried using the matlab uitable object to house the data, it prints, but it will always go out of position when being printed since the table is hard anchored on the figure and moves to unintended location when it prints due to resizing issue.

Please login to add a comment or rating.
Updates
12 Jun 2003

Now can use MSFLEXGRID and SimpleGrid. SimpleGrid allows editing and works on some machines that cannot use MSFLEXGRID.

Tag Activity for this File
Tag Applied By Date/Time
specialized Michael Robbins 22 Oct 2008 07:01:44
plotting Michael Robbins 22 Oct 2008 07:01:44
plot Michael Robbins 22 Oct 2008 07:01:44
graph Michael Robbins 22 Oct 2008 07:01:44
table Michael Robbins 22 Oct 2008 07:01:44
grid Michael Robbins 22 Oct 2008 07:01:44
object Michael Robbins 22 Oct 2008 07:01:44
flexgrid Michael Robbins 22 Oct 2008 07:01:44
msflexgrid Michael Robbins 22 Oct 2008 07:01:44
ocx Michael Robbins 22 Oct 2008 07:01:44
tabular Michael Robbins 22 Oct 2008 07:01:44
 

MATLAB Central Terms of Use

NOTICE: Any content you submit to MATLAB Central, including personal information, is not subject to the protections which may be afforded information collected under other sections of The MathWorks, Inc. Web site. You are entirely responsible for all content that you upload, post, e-mail, transmit or otherwise make available via MATLAB Central. The MathWorks does not control the content posted by visitors to MATLAB Central and, does not guarantee the accuracy, integrity, or quality of such content. Under no circumstances will The MathWorks be liable in any way for any content not authored by The MathWorks, or any loss or damage of any kind incurred as a result of the use of any content posted, e-mailed, transmitted or otherwise made available via MATLAB Central. Read the complete Terms prior to use.

Contact us at files@mathworks.com