LibEngsas
|
#include <excelsheet.h>
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... | |
![]() | |
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 . | |
ESpreadsheetCell | data (int row, int column) const |
Returns the data of the cell row , column . | |
int | rowCount () const |
Returns the number of rows within this spreadsheet. | |
int | columnCount () const |
Returns the number of columns within this spreadsheet. | |
![]() | |
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. | |
bool | setForeground (int row, int column, QBrush foreground) |
Sets the foreground of cell row and column to foreground . | |
bool | setBackground (int row, int column, QBrush background) |
Sets the background of cell row and column to background . | |
bool | setFont (int row, int column, QFont font) |
Sets the font of cell row and column to font . | |
bool | setAlignment (int row, int column, Qt::AlignmentFlag alignment) |
Sets the alignment of cell row and column to alignment . | |
bool | data (QAbstractItemModel *model, QModelIndex root=QModelIndex()) const |
Loads the data of this spreadsheet into model as childs of index root . | |
![]() | |
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 | |
![]() | |
virtual void | reloadSettings () |
Used to reload the settings. | |
![]() | |
void | error (const QString &message) |
void | warning (const QString &message) |
void | information (const QString &message) |
void | reloadEnableActions () |
Request reloading of enabled actions in EMainWindow. | |
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. | |
void | doReloadSettings () |
Emitted to bring the reload request back to the farest child. | |
![]() | |
static void | connectByPass (QObject *parent, QObject *child) |
![]() | |
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 () |
![]() | |
ESpreadsheet (QObject *parent=NULL) | |
Constructs an ESpreadsheet without a provider. |
enum ExcelSheet::CellType |
Mirror enum of XlColorIndex.
The HorizontalAlignment enum is a "mirror" enum of Excel::Constants::XlHAlign.
The UnderlineStyle enum is a "mirror" enum of Excel::Constants::XlUnderlineStyle.
The VerticalAlignment enum is a "mirror" enum of Excel::Constants::XlVAlign.
ExcelSheet::ExcelSheet | ( | QAxObject * | sheet, |
ESpreadsheetProvider * | provider, | ||
QObject * | parent = NULL |
||
) |
|
virtual |
Returns the number of columns within this spreadsheet.
Implements ESpreadsheet.
|
private |
|
virtual |
Returns the data of the cell row
, column
.
Implements ESpreadsheet.
|
virtual |
Returns the number of rows within this spreadsheet.
Implements ESpreadsheet.
|
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.
|
virtual |
|
private |