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< ValuevalVector
typedef Value(*) FunctionPtr (valVector, ValueCalc *, FuncExtra *)
typedef Column unsigned long int
typedef Row unsigned long int
typedef KGenericFactory< PluginInsertCalendarInsertCalendarFactory
typedef QValueList< ConditionConditionList
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

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.

bool KSpread::isIdentifier ( QChar  ch  ) 

helper function: return true for valid identifier character

Definition at line 358 of file formula.cc.

QTextStream& KSpread::operator<< ( QTextStream &  ts,
Formula  formula 
)

Dumps the formula, should be used only to assist debugging.

Definition at line 1517 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

KDE Home | KDE Accessibility Home | Description of Access Keys