kspread
KSpread Namespace Reference
Detailed Description
The KSpread namespace.
Classes | |
| class | UndoWrapperCommand |
| Class UndoWrapperCommand is used to help migration from custom UndoAction to KCommand-based system. More... | |
| class | MergeCellCommand |
| Class MergeCellCommand implements a command for merging two or more cells into one cell. More... | |
| class | DissociateCellCommand |
| Class DissociateCellCommand implements a command for breaking merged cells. More... | |
| class | RenameSheetCommand |
| Class RenameSheetCommand implements a command for renaming a sheet. More... | |
| class | HideSheetCommand |
| class | ShowSheetCommand |
| class | AddSheetCommand |
| class | RemoveSheetCommand |
| class | SheetPropertiesCommand |
| Class SheetPropertiesCommand implements a command for changing sheet properties. More... | |
| class | InsertColumnCommand |
| class | DefinePrintRangeCommand |
| class | PaperLayoutCommand |
| class | LinkCommand |
| class | ChangeObjectGeometryCommand |
| class | RemoveObjectCommand |
| class | InsertObjectCommand |
| class | RenameNameObjectCommand |
| class | GeometryPropertiesCommand |
| class | MoveObjectByCmd |
| class | Damage |
| class | CellDamage |
| class | SheetDamage |
| struct | RangeDependency |
| Range dependency - stores information about one dependency of one cell on one range of cells. More... | |
| class | DependencyManager |
| This class manages dependencies. More... | |
| class | AngleDialog |
| class | AreaDialog |
| class | CommentDialog |
| class | ConditionalWidget |
| class | ConditionalDialog |
| class | ConsolidateDialog |
| class | CSVDialog |
| Provides dialog for managing CSV (comma separated value) data. More... | |
| class | DatabaseDialog |
| class | FindOption |
| class | FindDlg |
| class | SearchDlg |
| class | FormatDialog |
| Dialog for the "AutoFormat..." action. More... | |
| class | FormulaDialog |
| class | GoalSeekDialog |
| class | GotoDialog |
| class | InsertDialog |
| class | PatternSelect |
| class | GeneralTab |
| class | CellFormatPageFont |
| class | CellFormatPageFloat |
| Format of numbers. More... | |
| class | CellFormatPagePosition |
| class | Border |
| class | BorderButton |
| class | CellFormatPageBorder |
| class | BrushSelect |
| class | CellFormatPagePattern |
| class | CellFormatPageProtection |
| class | CellFormatDialog |
| Dialog for the "Cell Format..." action. More... | |
| class | ListDialog |
| class | PaperLayout |
| class | PasteInsertDialog |
| class | parameterLocale |
| class | configure |
| class | miscParameters |
| class | colorParameters |
| class | configureLayoutPage |
| class | configureSpellPage |
| class | configureTTSPage |
| class | PreferenceDialog |
| class | reference |
| class | EditAreaName |
| class | ResizeRow |
| class | ResizeColumn |
| class | SeriesDlg |
| class | ShowDialog |
| class | ShowColRow |
| class | SortDialog |
| class | SpecialDialog |
| class | StyleWidget |
| class | StyleDlg |
| class | SubtotalDialog |
| class | DlgValidity |
| class | LinkDialog |
| class | SheetPropertiesDialog |
| class | Token |
| Token. More... | |
| class | Tokens |
| Class Tokens represents array of tokens. More... | |
| class | Formula |
| Class Formula encapsulates a formula for a cell. More... | |
| struct | rangeInfo |
| struct | FuncExtra |
| class | Function |
| class | FunctionParameter |
| class | FunctionDescription |
| class | FunctionRepository |
| class | KSPLoadingInfo |
| Temporary information used only during loading. More... | |
| class | AutoFillSequenceItem |
| class | AutoFillSequence |
| class | AutoFillDeltaSequence |
| class | Canvas |
| The canvas builds a part of the GUI of KSpread. More... | |
| class | HBorder |
| HBorder. More... | |
| class | VBorder |
| VBorder. More... | |
| class | ToolTip |
| Tooltip, which displays the comment and cell content, when it's too short. More... | |
| struct | Validity |
| class | Cell |
| For every cell in the spread sheet there is a Cell object. More... | |
| class | Cluster |
| Philipp This class defines a pointer map to all cells, which makes access to them more performant and additionally limits memory consumption. More... | |
| class | ColumnCluster |
| class | RowCluster |
| class | Conditional |
| Structure to indicate the condition we're testing on a cell and the special font and color that will be applied if it's true. More... | |
| class | Conditions |
| Manages a set of conditions for a cell. More... | |
| struct | Reference |
| class | Plugin |
| class | Doc |
| This class holds the data that makes up a spreadsheet. More... | |
| class | FormulaEditorHighlighter |
| Colours cell references in formulas. More... | |
| class | FunctionCompletion |
| Provides autocompletition facilities in formula editors. More... | |
| class | CellEditor |
| class CellEditor More... | |
| class | ComboboxLocationEditWidget |
| ComboboxLocationEditWidget. More... | |
| class | LocationEditWidget |
| A widget that allows the user to enter an arbitrary cell location to goto or cell selection to highlight. More... | |
| class | EditWidget |
| The widget that appears above the sheet and allows to edit the cells content. More... | |
| class | SelectionChanged |
| class | Factory |
| class | Format |
| class | RowFormat |
| class | ColumnFormat |
| class | Currency |
| class | GeneralProperty |
| class | GenValidationStyles |
| class | GenValidationStyle |
| class | ElapsedTime |
| class | InsertHandler |
| This event handler is used to insert a new part. More... | |
| class | InsertPartHandler |
| class | InsertChartHandler |
| class | InsertPictureHandler |
| class | Locale |
| class | Map |
| A map is a simple container for all sheets. More... | |
| class | EmbeddedObject |
| Contains basic information for every object. More... | |
| class | EmbeddedKOfficeObject |
| Holds an embedded koffice object. More... | |
| class | EmbeddedChart |
| Holds an embedded chart object. More... | |
| class | EmbeddedPictureObject |
| Holds a picture object. More... | |
| class | PropertyEditor |
| class | CellBinding |
| This is an abstract base class only. More... | |
| class | ChartBinding |
| class | TextDrag |
| This is a class for handling clipboard data. More... | |
| class | Sheet |
| class | SheetPrint |
| class | PrintNewPageEntry |
| class | PrintObject |
| class | Style |
| The Style class represents a cell style. More... | |
| class | CustomStyle |
| Built-in or custom style defined in StyleManager dialog. More... | |
| class | StyleManager |
| class | ToolBox |
| class | KoTransformToolBox |
| class | Coordinate |
| class | Selection |
| struct | rowSize |
| struct | columnSize |
| struct | textOfCell |
| struct | layoutTextCell |
| struct | layoutCell |
| struct | layoutColumn |
| struct | layoutRow |
| struct | styleCell |
| class | FormulaOfCell |
| class | UndoAction |
| Abstract base class. More... | |
| class | MacroUndoAction |
| class | UndoInsertRemoveAction |
| class | UndoRemoveColumn |
| class | UndoInsertColumn |
| class | UndoRemoveRow |
| class | UndoInsertRow |
| class | UndoHideColumn |
| class | UndoHideRow |
| class | UndoShowColumn |
| class | UndoShowRow |
| class | UndoPaperLayout |
| class | UndoSetText |
| class | UndoCellFormat |
| class | UndoChangeAngle |
| class | UndoDelete |
| class | UndoDragDrop |
| class | UndoResizeColRow |
| class | UndoChangeAreaTextCell |
| class | UndoSort |
| class | UndoMergedCell |
| class | UndoAutofill |
| class | UndoInsertCellCol |
| class | UndoInsertCellRow |
| class | UndoRemoveCellCol |
| class | UndoRemoveCellRow |
| class | UndoConditional |
| class | UndoCellPaste |
| class | UndoStyleCell |
| class | UndoInsertData |
| class | Undo |
| class | Point |
| Represents the position of a single cell in a workbook. More... | |
| class | Range |
| Represents a region within a workbook. More... | |
| struct | RangeList |
| range-list and cell-list TODO: move to a separate file, improve structure, add iterators and all that TODO: use this class instead of other means of range-walking all over KSpread TODO: use this as selection TODO: anything I forgot ;) More... | |
| class | RangeIterator |
| RangeIterator. More... | |
| class | Value |
| Provides a wrapper for cell value. More... | |
| class | KPSheetSelectPage |
| Print dialog page for selecting sheets to print. More... | |
| class | View |
| The View class displays a KSpread document. More... | |
| class | AppIface |
| class | CellIface |
| class | ColumnIface |
| class | DocIface |
| class | LayoutIface |
| class | MapIface |
| class | RowIface |
| class | SheetIface |
| class | ViewIface |
| class | KSPRSavingInfo |
| Temporary information used only during saving. More... | |
| class | Manipulator |
| Manipulator. More... | |
| class | FormatManipulator |
| FormatManipulator. More... | |
| class | ResizeColumnManipulator |
| ResizeColumnManipulator. More... | |
| class | ResizeRowManipulator |
| ResizeRowManipulator. More... | |
| class | BorderManipulator |
| BorderManipulator. More... | |
| class | BackgroundColorManipulator |
| class BackgroundColorManipulator More... | |
| class | FontColorManipulator |
| class FontColorManipulator More... | |
| class | FontManipulator |
| class FontManipulator More... | |
| class | AngleManipulator |
| class AngleManipulator More... | |
| class | HorAlignManipulator |
| class HorAlignManipulator More... | |
| class | VerAlignManipulator |
| class VerAlignManipulator More... | |
| class | MergeManipulator |
| MergeManipulator. More... | |
| class | DilationManipulator |
| DilationManipulator. More... | |
| class | AdjustColumnRowManipulator |
| AdjustColumnRowManipulator. More... | |
| class | HideShowManipulator |
| HideShowManipulator. More... | |
| class | InsertDeleteManipulator |
| InsertDeleteManipulator. More... | |
| class | ManipulatorManager |
| ManipulatorManager. More... | |
| struct | ADMStorage |
| AbstractDataManipulator - provides storage of old cell data (for undo) and has an abstract method for the actual setting of new values. More... | |
| class | AbstractDataManipulator |
| class | DataManipulator |
| DataManipulator - allows setting values on one range. More... | |
| class | ArrayFormulaManipulator |
| class | ProtectedCheck |
| class ProtectedCheck can be used to check, whether a particular range is protected or not More... | |
| class | InsertCalendarDialog |
| class | PluginInsertCalendar |
| class | Region |
| The one for all class for points and ranges. More... | |
| struct | Condition |
| class | ValueCalc |
| The ValueCalc class is used to perform all sorts of calculations. More... | |
| class | ValueConverter |
| The ValueConverter class can convert Value between various different formats. More... | |
| class | ValueFormatter |
| The ValueFormatter class generates a textual representation of data stored in a Value, with a given formatting. More... | |
| class | ValueParser |
| The ValueParser parses a text input from the user, generating Value in the desired format. More... | |
Namespaces | |
| namespace | Action |
| namespace | Oasis |
| namespace | Paste |
| namespace | Restriction |
Typedefs | |
| typedef QValueVector< Value > | valVector |
| typedef Value(*) | FunctionPtr (valVector, ValueCalc *, FuncExtra *) |
| typedef Column unsigned long | int |
| typedef Row unsigned long | int |
| typedef KGenericFactory< PluginInsertCalendar > | InsertCalendarFactory |
| typedef QValueList< Condition > | ConditionList |
| typedef void(*) | arrayWalkFunc (ValueCalc *, Value &result, Value val, Value param) |
Enumerations | |
| enum | BorderType { BorderType_Top = 0, BorderType_Bottom, BorderType_Left, BorderType_Right, BorderType_Vertical, BorderType_Horizontal, BorderType_FallingDiagonal, BorderType_RisingDiagonal, BorderType_END } |
| enum | BorderShortcutType { BorderShortcutType_Remove = 0, BorderShortcutType_All, BorderShortcutType_Outline, BorderShortcutType_END } |
| enum | ParameterType { KSpread_Int, KSpread_Float, KSpread_String, KSpread_Boolean, KSpread_Any } |
| enum | Series { Column, Row, Linear, Geometric } |
| enum | MoveTo { Bottom, Left, Top, Right, BottomFirst } |
| enum | MethodOfCalc { SumOfNumber, Min, Max, Average, Count, NoneCalc, CountA } |
| enum | FormatType { Generic_format = 0, Number_format = 1, Text_format = 5, Money_format = 10, Percentage_format = 25, Scientific_format = 30, ShortDate_format = 35, TextDate_format = 36, Time_format = 50, SecondeTime_format = 51, Time_format1 = 52, Time_format2 = 53, Time_format3 = 54, Time_format4 = 55, Time_format5 = 56, Time_format6 = 57, Time_format7 = 58, Time_format8 = 59, fraction_half = 70, fraction_quarter = 71, fraction_eighth = 72, fraction_sixteenth = 73, fraction_tenth = 74, fraction_hundredth = 75, fraction_one_digit = 76, fraction_two_digits = 77, fraction_three_digits = 78, date_format1 = 200, date_format2 = 201, date_format3 = 202, date_format4 = 203, date_format5 = 204, date_format6 = 205, date_format7 = 206, date_format8 = 207, date_format9 = 208, date_format10 = 209, date_format11 = 210, date_format12 = 211, date_format13 = 212, date_format14 = 213, date_format15 = 214, date_format16 = 215, date_format17 = 216, date_format18 = 217, date_format19 = 218, date_format20 = 219, date_format21 = 220, date_format22 = 221, date_format23 = 222, date_format24 = 223, date_format25 = 224, date_format26 = 225, Custom_format = 300, No_format = 400 } |
| enum | ModifyType { MT_NONE = 0, MT_MOVE, MT_RESIZE_UP, MT_RESIZE_DN, MT_RESIZE_LF, MT_RESIZE_RT, MT_RESIZE_LU, MT_RESIZE_LD, MT_RESIZE_RU, MT_RESIZE_RD } |
| enum | PropValue { STATE_ON = 0, STATE_OFF = 1, STATE_UNDEF = 2 } |
| enum | ToolEditMode { TEM_MOUSE = 0, INS_OBJECT = 5, INS_DIAGRAMM = 7, INS_PICTURE = 16 } |
| enum | ObjType { OBJECT_GENERAL, OBJECT_KOFFICE_PART, OBJECT_CHART, OBJECT_PICTURE } |
| enum | SelectionMode { SM_NONE = 0, SM_MOVERESIZE = 1, SM_ROTATE = 2, SM_PROTECT = 3 } |
| enum | PictureMirrorType { PM_NORMAL = 0, PM_HORIZONTAL = 1, PM_VERTICAL = 2, PM_HORIZONTALANDVERTICAL = 3 } |
| enum | ImageEffect { IE_NONE = -1, IE_CHANNEL_INTENSITY = 0, IE_FADE = 1, IE_FLATTEN = 2, IE_INTENSITY = 3, IE_DESATURATE = 4, IE_CONTRAST = 5, IE_NORMALIZE = 6, IE_EQUALIZE = 7, IE_THRESHOLD = 8, IE_SOLARIZE = 9, IE_EMBOSS = 10, IE_DESPECKLE = 11, IE_CHARCOAL = 12, IE_NOISE = 13, IE_BLUR = 14, IE_EDGE = 15, IE_IMPLODE = 16, IE_OIL_PAINT = 17, IE_SHARPEN = 18, IE_SPREAD = 19, IE_SHADE = 20, IE_SWIRL = 21, IE_WAVE = 22 } |
| enum | AlignType { AT_PAGE, AT_CELL } |
| enum | Comp { isEqual, isLess, isGreater, lessEqual, greaterEqual, notEqual } |
| enum | Type { numeric, string } |
Functions | |
| Token::Op | matchOperator (const QString &text) |
| bool | isIdentifier (QChar ch) |
| QTextStream & | operator<< (QTextStream &ts, Formula formula) |
| KAboutData * | newAboutData () |
| int | daysPerYear (QDate const &date, int basis) |
| int | daysBetweenDates (QDate const &date1, QDate const &date2, int basis) |
| static QString | cellAsText (Cell *cell, unsigned int max) |
| bool | formatIsDate (FormatType fmt) |
| bool | formatIsTime (FormatType fmt) |
| bool | formatIsFraction (FormatType fmt) |
| int | util_decodeColumnLabelText (const QString &_col) |
| QString | util_rangeColumnName (const QRect &_area) |
| QString | util_rangeRowName (const QRect &_area) |
| QString | util_rangeName (const QRect &_area) |
| QString | util_rangeName (Sheet *_sheet, const QRect &_area) |
| QDomElement | util_createElement (const QString &tagName, const QFont &font, QDomDocument &doc) |
| QDomElement | util_createElement (const QString &tagname, const QPen &pen, QDomDocument &doc) |
| QFont | util_toFont (QDomElement &element) |
| QPen | util_toPen (QDomElement &element) |
| bool | util_isAllSelected (const QRect &selection) |
| bool | util_isColumnSelected (const QRect &selection) |
| bool | util_isRowSelected (const QRect &selection) |
| bool | util_isRowOrColumnSelected (const QRect &selection) |
| bool | util_validateSheetName (const QString &name) |
| int | util_penCompare (QPen const &pen1, QPen const &pen2) |
| QString | convertRefToBase (const QString &sheet, const QRect &rect) |
| QString | convertRefToRange (const QString &sheet, const QRect &rect) |
| void | insertBracket (QString &s) |
| QString | convertRangeToRef (const QString &sheetName, const QRect &_area) |
| QString | convertOasisPenToString (const QPen &pen) |
| QPen | convertOasisStringToPen (const QString &border) |
| bool | localReferenceAnchor (const QString &_ref) |
| KSPREAD_EXPORT QString | util_encodeColumnLabelText (int column) |
| K_EXPORT_COMPONENT_FACTORY (libkspreadinsertcalendar, InsertCalendarFactory("kspreadinsertcalendar")) PluginInsertCalendar | |
Variables | |
| static const char * | description = I18N_NOOP("KOffice Spreadsheet Application") |
| static const char * | version = KOFFICE_VERSION_STRING |
Function Documentation
| bool KSpread::isIdentifier | ( | QChar | ch | ) |
helper function: return true for valid identifier character
Definition at line 356 of file formula.cc.
| Token::Op KSpread::matchOperator | ( | const QString & | text | ) |
helper function: return operator of given token text e.g.
"*" yields Operator::Asterisk, and so on
Definition at line 130 of file formula.cc.
| QTextStream& KSpread::operator<< | ( | QTextStream & | ts, | |
| Formula | formula | |||
| ) |
Dumps the formula, should be used only to assist debugging.
Definition at line 1531 of file formula.cc.
| KSPREAD_EXPORT int KSpread::util_decodeColumnLabelText | ( | const QString & | _col | ) |
Call this function to decode the text of a column label to an integer i.e.
AA->27
Definition at line 57 of file kspread_util.cc.
| KSPREAD_EXPORT QString KSpread::util_encodeColumnLabelText | ( | int | column | ) |
Call this function to encode an integer to the text of the column label i.e.
27->AA
