kspread

Namespaces | Classes | Typedefs | Enumerations | Functions | Variables
KSpread Namespace Reference

Namespaces

namespace  Paste
namespace  Restriction

Classes

class  UndoWrapperCommand
class  MergeCellCommand
class  DissociateCellCommand
class  RenameSheetCommand
class  SheetPropertiesCommand
struct  RangeDependency
class  DependencyManager
class  CSVDialog
class  FormatDialog
class  CellFormatPageFloat
class  CellFormatDialog
class  Token
class  Tokens
class  Formula
class  KSPLoadingInfo
class  Canvas
class  HBorder
class  VBorder
class  ToolTip
class  Cell
class  Cluster
class  Conditional
class  Conditions
class  Doc
class  FormulaEditorHighlighter
class  FunctionCompletion
class  CellEditor
class  ComboboxLocationEditWidget
class  LocationEditWidget
class  EditWidget
class  InsertHandler
class  Map
class  EmbeddedObject
class  EmbeddedKOfficeObject
class  EmbeddedChart
class  EmbeddedPictureObject
class  CellBinding
class  TextDrag
class  Style
class  CustomStyle
class  UndoAction
class  Point
class  Range
struct  RangeList
class  RangeIterator
class  Value
class  KPSheetSelectPage
class  View
class  KSPRSavingInfo
class  Manipulator
class  FormatManipulator
class  ResizeColumnManipulator
class  ResizeRowManipulator
class  BorderManipulator
class  BackgroundColorManipulator
class  FontColorManipulator
class  FontManipulator
class  AngleManipulator
class  HorAlignManipulator
class  VerAlignManipulator
class  MergeManipulator
class  DilationManipulator
class  AdjustColumnRowManipulator
class  HideShowManipulator
class  InsertDeleteManipulator
class  ManipulatorManager
struct  ADMStorage
class  DataManipulator
class  ProtectedCheck
class  Region
class  ValueCalc
class  ValueConverter
class  ValueFormatter
class  ValueParser

Typedefs

typedef TQValueVector< Value > valVector
typedef Value(* FunctionPtr) (valVector, ValueCalc *, FuncExtra *)
typedef Column unsigned long int
typedef KGenericFactory< PluginInsertCalendar > InsertCalendarFactory
typedef TQValueList< 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

TQTextStream & operator<< (TQTextStream &ts, Formula formula)
Token::Op matchOperator (const TQString &text)
bool isIdentifier (TQChar ch)
TDEAboutData * newAboutData ()
int daysPerYear (TQDate const &date, int basis)
int daysBetweenDates (TQDate const &date1, TQDate const &date2, int basis)
static TQString cellAsText (Cell *cell, unsigned int max)
bool formatIsDate (FormatType fmt)
bool formatIsTime (FormatType fmt)
bool formatIsFraction (FormatType fmt)
KSPREAD_EXPORT TQString util_rangeName (const TQRect &_area)
KSPREAD_EXPORT TQString util_rangeName (Sheet *_sheet, const TQRect &_area)
TQString util_rangeColumnName (const TQRect &_area)
TQString util_rangeRowName (const TQRect &_area)
KSPREAD_EXPORT int util_decodeColumnLabelText (const TQString &_col)
KSPREAD_EXPORT TQString util_encodeColumnLabelText (int column)
bool util_isAllSelected (const TQRect &selection)
bool util_isColumnSelected (const TQRect &selection)
bool util_isRowSelected (const TQRect &selection)
bool util_isRowOrColumnSelected (const TQRect &selection)
bool util_validateSheetName (const TQString &name)
TQDomElement util_createElement (const TQString &tagName, const TQFont &font, TQDomDocument &doc)
TQDomElement util_createElement (const TQString &tagname, const TQPen &pen, TQDomDocument &doc)
TQFont util_toFont (TQDomElement &element)
TQPen util_toPen (TQDomElement &element)
int util_penCompare (TQPen const &pen1, TQPen const &pen2)
TQString convertRefToRange (const TQString &sheet, const TQRect &rect)
TQString convertRefToBase (const TQString &sheet, const TQRect &rect)
TQString convertRangeToRef (const TQString &sheetName, const TQRect &_area)
void insertBracket (TQString &s)
TQString convertOasisPenToString (const TQPen &pen)
TQPen convertOasisStringToPen (const TQString &str)
KSPREAD_EXPORT bool localReferenceAnchor (const TQString &_ref)

Variables

static const char * description =I18N_NOOP("KOffice Spreadsheet Application")
static const char * version =KOFFICE_VERSION_STRING

Detailed Description

The KSpread namespace.

Typedef Documentation

◆ arrayWalkFunc

typedef void(* KSpread::arrayWalkFunc) (ValueCalc *, Value &result, Value val, Value param)

Definition at line 51 of file valuecalc.h.

◆ ConditionList

typedef TQValueList<Condition> KSpread::ConditionList

Definition at line 49 of file valuecalc.h.

◆ FunctionPtr

typedef Value(* KSpread::FunctionPtr) (valVector, ValueCalc *, FuncExtra *)

Definition at line 48 of file functions.h.

◆ InsertCalendarFactory

typedef KGenericFactory<PluginInsertCalendar> KSpread::InsertCalendarFactory

Definition at line 49 of file kspread_plugininsertcalendar.cpp.

◆ int

typedef Row unsigned long KSpread::int

Definition at line 14 of file kspread_types.h.

◆ valVector

typedef TQValueVector<Value> KSpread::valVector

Definition at line 36 of file functions.h.

Enumeration Type Documentation

◆ AlignType

enum KSpread::AlignType

Definition at line 100 of file kspread_object.h.

◆ BorderShortcutType

enum KSpread::BorderShortcutType

Definition at line 89 of file kspread_dlg_layout.h.

◆ BorderType

enum KSpread::BorderType

Definition at line 76 of file kspread_dlg_layout.h.

◆ Comp

enum KSpread::Comp

Definition at line 37 of file valuecalc.h.

◆ FormatType

enum KSpread::FormatType

Definition at line 131 of file kspread_global.h.

◆ ImageEffect

enum KSpread::ImageEffect

Definition at line 73 of file kspread_object.h.

◆ MethodOfCalc

enum KSpread::MethodOfCalc

Definition at line 129 of file kspread_global.h.

◆ ModifyType

enum KSpread::ModifyType

Definition at line 152 of file kspread_global.h.

◆ MoveTo

enum KSpread::MoveTo

Definition at line 128 of file kspread_global.h.

◆ ObjType

enum KSpread::ObjType

Definition at line 52 of file kspread_object.h.

◆ ParameterType

enum KSpread::ParameterType

Definition at line 79 of file functions.h.

◆ PictureMirrorType

enum KSpread::PictureMirrorType

Definition at line 66 of file kspread_object.h.

◆ PropValue

enum KSpread::PropValue

Definition at line 165 of file kspread_global.h.

◆ SelectionMode

enum KSpread::SelectionMode

Definition at line 59 of file kspread_object.h.

◆ Series

enum KSpread::Series

Definition at line 126 of file kspread_global.h.

◆ ToolEditMode

enum KSpread::ToolEditMode

Definition at line 172 of file kspread_global.h.

◆ Type

enum KSpread::Type

Definition at line 38 of file valuecalc.h.

Function Documentation

◆ cellAsText()

TQString KSpread::cellAsText ( Cell * cell,
unsigned int max )
static

Definition at line 4981 of file kspread_sheet.cpp.

◆ convertOasisPenToString()

TQString KSpread::convertOasisPenToString ( const TQPen & pen)

Definition at line 926 of file kspread_util.cpp.

◆ convertOasisStringToPen()

TQPen KSpread::convertOasisStringToPen ( const TQString & str)

Definition at line 967 of file kspread_util.cpp.

◆ convertRangeToRef()

TQString KSpread::convertRangeToRef ( const TQString & sheetName,
const TQRect & _area )

Definition at line 921 of file kspread_util.cpp.

◆ convertRefToBase()

TQString KSpread::convertRefToBase ( const TQString & sheet,
const TQRect & rect )

Definition at line 862 of file kspread_util.cpp.

◆ convertRefToRange()

TQString KSpread::convertRefToRange ( const TQString & sheet,
const TQRect & rect )

Definition at line 876 of file kspread_util.cpp.

◆ daysBetweenDates()

int KSpread::daysBetweenDates ( TQDate const & date1,
TQDate const & date2,
int basis )

Definition at line 89 of file kspread_functions_helper.cpp.

◆ daysPerYear()

int KSpread::daysPerYear ( TQDate const & date,
int basis )

Definition at line 66 of file kspread_functions_helper.cpp.

◆ formatIsDate()

bool KSpread::formatIsDate ( FormatType fmt)

Definition at line 38 of file kspread_util.cpp.

◆ formatIsFraction()

bool KSpread::formatIsFraction ( FormatType fmt)

Definition at line 49 of file kspread_util.cpp.

◆ formatIsTime()

bool KSpread::formatIsTime ( FormatType fmt)

Definition at line 44 of file kspread_util.cpp.

◆ insertBracket()

void KSpread::insertBracket ( TQString & s)

Definition at line 899 of file kspread_util.cpp.

◆ isIdentifier()

bool KSpread::isIdentifier ( TQChar ch)

helper function: return true for valid identifier character

Definition at line 356 of file formula.cpp.

◆ localReferenceAnchor()

bool KSpread::localReferenceAnchor ( const TQString & _ref)

Definition at line 1008 of file kspread_util.cpp.

◆ matchOperator()

Token::Op KSpread::matchOperator ( const TQString & text)

helper function: return operator of given token text e.g.

"*" yields Operator::Asterisk, and so on

Definition at line 130 of file formula.cpp.

◆ newAboutData()

TDEAboutData * KSpread::newAboutData ( )

Definition at line 35 of file kspread_aboutdata.h.

◆ operator<<()

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

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

◆ util_createElement() [1/2]

TQDomElement KSpread::util_createElement ( const TQString & tagName,
const TQFont & font,
TQDomDocument & doc )

Definition at line 102 of file kspread_util.cpp.

◆ util_createElement() [2/2]

TQDomElement KSpread::util_createElement ( const TQString & tagname,
const TQPen & pen,
TQDomDocument & doc )

Definition at line 122 of file kspread_util.cpp.

◆ util_decodeColumnLabelText()

int KSpread::util_decodeColumnLabelText ( const TQString & _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.cpp.

◆ util_encodeColumnLabelText()

KSPREAD_EXPORT TQString KSpread::util_encodeColumnLabelText ( int column)

Call this function to encode an integer to the text of the column label i.e.

27->AA

◆ util_isAllSelected()

bool KSpread::util_isAllSelected ( const TQRect & selection)

Definition at line 737 of file kspread_util.cpp.

◆ util_isColumnSelected()

bool KSpread::util_isColumnSelected ( const TQRect & selection)

Definition at line 743 of file kspread_util.cpp.

◆ util_isRowOrColumnSelected()

bool KSpread::util_isRowOrColumnSelected ( const TQRect & selection)

Definition at line 753 of file kspread_util.cpp.

◆ util_isRowSelected()

bool KSpread::util_isRowSelected ( const TQRect & selection)

Definition at line 748 of file kspread_util.cpp.

◆ util_penCompare()

int KSpread::util_penCompare ( TQPen const & pen1,
TQPen const & pen2 )

Definition at line 829 of file kspread_util.cpp.

◆ util_rangeColumnName()

TQString KSpread::util_rangeColumnName ( const TQRect & _area)

Definition at line 76 of file kspread_util.cpp.

◆ util_rangeName() [1/2]

TQString KSpread::util_rangeName ( const TQRect & _area)

Definition at line 91 of file kspread_util.cpp.

◆ util_rangeName() [2/2]

TQString KSpread::util_rangeName ( Sheet * _sheet,
const TQRect & _area )

Definition at line 97 of file kspread_util.cpp.

◆ util_rangeRowName()

TQString KSpread::util_rangeRowName ( const TQRect & _area)

Definition at line 84 of file kspread_util.cpp.

◆ util_toFont()

TQFont KSpread::util_toFont ( TQDomElement & element)

Definition at line 131 of file kspread_util.cpp.

◆ util_toPen()

TQPen KSpread::util_toPen ( TQDomElement & element)

Definition at line 169 of file kspread_util.cpp.

◆ util_validateSheetName()

bool KSpread::util_validateSheetName ( const TQString & name)

Definition at line 760 of file kspread_util.cpp.

Variable Documentation

◆ description

const char* KSpread::description =I18N_NOOP("KOffice Spreadsheet Application")
static

Definition at line 30 of file kspread_aboutdata.h.

◆ version

const char* KSpread::version =KOFFICE_VERSION_STRING
static

Definition at line 33 of file kspread_aboutdata.h.