Main Page | Namespace List | Class Hierarchy | Alphabetical List | Class List | Directories | File List | Class Members | File Members

Spreadsheet Class Reference

#include <Spreadsheet.h>

List of all members.

Public Slots

void Menu (QPopupMenu *menu)
 open context menu
void updateValuesDialog ()
QString Title () const
 get title
void setTitle (QString t="")
 set spreadsheet title
void setListDialog (ListDialog *l)
void setGraph (Graph *g)
QStringList columnInfo (int col)
 get info about column col
QString columnTitle (int col)
 get title of column col
void setColumnTitle (int col, QString name=0)
QString columnType (int col)
 get type of column col
void setColumnType (int col, QString type=0)
QString columnFormat (int col)
 get format of column col
void setColumnFormat (int col, QString format=0)
void Clear ()
 clear spreadsheet
int filledRows (int col=1)
 calculate number of filled rows
void plot2DSimple ()
 make a simple 2d plot of all selected columns
void plot2DPie ()
 make a pie plot of all selected columns
void plotLPie ()
 make a pie plot with value and label
void plot2DPolar ()
 make a polar plot of all selected columns
void plot3DXYPX ()
void plot3DXYPY ()
void plot2DLine ()
void plotMSurface ()
 make a surface plot of all selected columns
void plot3DSurface ()
 make a surface plot of x-y-z
void plotM3D ()
 make a 3d plot from matrix
void plotQWT3D ()
void plotMQWT3D ()
void plot3DXYDY (Input2D mode=I2DXYDY)
 make a 2d y-error plot of all selected columns
void plot4DXYDXDY ()
 make a 2d x-y-error plot of all selected columns
void plot4DXYDYDY ()
 make a 2d y1-y2-error plot of all selected columns
void plot3DSimple ()
 make a simple 3d plot of all selected columns
void plot3DTernary ()
 make a ternary plot of all selected columns
void selectDestination ()
 select destination for plot
int Destination ()
void setDestination (int d)
void addGraph2D (Graph2D *g)
void addGraph3D (Graph3D *g)
void addGraph4D (Graph4D *g)
void addGraphM (GraphM *g)
void addGraphL (GraphL *g)
Graph2DgetGraph2D ()
 create Graph2D from table data
Graph3DgetGraph3D ()
Graph4DgetGraph4D ()
GraphMgetGraphM ()
GraphLgetGraphL ()
 create GraphL from table data
void cutSelection ()
 cut current selection
void copySelection ()
 copy current selection
void pasteSelection ()
 paste current selection
void clearSelection ()
 clear current selection
void fillRowNumber ()
 fill selected column with row numbers
void fillRandom (double max=1.0)
 fill selected column with random numbers (0..max)
void setCurrentColumn (int i)
 set column i to current column (first column : 0)
void selectAll ()
 select everything
void selectNone ()
 deselect everything
void selectInvert ()
 invert selection
void normSum ()
 normalize current column to sum = 1.0
void normMax (double max=1.0)
 normalize current column to maximum = max
void convertComma ()
 replace all ',' with '.'
void transposeMatrix ()
 transpose spreadsheet matrix
void convertMatrixtoXYZ ()
 convert matrix data to x-y-z data
void convertXYZtoMatrix ()
 convert x-y-z data to matrix data
void convertColumntoMatrix ()
 convert one column to matrix
ExportDialogexportData ()
 export data
void addColumn ()
 add a column
void toggleMask ()
void maskSelection ()
void unMask ()
void maskNthRow ()
void maskFirstRow ()
void sortAscending ()
 sort current column ascending
void sortDescending ()
 sort current column descending
void rowStatistics ()
 slot wrapper
void Statistics (bool col=true)
 row/column statistics
void selectColumns (int left, int right=-1)
 select columns from right to left
void selectRows (int top, int bottom=-1)
 select rows from top to bottom
void deleteRows ()
 delete selected rows
void deleteColumns ()
 delete selected columns
void setValues (int srow=1, int erow=0, QString expr=0)
 set value of rows srow to erow in currentColumn to expr
void setProperties (QString label=0, int type=1, int format=0, int rows=100)
 set properties of current columns (label, type, format, rows)

Public Member Functions

 Spreadsheet (QWidget *parent, MainWin *mw, const char *name)
void update ()
void closeNow ()
WidgetType getWidgetType ()
QStringList Info ()
MainWingetMainWin ()
QTable * Table ()
void setText (int i, int j, QString text)
 set text of table item (i,j) to text
void save (QTextStream *t)
void open (QTextStream *t, int version)
QDomElement saveXML (QDomDocument doc)
void openXML (QDomNode node)
bool eventFilter (QObject *object, QEvent *e)

Static Public Member Functions

static void * operator new (size_t size)
static void operator delete (void *p)

Private Slots

void plot2D (PType type, bool line)
void plot3D (PType type)
void plotL (PType type)
void plotMatrix (PType type)
void editEditor (int editor)
void readfile (KProcess *process)
void editVI ()
void editKVIM ()
void editGVIM ()
void editKATE ()
void editKWRITE ()
void editEMACS ()
void editXEMACS ()
void editKWORD ()
void editSOFFICE ()

Private Member Functions

int formatItem (int col)
 return format index for column col
void sort ()
void qsort (int s, int e)
void updateGraphList ()
void contextMenuEvent (QContextMenuEvent *)
void mousePressEvent (QMouseEvent *)
void resizeEvent (QResizeEvent *)
void closeEvent (QCloseEvent *)

Private Attributes

MainWinmw
WidgetType widgettype
QString title
QTable * table
ListDialogld
SpreadsheetValuesDialogvalues_dialog
Graphgraph
GRAPHType gtype
QString datafile
QString tmpfilename
bool ascending
int destination
QPopupMenu * plotmenu
QPopupMenu * destmenu
QPopupMenu * selmenu
QPopupMenu * fillmenu
QPopupMenu * normmenu
QPopupMenu * editmenu
QPopupMenu * convertmenu
QPopupMenu * sortmenu
QPopupMenu * maskmenu


Constructor & Destructor Documentation

Spreadsheet::Spreadsheet QWidget *  parent,
MainWin mw,
const char *  name
 


Member Function Documentation

void Spreadsheet::addColumn  )  [slot]
 

add a column

void Spreadsheet::addGraph2D Graph2D g  )  [slot]
 

void Spreadsheet::addGraph3D Graph3D g  )  [slot]
 

void Spreadsheet::addGraph4D Graph4D g  )  [slot]
 

void Spreadsheet::addGraphL GraphL g  )  [slot]
 

void Spreadsheet::addGraphM GraphM g  )  [slot]
 

void Spreadsheet::Clear  )  [slot]
 

clear spreadsheet

void Spreadsheet::clearSelection  )  [slot]
 

clear current selection

void Spreadsheet::closeEvent QCloseEvent *   )  [private]
 

void Spreadsheet::closeNow  ) 
 

QString Spreadsheet::columnFormat int  col  )  [slot]
 

get format of column col

QStringList Spreadsheet::columnInfo int  col  )  [slot]
 

get info about column col

QString Spreadsheet::columnTitle int  col  )  [slot]
 

get title of column col

QString Spreadsheet::columnType int  col  )  [slot]
 

get type of column col

void Spreadsheet::contextMenuEvent QContextMenuEvent *   )  [private]
 

void Spreadsheet::convertColumntoMatrix  )  [slot]
 

convert one column to matrix

void Spreadsheet::convertComma  )  [slot]
 

replace all ',' with '.'

void Spreadsheet::convertMatrixtoXYZ  )  [slot]
 

convert matrix data to x-y-z data

void Spreadsheet::convertXYZtoMatrix  )  [slot]
 

convert x-y-z data to matrix data

void Spreadsheet::copySelection  )  [slot]
 

copy current selection

void Spreadsheet::cutSelection  )  [slot]
 

cut current selection

void Spreadsheet::deleteColumns  )  [slot]
 

delete selected columns

void Spreadsheet::deleteRows  )  [slot]
 

delete selected rows

int Spreadsheet::Destination  )  [inline, slot]
 

void Spreadsheet::editEditor int  editor  )  [private, slot]
 

void Spreadsheet::editEMACS  )  [inline, private, slot]
 

void Spreadsheet::editGVIM  )  [inline, private, slot]
 

void Spreadsheet::editKATE  )  [inline, private, slot]
 

void Spreadsheet::editKVIM  )  [inline, private, slot]
 

void Spreadsheet::editKWORD  )  [inline, private, slot]
 

void Spreadsheet::editKWRITE  )  [inline, private, slot]
 

void Spreadsheet::editSOFFICE  )  [inline, private, slot]
 

void Spreadsheet::editVI  )  [inline, private, slot]
 

void Spreadsheet::editXEMACS  )  [inline, private, slot]
 

bool Spreadsheet::eventFilter QObject *  object,
QEvent *  e
 

ExportDialog * Spreadsheet::exportData  )  [slot]
 

export data

int Spreadsheet::filledRows int  col = 1  )  [slot]
 

calculate number of filled rows

void Spreadsheet::fillRandom double  max = 1.0  )  [slot]
 

fill selected column with random numbers (0..max)

void Spreadsheet::fillRowNumber  )  [slot]
 

fill selected column with row numbers

int Spreadsheet::formatItem int  col  )  [private]
 

return format index for column col

Graph2D * Spreadsheet::getGraph2D  )  [slot]
 

create Graph2D from table data

Graph3D * Spreadsheet::getGraph3D  )  [slot]
 

Graph4D * Spreadsheet::getGraph4D  )  [slot]
 

GraphL * Spreadsheet::getGraphL  )  [slot]
 

create GraphL from table data

GraphM * Spreadsheet::getGraphM  )  [slot]
 

MainWin* Spreadsheet::getMainWin  )  [inline]
 

WidgetType Spreadsheet::getWidgetType  )  [inline]
 

QStringList Spreadsheet::Info  ) 
 

void Spreadsheet::maskFirstRow  )  [slot]
 

void Spreadsheet::maskNthRow  )  [slot]
 

void Spreadsheet::maskSelection  )  [slot]
 

void Spreadsheet::Menu QPopupMenu *  menu  )  [slot]
 

open context menu

void Spreadsheet::mousePressEvent QMouseEvent *   )  [private]
 

void Spreadsheet::normMax double  max = 1.0  )  [slot]
 

normalize current column to maximum = max

void Spreadsheet::normSum  )  [slot]
 

normalize current column to sum = 1.0

void Spreadsheet::open QTextStream *  t,
int  version
 

void Spreadsheet::openXML QDomNode  node  ) 
 

void Spreadsheet::operator delete void *  p  )  [static]
 

void * Spreadsheet::operator new size_t  size  )  [static]
 

void Spreadsheet::pasteSelection  )  [slot]
 

paste current selection

void Spreadsheet::plot2D PType  type,
bool  line
[private, slot]
 

void Spreadsheet::plot2DLine  )  [inline, slot]
 

void Spreadsheet::plot2DPie  )  [inline, slot]
 

make a pie plot of all selected columns

void Spreadsheet::plot2DPolar  )  [inline, slot]
 

make a polar plot of all selected columns

void Spreadsheet::plot2DSimple  )  [inline, slot]
 

make a simple 2d plot of all selected columns

void Spreadsheet::plot3D PType  type  )  [private, slot]
 

void Spreadsheet::plot3DSimple  )  [inline, slot]
 

make a simple 3d plot of all selected columns

void Spreadsheet::plot3DSurface  )  [inline, slot]
 

make a surface plot of x-y-z

void Spreadsheet::plot3DTernary  )  [inline, slot]
 

make a ternary plot of all selected columns

void Spreadsheet::plot3DXYDY Input2D  mode = I2DXYDY  )  [slot]
 

make a 2d y-error plot of all selected columns

void Spreadsheet::plot3DXYPX  )  [inline, slot]
 

void Spreadsheet::plot3DXYPY  )  [inline, slot]
 

void Spreadsheet::plot4DXYDXDY  )  [slot]
 

make a 2d x-y-error plot of all selected columns

void Spreadsheet::plot4DXYDYDY  )  [slot]
 

make a 2d y1-y2-error plot of all selected columns

void Spreadsheet::plotL PType  type  )  [private, slot]
 

void Spreadsheet::plotLPie  )  [inline, slot]
 

make a pie plot with value and label

void Spreadsheet::plotM3D  )  [inline, slot]
 

make a 3d plot from matrix

void Spreadsheet::plotMatrix PType  type  )  [private, slot]
 

void Spreadsheet::plotMQWT3D  )  [inline, slot]
 

void Spreadsheet::plotMSurface  )  [inline, slot]
 

make a surface plot of all selected columns

void Spreadsheet::plotQWT3D  )  [inline, slot]
 

void Spreadsheet::qsort int  s,
int  e
[private]
 

void Spreadsheet::readfile KProcess *  process  )  [private, slot]
 

void Spreadsheet::resizeEvent QResizeEvent *   )  [private]
 

void Spreadsheet::rowStatistics  )  [inline, slot]
 

slot wrapper

void Spreadsheet::save QTextStream *  t  ) 
 

QDomElement Spreadsheet::saveXML QDomDocument  doc  ) 
 

void Spreadsheet::selectAll  )  [slot]
 

select everything

void Spreadsheet::selectColumns int  left,
int  right = -1
[slot]
 

select columns from right to left

void Spreadsheet::selectDestination  )  [slot]
 

select destination for plot

void Spreadsheet::selectInvert  )  [slot]
 

invert selection

void Spreadsheet::selectNone  )  [slot]
 

deselect everything

void Spreadsheet::selectRows int  top,
int  bottom = -1
[slot]
 

select rows from top to bottom

void Spreadsheet::setColumnFormat int  col,
QString  format = 0
[slot]
 

void Spreadsheet::setColumnTitle int  col,
QString  name = 0
[slot]
 

void Spreadsheet::setColumnType int  col,
QString  type = 0
[slot]
 

void Spreadsheet::setCurrentColumn int  i  )  [slot]
 

set column i to current column (first column : 0)

void Spreadsheet::setDestination int  d  )  [inline, slot]
 

void Spreadsheet::setGraph Graph g  )  [inline, slot]
 

void Spreadsheet::setListDialog ListDialog l  )  [inline, slot]
 

void Spreadsheet::setProperties QString  label = 0,
int  type = 1,
int  format = 0,
int  rows = 100
[slot]
 

set properties of current columns (label, type, format, rows)

void Spreadsheet::setText int  i,
int  j,
QString  text
 

set text of table item (i,j) to text

void Spreadsheet::setTitle QString  t = ""  )  [slot]
 

set spreadsheet title

void Spreadsheet::setValues int  srow = 1,
int  erow = 0,
QString  expr = 0
[slot]
 

set value of rows srow to erow in currentColumn to expr

void Spreadsheet::sort  )  [private]
 

void Spreadsheet::sortAscending  )  [slot]
 

sort current column ascending

void Spreadsheet::sortDescending  )  [slot]
 

sort current column descending

void Spreadsheet::Statistics bool  col = true  )  [slot]
 

row/column statistics

QTable* Spreadsheet::Table  )  [inline]
 

QString Spreadsheet::Title  )  const [inline, slot]
 

get title

void Spreadsheet::toggleMask  )  [slot]
 

void Spreadsheet::transposeMatrix  )  [slot]
 

transpose spreadsheet matrix

void Spreadsheet::unMask  )  [slot]
 

void Spreadsheet::update  ) 
 

void Spreadsheet::updateGraphList  )  [private]
 

void Spreadsheet::updateValuesDialog  )  [slot]
 


Member Data Documentation

bool Spreadsheet::ascending [private]
 

QPopupMenu * Spreadsheet::convertmenu [private]
 

QString Spreadsheet::datafile [private]
 

int Spreadsheet::destination [private]
 

QPopupMenu * Spreadsheet::destmenu [private]
 

QPopupMenu* Spreadsheet::editmenu [private]
 

QPopupMenu * Spreadsheet::fillmenu [private]
 

Graph* Spreadsheet::graph [private]
 

GRAPHType Spreadsheet::gtype [private]
 

ListDialog* Spreadsheet::ld [private]
 

QPopupMenu * Spreadsheet::maskmenu [private]
 

MainWin* Spreadsheet::mw [private]
 

QPopupMenu * Spreadsheet::normmenu [private]
 

QPopupMenu* Spreadsheet::plotmenu [private]
 

QPopupMenu * Spreadsheet::selmenu [private]
 

QPopupMenu * Spreadsheet::sortmenu [private]
 

QTable* Spreadsheet::table [private]
 

QString Spreadsheet::title [private]
 

QString Spreadsheet::tmpfilename [private]
 

SpreadsheetValuesDialog* Spreadsheet::values_dialog [private]
 

WidgetType Spreadsheet::widgettype [private]
 


The documentation for this class was generated from the following files:
Generated on Sun Apr 2 02:05:11 2006 for LabPlot by  doxygen 1.4.4