[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.
|
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
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.1.1ref 93 1161 1161.1.1sqref 93 1162 1162.1.1conditionalFormattings 93 1163 1163.1.1dataValidations 94 1164 1164.1.1sparklineGroups 94 1165 1165.1.1slicerList 94 1166 1166.1.1protectedRanges 95 1167 1167.1.1ignoredErrors 95 1168 1168.1.1pivotCaches 95 1169 1169.1.1slicerCaches 95 1170 1170.1.1workbookPr 96 1171 1171.1.1calculatedMember 96 1172 1172.1.1cacheHierarchy 96 1173 1173.1.1dataField 96 1174 1174.1.1pivotField 97 1175 1175.1.1pivotTableDefinition 97 1176 1176.1.1pivotCacheDefinition 97 1177 1177.1.1connection 98 1178 1178.1.1table 98 1179 1179.1.1slicerStyles 98 1180 1180.1.1dxfs 98 1181 1181.1.1oleItem 99 1182 1182.1.1pivotHierarchy 99 1183 1183.1.1cacheField 99 1184 1184.1.1id 100 1185 1185.1.1iconFilter 100 1186 1186.1.1filter 100 1187 1187.1.1customFilters 100 1188 1188.1.1sortCondition 101 1189 1189.1.1sourceConnection 101 1190 1190.1.1formControlPr 101 1191 1191.1.1datastoreItem 101 1192 1192.1.1slicers 102 1193 1193.1.1slicer 102 1194 1194.1.1slicerCacheDefinition 102 1195 1195.1.1pivotCaches 102 1196 1196.1.1pivotTableReferences 103 1197 1197.1.1queryTable 103 1198 1198.1.1webExtensions 103 1199 1199.1.1connection 104 1200 1200.1.1calculatedMember 104 1201 1201.1.1pivotTableUISettings 104 1202 1202.1.1pivotFilter 104 1203 1203.1.1slicerCaches 105 1204 1204.1.1tableSlicerCache 105 1205 1205.1.1timelineCacheRefs 105 1206 1206.1.1timelineRefs 105 1207 1207.1.1timelineCachePivotCaches 106 1208 1208.1.1cacheHierarchy 106 1209 1209.1.1slicerCacheHideItemsWithNoData 106 1210 1210.1.1timelineStyles 106 1211 1211.1.1dxfs 107 1212 1212.1.1timelinePivotCacheDefinition 107 1213 1213.1.1timelines 107 1214 1214.1.1timelineCacheDefinition 107 1215 1215.1.1workbookPr 108 1216 1216.1.1slicerCachePivotTables 108 1217 1217.1.1cachedUniqueNames 108 1218 1218.1.1dataModel 108 1219 1219.1.1pivotTableData 109 1220 1220.1.1pivotCacheIdVersion 109 1221 1221.1.1timeslicer 109 1222 1222.1.1list 110 1223 1223.1.1absPath 110 1224 1224.1.1dataField 110 1225 1225.1.1survey 110 1226 1226.1.1contentPart 111 1227 1227.1.1modelTimeGroupings 111 1228 1228.1.1revisionPtr 111 1229 1229.1.1pivotTableDefinition16 111 1230 1230.1Global Attributes 112 1230.1.1coauthVersionLast 112
1231.1.1coauthVersionMax 112 1232 1232.1.1dyDescent 112 1233 1233.1.1formatCode16 112 1234 1234.1.1knownFonts 113 1235 1235.1.1uid 114 1236 1236.1.1uid 114 1237 1237.1.1uid 114 1238 1238.1.1uid 114 1239 1239.1.1uid 115 1240 1240.1.1uid 115 1241 1241.1.1uidLastSave 115 1242 1242.1Complex Types 115 1242.1.1CT_ConditionalFormattings 115
1247.1.1CT_ConditionalFormatting 116 1248 1249 1250 1251 1252 1253 116 1254 1255 117 1255.1.1CT_DataValidations 117 1256 1257 1258 1259 117 1260 1261 1262 1263 1264 118 1264.1.1CT_DataValidationFormula 118 1265 1266 1267 1268 118 1269 118 1269.1.1CT_DataValidation 119 1270 1271 1272 1273 1274 1275 120 1276 1277 1278 1279 1280 1281 1282 1283 1284 1285 1286 1287 1288 1289 121 1289.1.1CT_SparklineGroups 121 1290 1291 1292 1293 121 1294 122 1294.1.1CT_SparklineGroup 122 1295sparklinegroup-formula = single-sheet-area / [single-sheet-prefix / book-prefix] name 122 1296 1297 1298 1299 1300 1301 1302 1303 1304 1305 1306 1307 1308 125 1309 1310 1311 1312 1313 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 126 1327.1.1CT_Sparklines 126 1328 1329 1330 1331 126 1332 126 1332.1.1CT_Sparkline 126 1333sparkline-formula = single-sheet-area / [single-sheet-prefix / book-prefix] name 126 1334 1335 1336 1337 1338 127 1339 127 1339.1.1CT_WorkbookPr 127 1340 1341 1342 1343 1344 128 1344.1.1CT_SlicerRefs 128 1345 1346 1347 1348 128 1349 128 1349.1.1CT_SlicerRef 128 1350 1351 1352 128 1352.1.1CT_SlicerCaches 129 1353 1354 1355 1356 129 1357 129 1357.1.1CT_SlicerCache 129 1358 1359 1360 129 1360.1.1CT_CalculatedMember 129 1361 1362 1363 1364 131 1365 Yüklə 5,13 Mb. Dostları ilə paylaş:
|