|
LibEngsas
|
|
LibEngsas
|
#include <excelsheet.h>
Inheritance diagram for ExcelSheet: Collaboration diagram for ExcelSheet:Public Types | |
| enum | UnderlineStyle { UnderlineStyleDouble = -4119, UnderlineStyleDoubleAccounting = 5, UnderlineStyleNone = -4142, UnderlineStyleSingle = 2, UnderlineStyleSingleAccounting = 4 } |
| The UnderlineStyle enum is a "mirror" enum of Excel::Constants::XlUnderlineStyle. More... | |
| enum | VerticalAlignment { VerticalAlignmentBottom = -4107, VerticalAlignmentCenter = -4108, VerticalAlignmentDistributed = -4117, VerticalAlignmentJustify = -4130, VerticalAlignmentTop = -4160 } |
| The VerticalAlignment enum is a "mirror" enum of Excel::Constants::XlVAlign. More... | |
| enum | HorizontalAlignment { HorizontalAlignmentCenter = -4108, HorizontalAlignmentCenterAcrossSelection = 7, HorizontalAlignmentDistributed = -4117, HorizontalAlignmentFill = 5, HorizontalAlignmentGeneral = 1, HorizontalAlignmentJustify = -4130, HorizontalAlignmentLeft = -4131, HorizontalAlignmentRight = -4152 } |
| The HorizontalAlignment enum is a "mirror" enum of Excel::Constants::XlHAlign. More... | |
| enum | CellType { CellTypeLastCell = 11 } |
| Parts of the Excel::Constants::XlCellType enum. More... | |
| enum | ColorIndex { ColorIndexAutomatic = -4105, ColorIndexNone = -4142 } |
| Mirror enum of XlColorIndex. More... | |
| Public Types inherited from ESpreadsheet | |
| enum | Header { HeaderNone = 0x0, HeaderVertical = 0x1, HeaderHorizontal = 0x2, HeaderAll = HeaderVertical | HeaderHorizontal } |
| Used by setData(QAbstractItemModel*, QModelIndex, Header) to determine which header to add. More... | |
Public Member Functions | |
| ExcelSheet (QAxObject *sheet, ESpreadsheetProvider *provider, QObject *parent=NULL) | |
| void | setName (QString name) |
| bool | setData (ESpreadsheetCell cell) |
Adds value to this spreadsheet at ESpreadsheetCell::row() and ESpreadsheetCell::column of cell. More... | |
| ESpreadsheetCell | data (int row, int column) const |
Returns the data of the cell row, column. More... | |
| int | rowCount () const |
| Returns the number of rows within this spreadsheet. More... | |
| int | columnCount () const |
| Returns the number of columns within this spreadsheet. More... | |
| Public Member Functions inherited from ESpreadsheet | |
| ESpreadsheet (ESpreadsheetProvider *provider, QObject *parent=NULL) | |
| QString | name () const |
| ESpreadsheetProvider * | provider () const |
| void | setProvider (ESpreadsheetProvider *provider) |
| bool | setData (QAbstractItemModel *model, ESpreadsheet::Headers header=ESpreadsheet::HeaderNone, QModelIndex root=QModelIndex()) |
Adds the data of the childs of index root to this spreadsheet. More... | |
| bool | setForeground (int row, int column, QBrush foreground) |
Sets the foreground of cell row and column to foreground. More... | |
| bool | setBackground (int row, int column, QBrush background) |
Sets the background of cell row and column to background. More... | |
| bool | setFont (int row, int column, QFont font) |
Sets the font of cell row and column to font. More... | |
| bool | setAlignment (int row, int column, Qt::AlignmentFlag alignment) |
Sets the alignment of cell row and column to alignment. More... | |
| bool | data (QAbstractItemModel *model, QModelIndex root=QModelIndex()) const |
Loads the data of this spreadsheet into model as childs of index root. More... | |
| Public Member Functions inherited from EObject | |
| EObject (QObject *parent=0) | |
| virtual | ~EObject () |
| void | connectByPass (QObject *object) |
Private Member Functions | |
| QColor | convertColor (QString vbaColorString) const |
Private Attributes | |
| QAxObject * | mySheet |
Additional Inherited Members | |
| Public Slots inherited from EObject | |
| virtual void | reloadSettings () |
| Used to reload the settings. More... | |
| Signals inherited from EObject | |
| void | error (const QString &message) |
| void | warning (const QString &message) |
| void | information (const QString &message) |
| void | reloadEnableActions () |
| Request reloading of enabled actions in EMainWindow. More... | |
| void | addMenu (QMenu *newMenu, const QString &parent, QString before=QString()) |
| void | addAction (QAction *newAction, const QString &parent, QString before=QString()) |
| void | addToolBar (QToolBar *newToolBar, Qt::ToolBarArea area=Qt::TopToolBarArea) |
| void | addNewDockWidget (QDockWidget *widget, const Qt::DockWidgetArea &area) |
| void | setCentralWidget (QWidget *centralWidget) |
| void | showSettings () |
| void | showHelp (const QString &page) |
| void | showStatusWidget (QWidget *widget) |
| void | reloadSettingsRequest () |
| Indicates, that a reload of the settings is needed. More... | |
| void | doReloadSettings () |
| Emitted to bring the reload request back to the farest child. More... | |
| Static Public Member Functions inherited from EObject | |
| static void | connectByPass (QObject *parent, QObject *child) |
| Protected Slots inherited from EObject | |
| virtual void | errorByPass (const QString &message) |
| virtual void | warningByPass (const QString &message) |
| virtual void | informationByPass (const QString &message) |
| virtual void | reloadEnableActionsByPass () |
| virtual void | addMenuByPass (QMenu *newMenu, const QString &parent, QString before=QString()) |
| virtual void | addActionByPass (QAction *newAction, const QString &parent, QString before=QString()) |
| virtual void | addToolBarByPass (QToolBar *newToolBar, Qt::ToolBarArea area=Qt::TopToolBarArea) |
| virtual void | addNewDockWidgetByPass (QDockWidget *widget, const Qt::DockWidgetArea &area) |
| virtual void | setCentralWidgetByPass (QWidget *centralWidget) |
| virtual void | showSettingsByPass () |
| virtual void | showHelpByPass (const QString &page) |
| virtual void | showStatusWidgetByPass (QWidget *widget) |
| virtual void | reloadSettingsRequestByPass () |
| Protected Member Functions inherited from ESpreadsheet | |
| ESpreadsheet (QObject *parent=NULL) | |
| Constructs an ESpreadsheet without a provider. More... | |
| Protected Member Functions inherited from EObject | |
| void | addManagedDockWidget (QDockWidget *widget, const Qt::DockWidgetArea &area, QString actionLabel=QString(), QString actionParent=QString()) |
Adds an dock widget via addNewDockWidget() and adds widget to the list of managed dock widgets. More... | |
| enum ExcelSheet::CellType |
The HorizontalAlignment enum is a "mirror" enum of Excel::Constants::XlHAlign.
| ExcelSheet::ExcelSheet | ( | QAxObject * | sheet, |
| ESpreadsheetProvider * | provider, | ||
| QObject * | parent = NULL |
||
| ) |
Here is the call graph for this function:
|
virtual |
Returns the number of columns within this spreadsheet.
Implements ESpreadsheet.
Here is the caller graph for this function:
|
private |
Here is the caller graph for this function:
|
virtual |
Returns the data of the cell row, column.
Implements ESpreadsheet.
Here is the call graph for this function:
|
virtual |
Returns the number of rows within this spreadsheet.
Implements ESpreadsheet.
Here is the caller graph for this function:
|
virtual |
Adds value to this spreadsheet at ESpreadsheetCell::row() and ESpreadsheetCell::column of cell.
To manipulate the text font, provide font, alignment and foreground. To specifiy a background color, set background.
Implements ESpreadsheet.
Here is the call graph for this function:
|
virtual |
Reimplemented from ESpreadsheet.
Here is the call graph for this function: Here is the caller graph for this function:
|
private |
1.8.8
