• Home
  • History
  • Annotate
Name Date Size #Lines LOC

..03-May-2022-

inc/H07-Oct-2020-54,46335,965

qa/H07-Oct-2020-1,943,8131,918,363

res/xml/H07-Oct-2020-6560

sdi/H07-Oct-2020-8,5977,220

source/H07-Oct-2020-736,357575,674

uiconfig/scalc/H07-Oct-2020-106,883105,588

util/H07-Oct-2020-285186

workben/H03-May-2022-291201

AllLangMoTarget_sc.mkH A D07-Oct-2020400 121

CppunitTest_sc_addin_functions_test.mkH A D07-Oct-20202.8 KiB12098

CppunitTest_sc_anchor_test.mkH A D07-Oct-20201.6 KiB7855

CppunitTest_sc_annotationobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_annotationshapeobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_annotationsobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_arealinkobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_arealinksobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_array_functions_test.mkH A D07-Oct-20202.8 KiB12098

CppunitTest_sc_autoformatobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_autoformatsobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_bugfix_test.mkH A D07-Oct-20202.8 KiB124102

CppunitTest_sc_cache_test.mkH A D07-Oct-20202.7 KiB123102

CppunitTest_sc_cellcursorobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_cellfieldsobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_cellformatsenumeration.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_cellformatsobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_cellobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_cellrangeobj.mkH A D07-Oct-20201.4 KiB4724

CppunitTest_sc_cellrangesobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_cellsearchobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_cellsenumeration.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_cellsobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_chart2dataprovider.mkH A D07-Oct-20202.9 KiB124102

CppunitTest_sc_chart_regression_test.mkH A D07-Oct-20202.7 KiB11695

CppunitTest_sc_chartobj.mkH A D07-Oct-20201.3 KiB4724

CppunitTest_sc_chartsobj.mkH A D07-Oct-20201.3 KiB4724

CppunitTest_sc_check_data_pilot_field.mkH A D07-Oct-20201.4 KiB4826

CppunitTest_sc_check_data_pilot_table.mkH A D07-Oct-20201.4 KiB4826

CppunitTest_sc_check_xcell_ranges_query.mkH A D07-Oct-20201.4 KiB4422

CppunitTest_sc_cond_format_merge.mkH A D07-Oct-20202.9 KiB124102

CppunitTest_sc_consolidationdescriptorobj.mkH A D07-Oct-20201.5 KiB4623

CppunitTest_sc_copypaste.mkH A D07-Oct-20202.7 KiB123101

CppunitTest_sc_core.mkH A D07-Oct-2020905 3820

CppunitTest_sc_database_functions_test.mkH A D07-Oct-20202.9 KiB12098

CppunitTest_sc_databaserangeobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_databaserangesobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_datapilotfieldgroupitemobj.mkH A D07-Oct-20201.6 KiB5026

CppunitTest_sc_datapilotfieldgroupobj.mkH A D07-Oct-20201.5 KiB5026

CppunitTest_sc_datapilotfieldgroupsobj.mkH A D07-Oct-20201.5 KiB5026

CppunitTest_sc_datapilotfieldobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_datapilotfieldsobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_datapilotitemobj.mkH A D07-Oct-20201.8 KiB7552

CppunitTest_sc_datapilotitemsobj.mkH A D07-Oct-20201.4 KiB5026

CppunitTest_sc_datapilottableobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_datapilottablesobj.mkH A D07-Oct-20202.5 KiB10986

CppunitTest_sc_dataprovider.mkH A D07-Oct-20203.4 KiB143120

CppunitTest_sc_datatransformation.mkH A D07-Oct-20203 KiB134111

CppunitTest_sc_datetime_functions_test.mkH A D07-Oct-20202.9 KiB12098

CppunitTest_sc_ddelinkobj.mkH A D07-Oct-20201.3 KiB4825

CppunitTest_sc_ddelinksobj.mkH A D07-Oct-20201.3 KiB4724

CppunitTest_sc_documentconfigurationobj.mkH A D07-Oct-20201.5 KiB4623

CppunitTest_sc_drawpageobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_drawpagesobj.mkH A D07-Oct-20201.3 KiB4724

CppunitTest_sc_editfieldobj_cell.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_editfieldobj_header.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_filterdescriptorbase.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_filters_test.mkH A D07-Oct-20202.8 KiB125103

CppunitTest_sc_financial_functions_test.mkH A D07-Oct-20202.9 KiB12098

CppunitTest_sc_functiondescriptionobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_functionlistobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_functions_test_old.mkH A D07-Oct-20202.8 KiB12098

CppunitTest_sc_headerfieldsobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_headerfootercontentobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_html_export_test.mkH A D07-Oct-20202.8 KiB11998

CppunitTest_sc_importdescriptorbaseobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_indexenumeration_cellannotationsenumeration.mkH A D07-Oct-20201.7 KiB4623

CppunitTest_sc_indexenumeration_cellarealinksenumeration.mkH A D07-Oct-20201.7 KiB4623

CppunitTest_sc_indexenumeration_databaserangesenumeration.mkH A D07-Oct-20201.7 KiB4623

CppunitTest_sc_indexenumeration_datapilotfieldsenumeration.mkH A D07-Oct-20201.7 KiB4623

CppunitTest_sc_indexenumeration_datapilotitemsenumeration.mkH A D07-Oct-20201.7 KiB4623

CppunitTest_sc_indexenumeration_datapilottablesenumeration.mkH A D07-Oct-20201.7 KiB4623

CppunitTest_sc_indexenumeration_ddelinksenumeration.mkH A D07-Oct-20201.6 KiB4623

CppunitTest_sc_indexenumeration_functiondescriptionenumeration.mkH A D07-Oct-20201.7 KiB4623

CppunitTest_sc_indexenumeration_labelrangesenumeration.mkH A D07-Oct-20201.6 KiB4623

CppunitTest_sc_indexenumeration_namedrangesenumeration.mkH A D07-Oct-20201.6 KiB4623

CppunitTest_sc_indexenumeration_scenariosenumeration.mkH A D07-Oct-20201.6 KiB4623

CppunitTest_sc_indexenumeration_sheetcellrangesenumeration.mkH A D07-Oct-20201.7 KiB4623

CppunitTest_sc_indexenumeration_sheetlinksenumeration.mkH A D07-Oct-20201.6 KiB4623

CppunitTest_sc_indexenumeration_spreadsheetsenumeration.mkH A D07-Oct-20201.6 KiB4623

CppunitTest_sc_indexenumeration_spreadsheetviewpanesenumeration.mkH A D07-Oct-20201.7 KiB4623

CppunitTest_sc_indexenumeration_subtotalfieldsenumeration.mkH A D07-Oct-20201.7 KiB4623

CppunitTest_sc_indexenumeration_tableautoformatenumeration.mkH A D07-Oct-20201.7 KiB4623

CppunitTest_sc_indexenumeration_tablechartsenumeration.mkH A D07-Oct-20201.7 KiB4824

CppunitTest_sc_indexenumeration_tablecolumnsenumeration.mkH A D07-Oct-20201.6 KiB4623

CppunitTest_sc_indexenumeration_tableconditionalentryenumeration.mkH A D07-Oct-20201.8 KiB4623

CppunitTest_sc_indexenumeration_tablerowsenumeration.mkH A D07-Oct-20201.6 KiB4623

CppunitTest_sc_indexenumeration_textfieldenumeration.mkH A D07-Oct-20201.6 KiB4623

CppunitTest_sc_information_functions_test.mkH A D07-Oct-20202.9 KiB12098

CppunitTest_sc_labelrangeobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_labelrangesobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_logical_functions_test.mkH A D07-Oct-20202.9 KiB12098

CppunitTest_sc_macros_test.mkH A D07-Oct-20202.8 KiB123102

CppunitTest_sc_mark_test.mkH A D07-Oct-20202.7 KiB123102

CppunitTest_sc_mathematical_functions_test.mkH A D07-Oct-20202.9 KiB12098

CppunitTest_sc_modelobj.mkH A D07-Oct-20201.3 KiB4824

CppunitTest_sc_namedrangeobj.mkH A D07-Oct-20201.7 KiB7552

CppunitTest_sc_namedrangesobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_new_cond_format_api.mkH A D07-Oct-20201.8 KiB7652

CppunitTest_sc_opencl_test.mkH A D07-Oct-20202.6 KiB11695

CppunitTest_sc_outlineobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_parallelism.mkH A D07-Oct-20202.4 KiB11087

CppunitTest_sc_pdf_export.mkH A D07-Oct-20202.5 KiB10079

CppunitTest_sc_perfobj.mkH A D07-Oct-20201.7 KiB7853

CppunitTest_sc_pivottable_filters_test.mkH A D07-Oct-20202.9 KiB12299

CppunitTest_sc_range_test.mkH A D07-Oct-20202.7 KiB123102

CppunitTest_sc_rangelst_test.mkH A D07-Oct-20202.8 KiB123102

CppunitTest_sc_recentfunctionsobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_recordchanges.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_scenariosobj.mkH A D07-Oct-20201.3 KiB4724

CppunitTest_sc_screenshots.mkH A D07-Oct-20201.7 KiB7046

CppunitTest_sc_shapeobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_shapetest.mkH A D07-Oct-20201.4 KiB5431

CppunitTest_sc_sheetlinkobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_sheetlinksobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_sortdescriptorbaseobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_spreadsheet_functions_test.mkH A D07-Oct-20202.9 KiB12098

CppunitTest_sc_spreadsheetsettings.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_spreadsheetsettingsobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_statistical_functions_test.mkH A D07-Oct-20202.9 KiB12098

CppunitTest_sc_stylefamiliesobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_stylefamilyobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_styleobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_subsequent_export_test.mkH A D07-Oct-20203.2 KiB131106

CppunitTest_sc_subsequent_filters_test.mkH A D07-Oct-20203.2 KiB138114

CppunitTest_sc_subtotaldescriptorbase.mkH A D07-Oct-20201.5 KiB4926

CppunitTest_sc_subtotalfieldobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_tablecolumnobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_tablecolumnsobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_tableconditionalentryobj.mkH A D07-Oct-20201.5 KiB4724

CppunitTest_sc_tableconditionalformat.mkH A D07-Oct-20201.5 KiB4724

CppunitTest_sc_tablerowobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_tablerowsobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_tablesheetobj.mkH A D07-Oct-20201.4 KiB4724

CppunitTest_sc_tablesheetsobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_tablevalidationobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_tabviewobj.mkH A D07-Oct-20201.3 KiB4623

CppunitTest_sc_text_functions_test.mkH A D07-Oct-20202.8 KiB12098

CppunitTest_sc_tiledrendering.mkH A D07-Oct-20201.6 KiB6340

CppunitTest_sc_ucalc.mkH A D03-May-20222.7 KiB126100

CppunitTest_sc_uniquecellformatsenumeration.mkH A D07-Oct-20201.5 KiB4623

CppunitTest_sc_uniquecellformatsobj.mkH A D07-Oct-20201.4 KiB4623

CppunitTest_sc_viewpaneobj.mkH A D07-Oct-20201.3 KiB4926

IwyuFilter_sc.yamlH A D07-Oct-202033.1 KiB903902

JunitTest_sc_complex.mkH A D07-Oct-2020994 3415

JunitTest_sc_unoapi_1.mkH A D07-Oct-2020466 152

JunitTest_sc_unoapi_2.mkH A D07-Oct-2020466 152

JunitTest_sc_unoapi_3.mkH A D07-Oct-2020466 152

JunitTest_sc_unoapi_4.mkH A D07-Oct-2020466 152

JunitTest_sc_unoapi_6.mkH A D07-Oct-2020466 152

JunitTest_sc_unoapi_7.mkH A D07-Oct-2020466 152

Library_sc.mkH A D03-May-202225.3 KiB743710

Library_scd.mkH A D07-Oct-2020972 4627

Library_scfilt.mkH A D07-Oct-20207.1 KiB240218

Library_scqahelper.mkH A D07-Oct-20201.4 KiB7353

Library_scui.mkH A D07-Oct-20203.4 KiB133112

Library_vbaobj.mkH A D07-Oct-20203.3 KiB133113

MakefileH A D07-Oct-2020478 152

Module_sc.mkH A D07-Oct-20208 KiB264228

Package_opencl.mkH A D07-Oct-2020541 174

Package_res_xml.mkH A D07-Oct-2020507 174

PythonTest_sc_python.mkH A D07-Oct-2020488 164

READMEH A D07-Oct-20202.2 KiB8567

TODO.performanceH A D07-Oct-2020511 139

UIConfig_scalc.mkH A D07-Oct-20209.7 KiB251234

UITest_autofilter.mkH A D07-Oct-2020586 217

UITest_calc_dialogs.mkH A D07-Oct-2020594 217

UITest_calc_tests.mkH A D07-Oct-2020586 217

UITest_calc_tests2.mkH A D07-Oct-2020590 217

UITest_calc_tests3.mkH A D07-Oct-2020590 217

UITest_calc_tests4.mkH A D07-Oct-2020590 217

UITest_calc_tests6.mkH A D07-Oct-2020590 217

UITest_calc_tests7.mkH A D07-Oct-2020590 217

UITest_calc_tests8.mkH A D07-Oct-2020590 217

UITest_calc_tests9.mkH A D07-Oct-2020590 217

UITest_chart.mkH A D07-Oct-2020566 217

UITest_conditional_format.mkH A D07-Oct-2020618 217

UITest_goalSeek.mkH A D07-Oct-2020578 217

UITest_hideShowSheet.mkH A D07-Oct-2020598 217

UITest_hide_cols.mkH A D07-Oct-2020479 164

UITest_inputLine.mkH A D07-Oct-2020582 217

UITest_key_f4.mkH A D07-Oct-2020570 217

UITest_options.mkH A D07-Oct-2020574 217

UITest_pageFormat.mkH A D07-Oct-2020586 217

UITest_protect.mkH A D07-Oct-2020574 217

UITest_range_name.mkH A D07-Oct-2020586 217

UITest_search_replace.mkH A D07-Oct-2020605 207

UITest_signatureLine.mkH A D07-Oct-2020597 207

UITest_solver.mkH A D07-Oct-2020790 248

UITest_sort.mkH A D07-Oct-2020562 217

UITest_statistics.mkH A D07-Oct-2020586 217

UITest_textCase.mkH A D07-Oct-2020578 217

UITest_validity.mkH A D07-Oct-2020578 217

common_unoapi_tests.mkH A D07-Oct-20201.5 KiB5036

README

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