summaryrefslogtreecommitdiffstats
path: root/sc/README.md
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-07 09:06:44 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-07 09:06:44 +0000
commited5640d8b587fbcfed7dd7967f3de04b37a76f26 (patch)
tree7a5f7c6c9d02226d7471cb3cc8fbbf631b415303 /sc/README.md
parentInitial commit. (diff)
downloadlibreoffice-ed5640d8b587fbcfed7dd7967f3de04b37a76f26.tar.xz
libreoffice-ed5640d8b587fbcfed7dd7967f3de04b37a76f26.zip
Adding upstream version 4:7.4.7.upstream/4%7.4.7upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'sc/README.md')
-rw-r--r--sc/README.md86
1 files changed, 86 insertions, 0 deletions
diff --git a/sc/README.md b/sc/README.md
new file mode 100644
index 000000000..b28b1b769
--- /dev/null
+++ b/sc/README.md
@@ -0,0 +1,86 @@
+# Spreadsheet Application Code
+
+You can dump some information in a dbgutil build:
+
+## Shortcuts
+
+### 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+F6
+
+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
+