From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- sc/README.md | 86 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 86 insertions(+) create mode 100644 sc/README.md (limited to 'sc/README.md') 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 + -- cgit v1.2.3