Skip to content

Files

sc

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
May 7, 2025
May 2, 2025
Mar 19, 2024
Mar 31, 2025
May 7, 2025
Apr 22, 2025
Mar 5, 2024
Feb 2, 2025
Jul 21, 2017
Feb 24, 2024
Nov 14, 2022
Oct 18, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 14, 2022
Nov 7, 2022
Nov 7, 2022
Mar 29, 2025
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 16, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Mar 29, 2025
Nov 7, 2022
Jun 14, 2024
Nov 7, 2022
Nov 14, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Mar 29, 2025
Nov 14, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Feb 7, 2024
Nov 7, 2022
Mar 29, 2025
Nov 14, 2022
Nov 7, 2022
Nov 11, 2022
Nov 14, 2022
Jun 14, 2024
Nov 7, 2022
Nov 7, 2022
Jun 9, 2023
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 14, 2022
Oct 26, 2022
Nov 7, 2022
Nov 7, 2022
Nov 14, 2022
Oct 26, 2022
Mar 29, 2025
Nov 14, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Jan 27, 2023
Jan 27, 2023
Nov 7, 2022
Mar 29, 2024
Nov 11, 2022
Dec 22, 2021
Nov 15, 2022
Apr 12, 2024
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Sep 28, 2023
Oct 10, 2024
Nov 7, 2022
Nov 16, 2022
Nov 7, 2022
Nov 7, 2022
Sep 27, 2024
Nov 7, 2022
Aug 2, 2023
Nov 14, 2022
Nov 7, 2022
Nov 7, 2022
Nov 14, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Sep 1, 2021
Sep 1, 2021
Mar 1, 2023
Mar 2, 2023
Sep 1, 2021
Sep 1, 2021
Feb 28, 2023
Mar 1, 2023
Sep 19, 2024
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 7, 2022
Nov 14, 2022
Jun 29, 2023
Apr 14, 2025
Apr 14, 2025
May 17, 2021
May 16, 2021
May 17, 2021
Nov 18, 2022
Jul 13, 2023
May 17, 2021
Nov 28, 2024
Nov 28, 2024
Nov 18, 2022
May 14, 2021
Nov 18, 2022
Nov 18, 2022
May 14, 2021
Mar 25, 2023
May 14, 2021
Aug 2, 2023
Nov 16, 2022
Dec 22, 2023
Nov 7, 2022
Nov 7, 2022
Sep 28, 2023
Nov 7, 2022
Apr 27, 2025
Nov 9, 2018
Nov 9, 2018
Nov 9, 2018
Nov 9, 2018
Nov 9, 2018
Nov 9, 2018
Nov 9, 2018
Dec 3, 2024
Dec 10, 2021
Mar 8, 2025
Apr 14, 2025
Mar 5, 2024
Apr 20, 2024
Dec 4, 2012
Dec 22, 2024
Jul 12, 2016
Sep 17, 2016
May 29, 2017
Feb 4, 2025
Sep 27, 2024
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Oct 19, 2023
Oct 19, 2023
Oct 19, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Oct 19, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 6, 2023
Nov 11, 2022
Sep 28, 2023
Sep 14, 2023
May 9, 2023

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 ODF v1.3 part4 3.4 Host-Defined Behaviors https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#__RefHeading__1017868_715980110

  • Array Functions
    • CHOOSECOLS
    • CHOOSEROWS
    • DROP
    • EXPAND
    • HSTACK
    • VSTACK
    • TAKE
    • TOCOL
    • TOROW
    • WRAPCOLS
    • WRAPROWS
  • Database Functions
    • DAVERAGE
    • DCOUNT
    • DCOUNTA
    • DGET
    • DMAX
    • DMIN
    • DPRODUCT
    • DSTDEV
    • DSTDEVP
    • DSUM
    • DVAR
    • DVARP
  • Information Functions
    • COUNTIF
    • COUNTIFS
  • Lambda Functions
    • LET
  • Lookup Functions
    • HLOOKUP
    • LOOKUP
    • MATCH
    • XMATCH
    • VLOOKUP
    • XLOOKUP
    • FILTER
    • SORT
    • SORTBY
    • UNIQUE
  • Mathematical Functions
    • RANDARRAY
    • SEQUENCE
    • SUMIF
    • SUMIFS
  • Statistical Functions
    • AVERAGEIF
    • AVERAGEIFS
  • Text Functions
    • SEARCH