diff options
Diffstat (limited to 'sc/README.md')
| -rw-r--r-- | sc/README.md | 22 |
1 files changed, 12 insertions, 10 deletions
diff --git a/sc/README.md b/sc/README.md index e355e0c3c612..b28b1b769c71 100644 --- a/sc/README.md +++ b/sc/README.md @@ -1,36 +1,38 @@ -Spreadsheet application code. +# Spreadsheet Application Code You can dump some information in a dbgutil build: -=== CTRL+SHIFT+F12 === +## Shortcuts + +### CTRL+SHIFT+F12 Dumps the column width of the first 20 columns. -=== CTRL+SHIFT+F11 === +### CTRL+SHIFT+F11 Dumps the graphic objects and their position and size in pixel. -=== CTRL+SHIFT+F6 === +### 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 === +## 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: +* Header: * Number of Columns: 64 bit unsigned integer -Column: +* Column: * Column Index: 64 bit unsigned integer * Column Size: 64 bit unsigned integer * For each cell type block a new ColumnBlock -ColumnBlock: +* ColumnBlock: * Start Row: 64 bit unsigned integer * Block Size: 64 bit unsigned integer * Type: 8 bit unsigned integer @@ -42,8 +44,7 @@ ColumnBlock: - 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 === +## 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 @@ -82,3 +83,4 @@ https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html * AVERAGEIFS * Text Functions * SEARCH + |