Spreadsheet Class Reference

#include <Spreadsheet.h>

List of all members.

Public Slots
void	Menu (QPopupMenu *menu)
	open context menu
void	updateValuesDialog ()
void	selectionChanged ()
QString	Title () const
	get title
void	setTitle (QString t="")
	set spreadsheet title
QString	Notes () const
	get notes
void	setNotes (QString notes="")
	set spreadsheet notes
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
int	selectedColumns ()
	calculate number of selected cols
int	selectedRows ()
	calculate number of selected rows
int	getColumnIndex (QString title)
	get the index of the column with name title
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 v)
void	addGraph2D (Graph2D *g)
void	addGraph3D (Graph3D *g)
void	addGraph4D (Graph4D *g)
void	addGraphM (GraphM *g)
void	addGraphL (GraphL *g)
Graph2D *	getGraph2D ()
	create Graph2D from table data
Graph3D *	getGraph3D ()
Graph4D *	getGraph4D ()
GraphM *	getGraphM ()
GraphL *	getGraphL ()
	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	convertFORTRAN ()
	replace all 'd' and 'D' with 'e'
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
ExportDialog *	exportData ()
	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 ()
MainWin *	getMainWin ()
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)
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	setColumnNames (int nrcols)
void	contextMenuEvent (QContextMenuEvent *)
void	mousePressEvent (QMouseEvent *)
	used for left upper corner
void	resizeEvent (QResizeEvent *)
void	closeEvent (QCloseEvent *)
Private Attributes
MainWin *	mw
WidgetType	widgettype
QString	title
QString	notes
QTable *	table
ListDialog *	ld
SpreadsheetValuesDialog *	values_dialog
Graph *	graph
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::convertFORTRAN (   )  [slot]

replace all 'd' and 'D' with 'e'

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

int Spreadsheet::getColumnIndex (  QString  title  )  [slot]

get the index of the column with name title

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]

used for left upper corner

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

QString Spreadsheet::Notes (   )  const [inline, slot]

get notes

void Spreadsheet::open (  QTextStream *  t, int  version )

void Spreadsheet::openXML (  QDomNode  node  )

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

int Spreadsheet::selectedColumns (   )  [slot]

calculate number of selected cols

int Spreadsheet::selectedRows (   )  [slot]

calculate number of selected rows

void Spreadsheet::selectInvert (   )  [slot]

invert selection

void Spreadsheet::selectionChanged (   )  [slot]

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::setColumnNames (  int  nrcols  )  [private]

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  v  )  [inline, slot]

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

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

void Spreadsheet::setNotes (  QString  notes = ""  )  [slot]

set spreadsheet notes

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]

QString Spreadsheet::notes [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:

• Spreadsheet.h
• Spreadsheet.cc

---