[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format Intellectual Property Rights Notice for Open Specifications Documentation


workbook-unhide-params = "(" argument ")" 68



Yüklə 5,13 Mb.
səhifə7/71
tarix09.01.2019
ölçüsü5,13 Mb.
#94307
1   2   3   4   5   6   7   8   9   10   ...   71

1140workbook-unhide-params = "(" argument ")" 68

1141workgroup-params = "(" argument ")" 68

1142workgroup-options-params = "(" *space ")" 68

1143workspace-params = "(" argument *15("," argument) ")" 68

1144zoom-params = "(" argument ")" 68

1144.1.1.1Cell Formulas 68

1144.1.1.2Conditional Formatting Formulas 69

1144.1.1.3Data Validation Formulas 69

1144.1.1.4External Name Formulas 69

1145external-name-formula = ref-constant / sheet-range-reference / single-sheet-reference 69

1145.1.1.1Name Formulas 69



1146function-call =/ (macro-function-call / command-function-call) 69

1146.1.1.1Pivot Field Formulas 70



1147nospace-expression =/ pivot-field-name 70

1148pivot-field-name = name / apostrophe 1*pivot-field-string-character apostrophe 70

1149pivot-field-string-character = apostrophe apostrophe / pivot-field-character 70

1150pivot-field-character = character ; MUST NOT be apostrophe 70

1150.1.1.1Pivot Item Formulas 70



1151nospace-expression =/ pivot-items 70

1152pivot-items = pivot-item space *(*whitespace pivot-item) 70

1153pivot-item = pivot-field-name / pivot-field-name "[" pivot-item-value "]" 70

1154pivot-item-value = pivot-field-name / [sign] whole-number-part 70

1154.1.1Functions 71



1155function-name = 74

1156 prefixed-function-name | 74

1157 predefined-function-name | 74

1158 user-defined-function-name | 74

1159 future-function-list; 74

1159.1.1Extensions by Part 74

1159.1.1.1Connections 75

1159.1.1.2Drawing 75

1159.1.1.3External Workbook References 76

1159.1.1.4Pivot Table 76

1159.1.1.5Pivot Table Cache Definition 78

1159.1.1.6Query Table 79

1159.1.1.7Styles 79

1159.1.1.8SlicerCache 79

1159.1.1.9Table Definition 80

1159.1.1.10Workbook 81

1159.1.1.11Worksheet 81

1159.2Conceptual Overview 83

1159.2.1PivotTable What-if Analysis 83

1159.2.2Slicers 84

1159.2.2.1Slicer Cache 84

1159.2.2.1.1Slicer Source Data 84

1159.2.2.1.2Slicer Cache Relationship to PivotCache 84

1159.2.2.1.3Slicer Cache Relationship to Table 85

1159.2.2.1.4Slicer Cache Relationship to PivotTable View 85

1159.2.2.1.5Slicer Cache Relationship to Table column 86

1159.2.2.1.6Slicer Items 86

1159.2.2.1.6.1Non-OLAP Slicer Items 86

1159.2.2.1.6.2OLAP Slicer Items 87

1159.2.2.1.7Slicer Cross Filtering 87

1159.2.2.2Slicer View 88

1159.2.2.2.1Slicer View Relationship to Slicer Cache 88

1159.2.2.3Slicers and Cube Functions 88

1159.2.2.4Slicer Styles 88

1159.2.3Non-Worksheet PivotTable 89

1159.2.4PivotValues 89

1159.2.4.1PivotValueCell 89

1159.2.4.1.1Value 89

1159.2.4.1.2Server Formatting 89

1159.2.5Timelines 90

1159.2.5.1Timeline Cache 90

1159.2.5.1.1Timeline Source Data 90

1159.2.5.1.2Timeline Cache Relationship to PivotCache 90

1159.2.5.1.3Timeline Cache Relationship to PivotTable View 90

1159.2.5.1.4Timeline State 91

1159.2.5.2Timeline View 91

1159.2.5.2.1Timeline View Relationship to Timeline Cache 91

1159.2.5.3Timelines and Cube Functions 91

1159.2.5.4Timeline Styles 92

1159.3Global Elements 92

1159.3.1pivotTableReference 92

1159.3.2pivotTableServerFormats 92

1159.3.3f 92

1160 93

1160.1.1ref 93



1161 93

1161.1.1sqref 93



1162 93

1162.1.1conditionalFormattings 93



1163 94

1163.1.1dataValidations 94



1164 94

1164.1.1sparklineGroups 94



1165 94

1165.1.1slicerList 94



1166 94

1166.1.1protectedRanges 95



1167 95

1167.1.1ignoredErrors 95



1168 95

1168.1.1pivotCaches 95



1169 95

1169.1.1slicerCaches 95



1170 96

1170.1.1workbookPr 96



1171 96

1171.1.1calculatedMember 96



1172 96

1172.1.1cacheHierarchy 96



1173 96

1173.1.1dataField 96



1174 97

1174.1.1pivotField 97



1175 97

1175.1.1pivotTableDefinition 97



1176 97

1176.1.1pivotCacheDefinition 97



1177 97

1177.1.1connection 98



1178 98

1178.1.1table 98



1179 98

1179.1.1slicerStyles 98



1180 98

1180.1.1dxfs 98



1181 99

1181.1.1oleItem 99



1182 99

1182.1.1pivotHierarchy 99



1183 99

1183.1.1cacheField 99



1184 99

1184.1.1id 100



1185 100

1185.1.1iconFilter 100



1186 100

1186.1.1filter 100



1187 100

1187.1.1customFilters 100



1188 100

1188.1.1sortCondition 101



1189 101

1189.1.1sourceConnection 101



1190 101

1190.1.1formControlPr 101



1191 101

1191.1.1datastoreItem 101



1192 102

1192.1.1slicers 102



1193 102

1193.1.1slicer 102



1194 102

1194.1.1slicerCacheDefinition 102



1195 102

1195.1.1pivotCaches 102



1196 103

1196.1.1pivotTableReferences 103



1197 103

1197.1.1queryTable 103



1198 103

1198.1.1webExtensions 103



1199 103

1199.1.1connection 104



1200 104

1200.1.1calculatedMember 104



1201 104

1201.1.1pivotTableUISettings 104



1202 104

1202.1.1pivotFilter 104



1203 104

1203.1.1slicerCaches 105



1204 105

1204.1.1tableSlicerCache 105



1205 105

1205.1.1timelineCacheRefs 105



1206 105

1206.1.1timelineRefs 105



1207 105

1207.1.1timelineCachePivotCaches 106



1208 106

1208.1.1cacheHierarchy 106



1209 106

1209.1.1slicerCacheHideItemsWithNoData 106



1210 106

1210.1.1timelineStyles 106



1211 106

1211.1.1dxfs 107



1212 107

1212.1.1timelinePivotCacheDefinition 107



1213 107

1213.1.1timelines 107



1214 107

1214.1.1timelineCacheDefinition 107



1215 108

1215.1.1workbookPr 108



1216 108

1216.1.1slicerCachePivotTables 108



1217 108

1217.1.1cachedUniqueNames 108



1218 108

1218.1.1dataModel 108



1219 109

1219.1.1pivotTableData 109



1220 109

1220.1.1pivotCacheIdVersion 109



1221 109

1221.1.1timeslicer 109



1222 110

1222.1.1list 110



1223 110

1223.1.1absPath 110



1224 110

1224.1.1dataField 110



1225 110

1225.1.1survey 110



1226 111

1226.1.1contentPart 111



1227 111

1227.1.1modelTimeGroupings 111



1228 111

1228.1.1revisionPtr 111



1229 111

1229.1.1pivotTableDefinition16 111



1230 111

1230.1Global Attributes 112

1230.1.1coauthVersionLast 112

1231 112

1231.1.1coauthVersionMax 112



1232 112

1232.1.1dyDescent 112



1233 112

1233.1.1formatCode16 112



1234 113

1234.1.1knownFonts 113



1235 113

1235.1.1uid 114



1236 114

1236.1.1uid 114



1237 114

1237.1.1uid 114



1238 114

1238.1.1uid 114



1239 114

1239.1.1uid 115



1240 115

1240.1.1uid 115



1241 115

1241.1.1uidLastSave 115



1242 115

1242.1Complex Types 115

1242.1.1CT_ConditionalFormattings 115

1243 116

1244 116

1245 116

1246 116

1247 116

1247.1.1CT_ConditionalFormatting 116



1248 116

1249 116

1250 116

1251 116

1252 116

1253 116

1254 117

1255 117

1255.1.1CT_DataValidations 117



1256 117

1257 117

1258 117

1259 117

1260 117

1261 118

1262 118

1263 118

1264 118

1264.1.1CT_DataValidationFormula 118



1265 118

1266 118

1267 118

1268 118

1269 118

1269.1.1CT_DataValidation 119



1270 120

1271 120

1272 120

1273 120

1274 120

1275 120

1276 120

1277 120

1278 121

1279 121

1280 121

1281 121

1282 121

1283 121

1284 121

1285 121

1286 121

1287 121

1288 121

1289 121

1289.1.1CT_SparklineGroups 121



1290 121

1291 121

1292 121

1293 121

1294 122

1294.1.1CT_SparklineGroup 122



1295sparklinegroup-formula = single-sheet-area / [single-sheet-prefix / book-prefix] name 122

1296 124

1297 124

1298 124

1299 124

1300 125

1301 125

1302 125

1303 125

1304 125

1305 125

1306 125

1307 125

1308 125

1309 125

1310 125

1311 125

1312 125

1313 125

1314 125

1315 125

1316 125

1317 125

1318 125

1319 125

1320 125

1321 125

1322 125

1323 125

1324 125

1325 125

1326 126

1327 126

1327.1.1CT_Sparklines 126



1328 126

1329 126

1330 126

1331 126

1332 126

1332.1.1CT_Sparkline 126



1333sparkline-formula = single-sheet-area / [single-sheet-prefix / book-prefix] name 126

1334 127

1335 127

1336 127

1337 127

1338 127

1339 127

1339.1.1CT_WorkbookPr 127



1340 127

1341 127

1342 127

1343 127

1344 128

1344.1.1CT_SlicerRefs 128



1345 128

1346 128

1347 128

1348 128

1349 128

1349.1.1CT_SlicerRef 128



1350 128

1351 128

1352 128

1352.1.1CT_SlicerCaches 129



1353 129

1354 129

1355 129

1356 129

1357 129

1357.1.1CT_SlicerCache 129



1358 129

1359 129

1360 129

1360.1.1CT_CalculatedMember 129



1361 131

1362 131

1363 131

1364 131

1365 131

Yüklə 5,13 Mb.

Dostları ilə paylaş:
1   2   3   4   5   6   7   8   9   10   ...   71




Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©muhaz.org 2024
rəhbərliyinə müraciət

gir | qeydiyyatdan keç
    Ana səhifə


yükləyin