blob: fdee3df23ee3e45a8ba309db83d0a056e357eb1b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
|
Spreadsheet application code.
You can dump some information in a dbgutil build:
=== CTRL+SHIFT+F12 ===
Dumps the column width of the first 20 columns.
=== CTRL+SHIFT+F11 ===
Dumps the graphic objects and their position and size in pixel.
=== CTRL+SHIFT+F9 ===
Dumps the SfxItemSet representing the cell properties' of the
current selection as a xml file. The file will be named dump.xml
=== The Cache Format ===
ScDocument::StoreTabToCache allows storing the content (not the formatting)
of a table to a binary cache format.
The format is column orientated which allows quick serialization of the table.
Header:
* Number of Columns: 64 bit unsigned integer
Column:
* Column Index: 64 bit unsigned integer
* Column Size: 64 bit unsigned integer
* For each cell type block a new ColumnBlock
ColumnBlock:
* Start Row: 64 bit unsigned integer
* Block Size: 64 bit unsigned integer
* Type: 8 bit unsigned integer
- 0 : empty
- 1 : numeric
* for each cell: 64 bit IEEE 754 double precision value
- 2 : string
* for each cell: 32 bit signed string length followed by string length bytes of the string (UTF-8)
- 3 : formula
* for each cell: 32 bit signed string length followed by the formula in R1C1 notation as a string
=== Functions supporting Wildcards or Regular Expressions ===
As this comes up every now and then, and rather should be documented in an
extra list of the Help system, functions that support Wildcards or Regular
Expressions *and* depend on the setting under
Tools -> Options -> Calc -> Calculate are those that in ODF OpenFormula (ODFF)
are defined to depend on the HOST-USE-REGULAR-EXPRESSIONS or HOST-USE-WILDCARDS
properties, see
https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html
* Database Functions
* DAVERAGE
* DCOUNT
* DCOUNTA
* DGET
* DMAX
* DMIN
* DPRODUCT
* DSTDEV
* DSTDEVP
* DSUM
* DVAR
* DVARP
* Information Functions
* COUNTIF
* COUNTIFS
* Lookup Functions
* HLOOKUP
* LOOKUP
* MATCH
* VLOOKUP
* Mathematical Functions
* SUMIF
* SUMIFS
* Statistical Functions
* AVERAGEIF
* AVERAGEIFS
* Text Functions
* SEARCH
|
