kspread
KSpread::Sheet Class Reference
List of all members.Detailed Description
Definition at line 180 of file kspread_sheet.h.
Public Types | |
enum | Direction { Right, Left, Up, Down } |
enum | SortingOrder { Increase, Decrease } |
enum | ChangeRef { ColumnInsert, ColumnRemove, RowInsert, RowRemove } |
enum | TestType { Text, Validity, Comment, ConditionalCellAttribute } |
enum | LayoutDirection { LeftToRight, RightToLeft } |
Signals | |
void | sig_refreshView () |
void | sig_updateView (Sheet *_sheet) |
void | sig_updateView (Sheet *_sheet, const Region &) |
void | sig_updateView (EmbeddedObject *obj) |
void | sig_updateHBorder (Sheet *_sheet) |
void | sig_updateVBorder (Sheet *_sheet) |
void | sig_updateChildGeometry (EmbeddedKOfficeObject *_child) |
void | sig_maxColumn (int _max_column) |
void | sig_maxRow (int _max_row) |
void | sig_nameChanged (Sheet *sheet, const QString &old_name) |
void | sig_polygonInvalidated (const QPointArray &) |
void | sig_SheetHidden (Sheet *sheet) |
void | sig_SheetShown (Sheet *sheet) |
void | sig_SheetRemoved (Sheet *sheet) |
void | sig_SheetActivated (Sheet *) |
void | sig_RefreshView (Sheet *) |
Public Member Functions | |
Sheet (Map *map, const QString &sheetName, const char *_name=0L) | |
~Sheet () | |
virtual bool | isEmpty (unsigned long int x, unsigned long int y) const |
QString | sheetName () const |
QString | tableName () const |
bool | setSheetName (const QString &name, bool init=false, bool makeUndo=true) |
Map * | workbook () const |
Doc * | doc () const |
virtual QDomElement | saveXML (QDomDocument &) |
virtual bool | loadXML (const QDomElement &) |
virtual bool | loadOasis (const QDomElement &sheet, KoOasisLoadingContext &oasisContext, QDict< Style > &styleMap) |
virtual bool | saveOasis (KoXmlWriter &xmlWriter, KoGenStyles &mainStyles, GenValidationStyles &valStyle, KoStore *store, KoXmlWriter *manifestWriter, int &indexObj, int &partIndexObj) |
void | saveOasisHeaderFooter (KoXmlWriter &xmlWriter) const |
void | loadOasisObjects (const QDomElement &e, KoOasisLoadingContext &oasisContext) |
void | loadOasisSettings (const KoOasisSettings::NamedMap &settings) |
void | saveOasisSettings (KoXmlWriter &settingsWriter, const QPoint &marker) const |
void | saveOasisPrintStyleLayout (KoGenStyle &style) const |
virtual bool | saveChildren (KoStore *_store, const QString &_path) |
bool | saveOasisObjects (KoStore *store, KoXmlWriter &xmlWriter, KoGenStyles &mainStyles, int &indexObj, int &partIndexObj) |
virtual bool | loadChildren (KoStore *_store) |
bool | isLoading () |
QPtrList< EmbeddedObject > | getSelectedObjects () |
KoRect | getRealRect (bool all) |
KCommand * | moveObject (View *_view, double diffx, double diffy) |
KCommand * | moveObject (View *m_view, const KoPoint &_move, bool key) |
void | unifyObjectName (EmbeddedObject *object) |
LayoutDirection | layoutDirection () const |
void | setLayoutDirection (LayoutDirection dir) |
bool | isRightToLeft () const |
void | password (QCString &passwd) const |
bool | isProtected () const |
void | setProtected (QCString const &passwd) |
bool | checkPassword (QCString const &passwd) const |
void | setDefaultHeight (double height) |
void | setDefaultWidth (double width) |
const ColumnFormat * | columnFormat (int _column) const |
ColumnFormat * | columnFormat (int _column) |
ColumnFormat * | nonDefaultColumnFormat (int _column, bool force_creation=true) |
const RowFormat * | rowFormat (int _row) const |
RowFormat * | rowFormat (int _row) |
RowFormat * | nonDefaultRowFormat (int _row, bool force_creation=true) |
Cell * | firstCell () const |
RowFormat * | firstRow () const |
ColumnFormat * | firstCol () const |
Cell * | cellAt (int _column, int _row) const |
Cell * | cellAt (int _column, int _row, bool _scrollbar_update=false) |
Cell * | cellAt (const QPoint &_point, bool _scrollbar_update=false) |
Cell * | visibleCellAt (int _column, int _row, bool _scrollbar_update=false) |
Cell * | nonDefaultCell (int _column, int _row, bool _scrollbar_update=false, Style *_style=0) |
Cell * | nonDefaultCell (QPoint const &cellRef, bool scroll=false) |
Cell * | defaultCell () const |
Format * | defaultFormat () |
const Format * | defaultFormat () const |
Value | value (int col, int row) const |
Value | valueRange (int col1, int row1, int col2, int row2) const |
QRect | visibleRect (Canvas const *const _canvas) const |
int | topRow (double _ypos, double &_top, const Canvas *_canvas=0L) const |
int | bottomRow (double _ypos, const Canvas *_canvas=0L) const |
int | leftColumn (double _xpos, double &_left, const Canvas *_canvas=0L) const |
int | rightColumn (double _xpos, const Canvas *_canvas=0L) const |
int | columnPos (int _col, const Canvas *_canvas=0L) const |
double | dblColumnPos (int _col, const Canvas *_canvas=0L) const |
int | rowPos (int _row, const Canvas *_canvas=0L) const |
double | dblRowPos (int _row, const Canvas *_canvas=0L) const |
double | sizeMaxX () const |
double | sizeMaxY () const |
void | adjustSizeMaxX (double _x) |
void | adjustSizeMaxY (double _y) |
void | setLayoutDirtyFlag () |
void | setCalcDirtyFlag () |
void | recalc (bool force) |
void | recalc () |
void | valueChanged (Cell *cell) |
QString | guessColumnTitle (QRect &area, int col) |
QString | guessRowTitle (QRect &area, int row) |
void | setText (int row, int column, const QString &text, bool asString=false) |
void | setArrayFormula (Selection *selectionInfo, const QString &_text) |
void | setSelectionFont (Selection *selectionInfo, const char *_font=0L, int _size=-1, signed char _bold=-1, signed char _italic=-1, signed char _underline=-1, signed char _strike=-1) |
void | setSelectionMoneyFormat (Selection *selectionInfo, bool b) |
void | setSelectionAlign (Selection *selectionInfo, Format::Align _align) |
void | setSelectionAlignY (Selection *selectionInfo, Format::AlignY _alignY) |
void | setSelectionPrecision (Selection *selectionInfo, int _delta) |
void | setSelectionPercent (Selection *selectionInfo, bool b) |
void | setSelectionMultiRow (Selection *selectionInfo, bool enable) |
void | setSelectionStyle (Selection *selectionInfo, Style *style) |
void | setSelectionSize (Selection *selectionInfo, int _size) |
void | setSelectionUpperLower (Selection *selectionInfo, int _type) |
void | setSelectionfirstLetterUpper (Selection *selectionInfo) |
void | setSelectionVerticalText (Selection *selectionInfo, bool _b) |
void | setSelectionComment (Selection *selectionInfo, const QString &_comment) |
void | setSelectionRemoveComment (Selection *selectionInfo) |
void | setSelectionAngle (Selection *selectionInfo, int _value) |
void | setSelectionTextColor (Selection *selectionInfo, const QColor &tbColor) |
void | setSelectionbgColor (Selection *selectionInfo, const QColor &bg_Color) |
void | setSelectionBorderColor (Selection *selectionInfo, const QColor &bd_Color) |
void | deleteSelection (Selection *selectionInfo, bool undo=true) |
void | copySelection (Selection *selectionInfo) |
void | cutSelection (Selection *selectionInfo) |
void | clearTextSelection (Selection *selectionInfo) |
void | clearValiditySelection (Selection *selectionInfo) |
void | clearConditionalSelection (Selection *selectionInfo) |
void | fillSelection (Selection *selectionInfo, int direction) |
void | setWordSpelling (Selection *selectionInfo, const QString _listWord) |
QString | getWordSpelling (Selection *selectionInfo) |
void | paste (const QRect &pasteArea, bool makeUndo=true, Paste::Mode=Paste::Normal, Paste::Operation=Paste::OverWrite, bool insert=false, int insertTo=0, bool pasteFC=false, QClipboard::Mode clipboardMode=QClipboard::Clipboard) |
void | paste (const QByteArray &data, const QRect &pasteArea, bool makeUndo=false, Paste::Mode=Paste::Normal, Paste::Operation=Paste::OverWrite, bool insert=false, int insertTo=0, bool pasteFC=false) |
void | defaultSelection (Selection *selectionInfo) |
void | pasteTextPlain (QString &_text, QRect pasteArea) |
void | sortByRow (const QRect &area, int ref_row, SortingOrder) |
void | sortByRow (const QRect &area, int key1, int key2, int key3, SortingOrder order1, SortingOrder order2, SortingOrder order3, QStringList const *firstKey, bool copyFormat, bool headerRow, Point const &outputPoint, bool respectCase) |
void | sortByColumn (const QRect &area, int ref_column, SortingOrder) |
void | sortByColumn (const QRect &area, int key1, int key2, int key3, SortingOrder order1, SortingOrder order2, SortingOrder order3, QStringList const *firstKey, bool copyFormat, bool headerCol, Point const &outputPoint, bool respectCase) |
void | swapCells (int x1, int y1, int x2, int y2, bool cpFormat) |
void | copyCells (int x1, int y1, int x2, int y2, bool cpFormat) |
void | setSeries (const QPoint &_marker, double start, double end, double step, Series mode, Series type) |
bool | shiftRow (const QRect &_rect, bool makeUndo=true) |
bool | shiftColumn (const QRect &rect, bool makeUndo=true) |
void | unshiftColumn (const QRect &rect, bool makeUndo=true) |
void | unshiftRow (const QRect &rect, bool makeUndo=true) |
bool | insertColumn (int col, int nbCol=0, bool makeUndo=true) |
bool | insertRow (int row, int nbRow=0, bool makeUndo=true) |
void | removeColumn (int col, int nbCol=0, bool makeUndo=true) |
void | removeRow (int row, int nbRow=0, bool makeUndo=true) |
void | hideRow (const Region &) |
void | emitHideRow () |
void | showRow (const Region &) |
void | hideColumn (const Region &) |
void | emitHideColumn () |
void | showColumn (const Region &) |
void | adjustArea (const Region &) |
void | adjustColumn (const Region &) |
void | adjustRow (const Region &) |
void | borderLeft (Selection *selectionInfo, const QColor &_color) |
void | borderTop (Selection *selectionInfo, const QColor &_color) |
void | borderOutline (Selection *selectionInfo, const QColor &_color) |
void | borderAll (Selection *selectionInfo, const QColor &_color) |
void | borderRemove (Selection *selectionInfo) |
void | borderBottom (Selection *selectionInfo, const QColor &_color) |
void | borderRight (Selection *selectionInfo, const QColor &_color) |
void | setConditional (Selection *selectionInfo, QValueList< Conditional > const &newConditions) |
void | setValidity (Selection *selectionInfo, KSpread::Validity tmp) |
bool | getShowGrid () const |
void | setShowGrid (bool _showGrid) |
bool | getShowFormula () const |
void | setShowFormula (bool _showFormula) |
bool | getShowFormulaIndicator () const |
void | setShowFormulaIndicator (bool _showFormulaIndicator) |
bool | getShowCommentIndicator () const |
void | setShowCommentIndicator (bool b) |
bool | getLcMode () const |
void | setLcMode (bool _lcMode) |
bool | getAutoCalc () const |
void | setAutoCalc (bool _AutoCalc) |
bool | getShowColumnNumber () const |
void | setShowColumnNumber (bool _showColumnNumber) |
bool | getHideZero () const |
void | setHideZero (bool _hideZero) |
bool | getFirstLetterUpper () const |
void | setFirstLetterUpper (bool _firstUpper) |
void | changeMergedCell (int, int, int, int) |
void | mergeCells (const Region ®ion, bool hor=false, bool ver=false) |
void | dissociateCells (const Region ®ion) |
void | increaseIndent (Selection *selectionInfo) |
void | decreaseIndent (Selection *selectionInfo) |
bool | areaIsEmpty (const Region &area, TestType _type=Text) |
void | refreshPreference () |
void | hideSheet (bool _hide) |
void | removeSheet () |
QRect | selectionCellMerged (const QRect &_sel) |
void | changeNameCellRef (const QPoint &pos, bool fullRowOrColumn, ChangeRef ref, QString tabname, int NbCol=1, UndoInsertRemoveAction *undo=0) |
void | refreshRemoveAreaName (const QString &_areaName) |
void | refreshChangeAreaName (const QString &_areaName) |
void | refreshChart (const QPoint &pos, bool fullRowOrColumn, ChangeRef ref) |
void | refreshMergedCell () |
bool | isHidden () const |
void | setHidden (bool hidden) |
QPainter & | painter () |
QWidget * | widget () const |
bool | isShowPageBorders () const |
void | setShowPageBorders (bool _b) |
void | addCellBinding (CellBinding *_bind) |
void | removeCellBinding (CellBinding *_bind) |
CellBinding * | firstCellBinding () |
CellBinding * | nextCellBinding () |
bool | getCellRectangle (const QRect &_range, QPtrList< Cell > &_list) |
Sheet * | findSheet (const QString &_name) |
void | insertCell (Cell *_cell) |
void | insertColumnFormat (ColumnFormat *_l) |
void | insertRowFormat (RowFormat *_l) |
QDomDocument | saveCellRegion (const Region &, bool copy=false, bool era=false) |
bool | loadSelection (const QDomDocument &doc, const QRect &pasteArea, int _xshift, int _yshift, bool makeUndo, Paste::Mode=Paste::Normal, Paste::Operation=Paste::OverWrite, bool insert=false, int insertTo=0, bool paste=false) |
void | loadSelectionUndo (const QDomDocument &doc, const QRect &loadArea, int _xshift, int _yshift, bool insert, int insertTo) |
bool | testAreaPasteInsert () const |
void | deleteCells (const Region ®ion) |
bool | testListChoose (Selection *selectionInfo) |
QString | copyAsText (Selection *selection) |
void | autofill (QRect &src, QRect &dest) |
bool | insertChild (const KoRect &_geometry, KoDocumentEntry &) |
bool | insertChart (const KoRect &_geometry, KoDocumentEntry &, const QRect &_data) |
bool | insertPicture (const KoPoint &point, const KURL &file) |
bool | insertPicture (const KoPoint &point, const QPixmap &pixmap) |
void | changeChildGeometry (EmbeddedKOfficeObject *_child, const KoRect &_geometry) |
const QColorGroup & | colorGroup () |
int | id () const |
int | maxColumn () const |
void | checkRangeHBorder (int _column) |
int | maxRow () const |
void | checkRangeVBorder (int _row) |
void | enableScrollBarUpdates (bool _enable) |
virtual DCOPObject * | dcopObject () |
void | printDebug () |
void | updateCell (Cell *_cell, int _col, int _row) |
void | updateCellArea (const Region &cellArea) |
void | update () |
void | updateView () |
void | updateView (QRect const &rect) |
void | updateView (Region *) |
void | refreshView (const Region ®ion) |
void | emit_updateRow (RowFormat *_format, int _row, bool repaint=true) |
void | emit_updateColumn (ColumnFormat *_format, int _column) |
const QPen & | emptyPen () const |
const QBrush & | emptyBrush () const |
const QColor & | emptyColor () const |
void | updateLocale () |
void | setRegionPaintDirty (QRect const &range) |
void | setRegionPaintDirty (Region const ®ion) |
void | clearPaintDirtyData () |
bool | cellIsPaintDirty (QPoint const &cell) const |
Cell * | getFirstCellColumn (int col) const |
Cell * | getLastCellColumn (int col) const |
Cell * | getFirstCellRow (int row) const |
Cell * | getLastCellRow (int row) const |
Cell * | getNextCellUp (int col, int row) const |
Cell * | getNextCellDown (int col, int row) const |
Cell * | getNextCellLeft (int col, int row) const |
Cell * | getNextCellRight (int col, int row) const |
SheetPrint * | print () const |
KSpread::DependencyManager * | dependencies () |
int | numSelected () const |
Static Public Member Functions | |
static Sheet * | find (int _id) |
Protected Types | |
enum | SelectionType { CompleteRows, CompleteColumns, CellRegion } |
Protected Slots | |
void | slotAreaModified (const QString &name) |
Protected Member Functions | |
void | updateAllDependencies () |
void | changeCellTabName (QString const &old_name, QString const &new_name) |
bool | loadRowFormat (const QDomElement &row, int &rowIndex, KoOasisLoadingContext &oasisContext, QDict< Style > &styleMap) |
bool | loadColumnFormat (const QDomElement &row, const KoOasisStyles &oasisStyles, int &indexCol, const QDict< Style > &styleMap) |
bool | loadSheetStyleFormat (QDomElement *style) |
void | loadOasisMasterLayoutPage (KoStyleStack &styleStack) |
QString | saveOasisSheetStyleName (KoGenStyles &mainStyles) |
void | saveOasisColRowCell (KoXmlWriter &xmlWriter, KoGenStyles &mainStyles, int maxCols, int maxRows, GenValidationStyles &valStyle) |
void | saveOasisCells (KoXmlWriter &xmlWriter, KoGenStyles &mainStyles, int row, GenValidationStyles &valStyle) |
void | convertPart (const QString &part, KoXmlWriter &writer) const |
void | addText (const QString &text, KoXmlWriter &writer) const |
void | maxRowCols (int &maxCols, int &maxRows) |
QString | getPart (const QDomNode &part) |
void | replaceMacro (QString &text, const QString &old, const QString &newS) |
void | insertObject (EmbeddedObject *_obj) |
void | fillSequence (QPtrList< Cell > &_srcList, QPtrList< Cell > &_destList, QPtrList< AutoFillSequence > &_seqList, bool down=true) |
SelectionType | workOnCells (Selection *selectionInfo, CellWorker &worker) |
Static Protected Attributes | |
static int | s_id = 0L |
static QIntDict< Sheet > * | s_mapSheets |
Properties | |
QString | sheetName |
bool | autoCalc |
bool | showGrid |
Friends | |
class | Cell |
Classes | |
struct | CellWorker |
struct | CellWorkerTypeA |
Member Function Documentation
|
Adjust columns and rows of a region.
Definition at line 4543 of file kspread_sheet.cc. |
|
Adjust columns of a region.
Definition at line 4553 of file kspread_sheet.cc. |
|
Adjust rows of a region.
Definition at line 4562 of file kspread_sheet.cc. |
|
Adjusts the internal reference of the sum of the widths of all columns. Used in resizing of columns. Definition at line 999 of file kspread_sheet.cc. |
|
Adjusts the internal reference of the sum of the heights of all rows. Used in resizing of rows. Definition at line 1004 of file kspread_sheet.cc. |
|
Assume that the retangle 'src' was already selected. Then the user clicked on the lower right corner of the marker and resized the area ( left mouse button ). Once he releases the mouse we have to autofill the region 'dest'. Mention that src.left() == dest.left() and src.top() == dest.top().
Definition at line 578 of file kspread_autofill.cc. |
|
Install borders.
Definition at line 3024 of file kspread_sheet.cc. |
|
A convenience function.
Definition at line 366 of file kspread_sheet.h. |
|
Definition at line 1042 of file kspread_sheet.cc. |
|
Test whether a cell needs repainted.
Definition at line 8383 of file kspread_sheet.cc. |
|
Change the name of a sheet in all formulas. When you change name sheet Sheet1 -> Price for all cell which refere to Sheet1, this function changes the name. Definition at line 2336 of file kspread_sheet.cc. |
|
Change name of reference when the user inserts or removes a column, a row or a cell (= insertion of a row [or column] on a single column [or row]). For example the formula =Sheet1!A1 is changed into =Sheet1!B1 if a Column is inserted before A.
Definition at line 2767 of file kspread_sheet.cc. |
|
Checks if the argument _column is out of the current maximum range of the vertical border If this is the case, the current maximum value m_iMaxColumn is adjusted and the vertical border is resized. Use this function with care, as it involves a repaint of the border, when it is out of range. Definition at line 8191 of file kspread_sheet.cc. |
|
Checks if the argument _row is out of the current maximum range of the horizontal border If this is the case, the current maximum value m_iMaxRow is adjusted and the horizontal border is resized. Use this function with care, as it involves a repaint of the border, when it is out of range. Definition at line 8200 of file kspread_sheet.cc. |
|
Remove all records of 'paint dirty' cells.
Definition at line 8378 of file kspread_sheet.cc. |
|
Definition at line 4589 of file kspread_sheet.cc. |
|
Definition at line 966 of file kspread_sheet.cc. |
|
returns the text to be copied to the clipboard
Definition at line 4992 of file kspread_sheet.cc. |
|
Definition at line 3828 of file kspread_sheet.cc. |
|
Definition at line 5046 of file kspread_sheet.cc. |
|
Definition at line 5065 of file kspread_sheet.cc. |
|
Definition at line 946 of file kspread_sheet.cc. |
|
Definition at line 972 of file kspread_sheet.cc. |
|
Deletes all cells in the given rectangle. The display is NOT updated by this function. This function can be used to clear an area before you paste something from the clipboard in this area.
Definition at line 5530 of file kspread_sheet.cc. |
|
Definition at line 5597 of file kspread_sheet.cc. |
|
returns a pointer to the dependency manager
Definition at line 759 of file kspread_sheet.cc. |
|
Needed for Cell::leftBorderPen and friends, since we can not have a static pen object. The returned pen has pen style NoPen set. Definition at line 744 of file kspread_sheet.cc. |
|
Definition at line 696 of file kspread_autofill.cc. |
|
A convenience function that finds a sheet by its name.
Definition at line 7867 of file kspread_sheet.cc. |
|
Definition at line 1018 of file kspread_sheet.cc. |
|
Used by the 'chart' to get the sheet on which the chart is build. The cells we are interested in are in the rectangle '_range'. The cells are stored row after row in '_list'. |
|
Retrieve the first used cell in a given column. Can be used in conjunction with getNextCellDown to loop through a column.
Definition at line 8283 of file kspread_sheet.cc. |
|
Retrieve the first used cell in a given row. Can be used in conjunction with getNextCellRight to loop through a row.
Definition at line 8289 of file kspread_sheet.cc. |
|
Retrieve the last used cell in a given column. Can be used in conjunction with getNextCellUp to loop through a column.
Definition at line 8286 of file kspread_sheet.cc. |
|
Retrieve the last used cell in a given row. Can be used in conjunction with getNextCellLeft to loop through a row.
Definition at line 8292 of file kspread_sheet.cc. |
|
Retrieves the next used cell below the given col/row pair. The given col/row pair does not need to reference a used cell.
Definition at line 8298 of file kspread_sheet.cc. |
|
Retrieves the next used cell to the right of the given col/row pair. The given col/row pair does not need to reference a used cell.
Definition at line 8301 of file kspread_sheet.cc. |
|
Retrieves the next used cell to the left of the given col/row pair. The given col/row pair does not need to reference a used cell.
Definition at line 8304 of file kspread_sheet.cc. |
|
Retrieves the next used cell above the given col/row pair. The given col/row pair does not need to reference a used cell.
Definition at line 8295 of file kspread_sheet.cc. |
|
get the rect for the objects
Definition at line 6092 of file kspread_sheet.cc. |
|
Get a list of all selected objects.
Definition at line 6077 of file kspread_sheet.cc. |
|
Returns true if comment indicator is visible.
Definition at line 510 of file kspread_sheet.cc. |
|
Sets, if formula shall be shown instead of the result.
Definition at line 490 of file kspread_sheet.cc. |
|
Sets, if indicator must be shown when the cell holds a formula.
Definition at line 500 of file kspread_sheet.cc. |
|
Returns, if the grid shall be shown on the screen.
Definition at line 480 of file kspread_sheet.cc. |
|
Attempts to guess the title (or 'header') of a column, within a given area of the sheet This is used, for example, by the Data Sort dialog, to guess the names of columns within the selected area.
An empty string may be returned if guessColumnTitle does not think that column
Definition at line 4220 of file kspread_sheet.cc. |
|
Attempts to guess the title (or 'header') of a row, within a given area of the sheet This is used, for example, by the Data Sort dialog, to guess the names of rows within the selected area.
An empty string may be returned if guessRowTitle does not think that row
Definition at line 4246 of file kspread_sheet.cc. |
|
hide column
Definition at line 2683 of file kspread_sheet.cc. |
|
hide row
Definition at line 2657 of file kspread_sheet.cc. |
|
Inserts the All cells depending on this cell will be actualized. The border range will be actualized, when the cell is out of current range. Definition at line 7876 of file kspread_sheet.cc. |
|
Moves all columns which are >= After this the sheet is redrawn. nbCol is the number of column which are installing Definition at line 2497 of file kspread_sheet.cc. |
|
Used by Undo.
Definition at line 7888 of file kspread_sheet.cc. |
|
Creates a new embedded picture object and inserts it into the sheet at the specified position.
Definition at line 8065 of file kspread_sheet.cc. |
|
Creates a new embedded picture object and inserts it into the sheet next to the currently selected cell. TODO: Remove this method in future and provide a better way of opening pictures and inserting them into the sheet.
Definition at line 8019 of file kspread_sheet.cc. |
|
Moves all rows which are >= After this the sheet is redrawn. Definition at line 2540 of file kspread_sheet.cc. |
|
Used by Undo.
Definition at line 7893 of file kspread_sheet.cc. |
|
Definition at line 470 of file kspread_sheet.cc. |
|
Definition at line 465 of file kspread_sheet.cc. |
|
Definition at line 583 of file kspread_sheet.cc. |
|
Returns the layout direction of the sheet.
Definition at line 455 of file kspread_sheet.cc. |
|
Loads a children.
Definition at line 7827 of file kspread_sheet.cc. |
|
Loads the properties of a column from a table:table-column element in an OASIS XML file defaultColumnCellStyles is a map from column indicies to the default cell style for that column.
Definition at line 6658 of file kspread_sheet.cc. |
|
insertTo defined if you insert to the bottom or right insert to bottom if insertTo==1 insert to right if insertTo ==-1 insertTo used just for insert/paste an area
Definition at line 5220 of file kspread_sheet.cc. |
|
Loads the sheet and all it's children in XML format.
Definition at line 7476 of file kspread_sheet.cc. |
|
Return the currently maximum defined column of the horizontal scrollbar. It's always 10 times higher than the maximum access column. In an empty sheet it starts with 256. Definition at line 734 of file kspread_sheet.cc. |
|
Return the currently maximum defined row of the vertical scrollbar. It's always 10 times higher than the maximum access row. In an empty sheet it starts with 256. Definition at line 739 of file kspread_sheet.cc. |
|
Definition at line 5690 of file kspread_sheet.cc. |
|
If no special Cell exists for this position then a new one is created.
Definition at line 1096 of file kspread_sheet.cc. |
|
If no special ColumnFormat exists for this column, then a new one is created.
Definition at line 1066 of file kspread_sheet.cc. |
|
If no special RowFormat exists for this row, then a new one is created.
Definition at line 1081 of file kspread_sheet.cc. |
|
Get the amount of selected objects that belong to this sheet.
Definition at line 764 of file kspread_sheet.cc. |
|
Definition at line 688 of file kspread_sheet.cc. |
|
A convenience function which retrieves the data to be pasted from the clipboard.
Definition at line 5086 of file kspread_sheet.cc. |
|
A function which allows to paste a text plain from the clipboard.
Definition at line 5123 of file kspread_sheet.cc. |
|
Recalculates the current sheet, if automatic recalculation is enabled.
Definition at line 1225 of file kspread_sheet.cc. |
|
Recalculates the current sheet. If you want to recalculate EVERYTHING, then call Sheet::setCalcDirtyFlag for all sheets in the m_pMap to make sure that no invalid values in other sheets make you trouble. Recalc will do nothing if automatic calculation is disabled (via Sheet::setAutoCalc ). unless the force flag is set to true. Automatic recalculation is enabled by default.
Definition at line 1230 of file kspread_sheet.cc. |
|
Update chart when you insert or remove row or column.
Definition at line 2709 of file kspread_sheet.cc. |
|
Refresh merged cell when you insert or remove row or column.
Definition at line 2756 of file kspread_sheet.cc. |
|
used to refresh cells when you make redodelete
Definition at line 5657 of file kspread_sheet.cc. |
|
Deletes the column
Definition at line 2583 of file kspread_sheet.cc. |
|
Deletes the row
Definition at line 2620 of file kspread_sheet.cc. |
|
Definition at line 993 of file kspread_sheet.cc. |
|
Definition at line 5753 of file kspread_sheet.cc. |
|
Saves a children.
Definition at line 8098 of file kspread_sheet.cc. |
|
Saves the sheet and all it's children in XML format.
Definition at line 5886 of file kspread_sheet.cc. |
|
Sets the Cell::calcDirtyFlag in all cells. That means that the cells are marked dirty and will recalculate if requested. This function does only MARK, it does NOT actually calculate. Use recalc to recaculate dirty values. Definition at line 1203 of file kspread_sheet.cc. |
|
Hides or shows this sheets.
Definition at line 475 of file kspread_sheet.cc. |
|
Sets the layout direction of the sheet. For example, for Arabic or Hebrew documents, it is possibly to layout the sheet from right to left. Definition at line 460 of file kspread_sheet.cc. |
|
Sets the Cell::layoutDirtyFlag in all cells.
Definition at line 1196 of file kspread_sheet.cc. |
|
set a region of the spreadsheet to be 'paint dirty' meaning it needs repainted. This is not a flag on the cell itself since quite often this needs set on a default cell Definition at line 8371 of file kspread_sheet.cc. |
|
setSelectionSize increase or decrease font size
Definition at line 1748 of file kspread_sheet.cc. |
|
change string to upper case if _type equals 1 or change string to lower if _type equals -1
Definition at line 1793 of file kspread_sheet.cc. |
|
Renames a sheet. This will automatically adapt all formulas in all sheets and all cells to reflect the new name. If the name really changed then sig_nameChanged is emitted and the GUI will reflect the change.
Definition at line 8237 of file kspread_sheet.cc. |
|
If b is true, comment indicator is visible, otherwise it will be hidden.
Definition at line 515 of file kspread_sheet.cc. |
|
Sets, if the grid shall be shown on the screen.
Definition at line 485 of file kspread_sheet.cc. |
|
Turns the page break lines on or off.
Definition at line 7844 of file kspread_sheet.cc. |
|
Sets the contents of the cell at row,column to text.
Definition at line 1121 of file kspread_sheet.cc. |
|
Return the name of this sheet.
|
|
Moves all cells of the row _marker.y() which are in the column _marker.x() or right hand of that one position to the right.
Definition at line 2361 of file kspread_sheet.cc. |
|
|
|
Emitted if a certain area of some sheet has to be redrawn. That is for example the case when a new child is inserted. |
|
Definition at line 724 of file kspread_sheet.cc. |
|
Definition at line 729 of file kspread_sheet.cc. |
|
react on modification (add/remove) of a named area
Definition at line 2291 of file kspread_sheet.cc. |
|
Definition at line 212 of file kspread_sheet.h. |
|
Used when you insert and paste cell return true if it's a area false if it's a column/row it's used to select if you want to insert at the bottom or right.
Definition at line 5495 of file kspread_sheet.cc. |
|
Return true if there are text value in cell so you can create list selection.
Definition at line 5721 of file kspread_sheet.cc. |
|
Create a uniq name for an object. Create a uniq name for the object. If no name is set for the object a name according to its type is created. If the name already exists append ' (x)'. // FIXME: not allowed by I18N
Definition at line 6191 of file kspread_sheet.cc. |
|
Updates every cell on the sheet.
Definition at line 7898 of file kspread_sheet.cc. |
|
Updates dependencies for all cells on this sheet.
Definition at line 1213 of file kspread_sheet.cc. |
|
Calculates the cell if necessary, makes its layout if necessary, and force redraw. Then it sets the cell's Cell::m_bDisplayDirtyFlag to false. Definition at line 7915 of file kspread_sheet.cc. |
|
Like updateCell except it works on a range of cells. Use this function rather than calling updateCell(..) on several adjacent cells so there will be one paint event instead of several Definition at line 7907 of file kspread_sheet.cc. |
|
repaints all visible cells in the given rect
Definition at line 5652 of file kspread_sheet.cc. |
|
repaints all visible cells in the given rect
Definition at line 5647 of file kspread_sheet.cc. |
|
repaints all visible cells
Definition at line 5642 of file kspread_sheet.cc. |
|
retrieve a value
Definition at line 648 of file kspread_sheet.cc. |
|
handles the fact that a cell has been changed - updates things that need to be updated
Definition at line 1279 of file kspread_sheet.cc. |
|
retrieve a range of values
Definition at line 657 of file kspread_sheet.cc. |
|
Definition at line 1009 of file kspread_sheet.cc. |
|
Definition at line 693 of file kspread_sheet.cc. |
The documentation for this class was generated from the following files: