fixtures/calc/make.py

56 def step(label, fn, *a, **kw):  function
244         step("filter-" + name, one, i, "f_" + name, conns)
257             step("op-" + o, mk)
289     step("sorts", sorts)
309     step("subtotals", subtotals)
319     step("dbattrs", attrs)
324 step("dbranges", dbranges)
394         step("func-" + fn, func_pivot, k, fn)
414             step("ref-%s-%s" % (rtype, itype), ref_pivot, k, rtype, itype)
431             step("sort-%s-%s" % (mode, asc), sort_pivot, k, mode, asc)
447             step("autoshow-%s-%s" % (mode, en), auto_pivot, k, mode, en)
461             step("layout-%s-%s" % (mode, empty), layout_pivot, k, mode, empty)
471         step("totals-%d" % k, totals_pivot, k, row, col, **kw)
486     step("subtotals", sub_pivot)
493     step("page", page_pivot)
499     step("two-data-fields", hidden_pivot)
524     step("filtered", filtered_pivot)
545             step("dategroup-%s-%s" % (part, auto), date_group, k, part, auto, fname)
562         step("dayrange-%s" % auto, num_group, k, auto)
570     step("namegroup", name_group)
575 step("pivots", pivots)
590         step(name + ":" + label, fn, doc, sh)
645 step("tracked", tracked_changes)
671     step("arealinks", arealinks)
682     step("sheetlinks", sheetlinks)
709     step("scenario-1", sc1)
720     step("scenario-2", sc2)
725     step("scenario-3", sc3)
751         step("consolidate-" + fn, one)
775         step("consolidate-%s-%s%s" % (fn, rows, cols), one)
805         step("detective-" + cmd, do, cmd, addr)
826     step("shape-page-rect", add, "RectangleShape", 3000, 1000, 3000, 2000, None, "page anchored")
827     step("shape-page-ellipse", add, "EllipseShape", 7000, 1000, 2000, 2000)
828     step("shape-cell-rect", add, "RectangleShape", 3000, 4000, 3000, 2000, "B3", "cell anchored")
829     step("shape-cell-line", add, "LineShape", 3000, 7000, 3000, 1000, "C5")
830     step("shape-cell-text", add, "TextShape", 8000, 5000, 3000, 1000, "D2", "text")
831     step("shape-conn", add, "ConnectorShape", 1000, 9000, 3000, 1000)
854             step(name + ":" + k, doc.setPropertyValue, k, v)
900         step("import-%s-%d" % (t, i), one)
905 step("null_year", null_year)
906 step("db_imports", db_imports)
907 step("links", links)
908 step("scenarios", scenarios)
909 step("consolidation", consolidation)
910 step("detective", detective)
911 step("shapes", shapes_doc)
912 step("calc_settings", calc_settings)
976         step("form-%d" % i, put)
977     step("array-1", sh.getCellRangeByName("F1:G2").setArrayFormula, "=A1:B2*2")
978     step("array-2", sh.getCellRangeByName("H1:H3").setArrayFormula, "=A1:A3+1")
979     step("array-3", sh.getCellRangeByName("J1:K1").setArrayFormula, "=TRANSPOSE(A1:A2)")
982 …step("tableop-col", sh.getCellRangeByName("O2:O5").setTableOperation, sh.getCellRangeByName("N1:O1…
983 …step("tableop-row", sh.getCellRangeByName("Q2:R2").setTableOperation, sh.getCellRangeByName("P1:P2…
984 …step("tableop-both", sh.getCellRangeByName("U2:W4").setTableOperation, sh.getCellRangeByName("T1:T…
1001         step("name-" + n, nr.addNewByName, n, c, cell_addr(0, 0, 0), fl)
1003 …step("collabel-%d" % i, doc.ColumnLabelRanges.addNew, rng_addr(0, i, 0, i, 0), rng_addr(0, i, 1, i…
1004 …  step("rowlabel-1", doc.RowLabelRanges.addNew, rng_addr(0, 0, 1, 0, 11), rng_addr(0, 1, 1, 4, 11))
1005     step("rowlabel-2", doc.RowLabelRanges.addNew, rng_addr(1, 0, 0, 0, 3), rng_addr(1, 1, 0, 3, 3))
1006     step("print-areas", sh.setPrintAreas, (rng_addr(0, 0, 0, 4, 5), rng_addr(0, 0, 8, 4, 11)))
1007     step("title-rows", sh.setPrintTitleRows, True)
1008     step("title-rows-r", sh.setTitleRows, rng_addr(0, 0, 0, 0, 0))
1009     step("title-cols", sh.setPrintTitleColumns, True)
1010     step("title-cols-r", sh.setTitleColumns, rng_addr(0, 0, 0, 0, 0))
1037         step("cf-" + op, one)
1083 …step("group-rows", sh.group, rng_addr(0, 0, 14, 0, 18), uno.Enum("com.sun.star.table.TableOrientat…
1084 …step("group-rows2", sh.group, rng_addr(0, 0, 15, 0, 16), uno.Enum("com.sun.star.table.TableOrienta…
1085 …step("group-cols", sh.group, rng_addr(0, 11, 0, 13, 0), uno.Enum("com.sun.star.table.TableOrientat…
1086 …step("group-cols2", sh.group, rng_addr(0, 20, 0, 22, 0), uno.Enum("com.sun.star.table.TableOrienta…
1087     step("hide-grp-rows", sh.hideDetail, rng_addr(0, 0, 15, 0, 16))
1088     step("hide-grp-cols", sh.hideDetail, rng_addr(0, 20, 0, 22, 0))
1120     step("merge", m.merge, True)
1155 step("functions", functions)
1156 step("formula_forms", formula_forms)
1157 step("names", names_and_ranges)
1158 step("condfmt", conditional_formats)
1159 step("table_attrs", table_attrs)
1160 step("filtered", filtered_rows)
1163 step("validations", validations)
1164 step("validation_edges", validation_edges)