top_rule.cpt 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <WorkBook xmlVersion="20170720" releaseVersion="10.0.0">
  3. <TableDataMap>
  4. <TableData name="top" class="com.fr.data.impl.DBTableData">
  5. <Parameters>
  6. <Parameter>
  7. <Attributes name="table_name1"/>
  8. <O>
  9. <![CDATA[gei_app_data_iea]]></O>
  10. </Parameter>
  11. <Parameter>
  12. <Attributes name="time"/>
  13. <O>
  14. <![CDATA[2013]]></O>
  15. </Parameter>
  16. <Parameter>
  17. <Attributes name="top_number"/>
  18. <O>
  19. <![CDATA[5]]></O>
  20. </Parameter>
  21. <Parameter>
  22. <Attributes name="index_id"/>
  23. <O>
  24. <![CDATA[]]></O>
  25. </Parameter>
  26. </Parameters>
  27. <Attributes maxMemRowCount="-1"/>
  28. <Connection class="com.fr.data.impl.NameDatabaseConnection">
  29. <DatabaseName>
  30. <![CDATA[dcp]]></DatabaseName>
  31. </Connection>
  32. <Query>
  33. <![CDATA[SELECT COUNTRY_EN_NAME as COUNTRY_CN_NAME,INDEX_EN_NAME as INDEX_CN_NAME,DATA_VALUE FROM ${table_name1} WHERE DATA_YEAR ='${time}'AND INDEX_ID = '${index_id}'AND COUNTRY_TYPE = 3 and locate("和香港",COUNTRY_CN_NAME)=0 order by DATA_VALUE desc limit ${top_number};
  34. ]]></Query>
  35. <PageQuery>
  36. <![CDATA[]]></PageQuery>
  37. </TableData>
  38. </TableDataMap>
  39. <ElementCaseMobileAttr>
  40. <ElementCaseMobileAttrProvider horizontal="4" vertical="4" zoom="true" refresh="false" isUseHTML="false" isMobileCanvasSize="false" appearRefresh="false" allowFullScreen="false" allowDoubleClickOrZoom="true" functionalWhenUnactivated="false"/>
  41. </ElementCaseMobileAttr>
  42. <Report class="com.fr.report.worksheet.WorkSheet" name="sheet1">
  43. <ReportPageAttr>
  44. <HR/>
  45. <FR/>
  46. <HC/>
  47. <FC/>
  48. </ReportPageAttr>
  49. <ColumnPrivilegeControl/>
  50. <RowPrivilegeControl/>
  51. <RowHeight defaultValue="723900">
  52. <![CDATA[12725400,723900,723900,1447800,1447800,1485900,723900,723900,723900,723900,723900]]></RowHeight>
  53. <ColumnWidth defaultValue="2743200">
  54. <![CDATA[3124200,3124200,4000500,0,0,0,0,0,0,0,0,0,0,0,0,0,2743200]]></ColumnWidth>
  55. <CellElementList>
  56. <C c="0" r="0" cs="19">
  57. <O t="CC">
  58. <LayoutAttr selectedIndex="0"/>
  59. <ChangeAttr enable="false" changeType="button" timeInterval="5" buttonColor="-6710887" carouselColor="-8421505" showArrow="true">
  60. <TextAttr>
  61. <Attr alignText="0" predefinedStyle="false">
  62. <FRFont name="PingFangSC-Regular" style="0" size="96" foreground="-1"/>
  63. </Attr>
  64. </TextAttr>
  65. </ChangeAttr>
  66. <Chart name="默认" chartClass="com.fr.plugin.chart.vanchart.VanChart">
  67. <Chart class="com.fr.plugin.chart.vanchart.VanChart">
  68. <GI>
  69. <AttrBackground>
  70. <Background name="NullBackground"/>
  71. <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
  72. </AttrBackground>
  73. <AttrBorder>
  74. <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
  75. <newColor borderColor="-1118482" autoColor="false" predefinedStyle="false"/>
  76. </AttrBorder>
  77. <AttrAlpha>
  78. <Attr alpha="1.0"/>
  79. </AttrAlpha>
  80. </GI>
  81. <ChartAttr isJSDraw="true" isStyleGlobal="false"/>
  82. <Title4VanChart>
  83. <Title>
  84. <GI>
  85. <AttrBackground>
  86. <Background name="NullBackground"/>
  87. <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
  88. </AttrBackground>
  89. <AttrBorder>
  90. <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
  91. <newColor borderColor="-6908266" autoColor="false" predefinedStyle="false"/>
  92. </AttrBorder>
  93. <AttrAlpha>
  94. <Attr alpha="1.0"/>
  95. </AttrAlpha>
  96. </GI>
  97. <O t="XMLable" class="com.fr.base.Formula">
  98. <Attributes>
  99. <![CDATA[=$index_name]]></Attributes>
  100. </O>
  101. <TextAttr>
  102. <Attr alignText="0" predefinedStyle="false">
  103. <FRFont name="微软雅黑" style="0" size="128" foreground="-13421773"/>
  104. </Attr>
  105. </TextAttr>
  106. <TitleVisible value="true" position="0"/>
  107. </Title>
  108. <Attr4VanChart useHtml="false" floating="false" x="0.0" y="0.0" limitSize="false" maxHeight="15.0"/>
  109. </Title4VanChart>
  110. <Plot class="com.fr.plugin.chart.column.VanChartColumnPlot">
  111. <VanChartPlotVersion version="20170715"/>
  112. <GI>
  113. <AttrBackground>
  114. <Background name="NullBackground"/>
  115. <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
  116. </AttrBackground>
  117. <AttrBorder>
  118. <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
  119. <newColor/>
  120. </AttrBorder>
  121. <AttrAlpha>
  122. <Attr alpha="1.0"/>
  123. </AttrAlpha>
  124. </GI>
  125. <Attr isNullValueBreak="true" autoRefreshPerSecond="6" seriesDragEnable="false" plotStyle="4" combinedSize="50.0"/>
  126. <newHotTooltipStyle>
  127. <AttrContents>
  128. <Attr showLine="false" position="1" isWhiteBackground="true" isShowMutiSeries="false" seriesLabel="${VALUE}"/>
  129. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  130. <![CDATA[#.##]]></Format>
  131. <PercentFormat>
  132. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  133. <![CDATA[#0.##%]]></Format>
  134. </PercentFormat>
  135. </AttrContents>
  136. </newHotTooltipStyle>
  137. <ConditionCollection>
  138. <DefaultAttr class="com.fr.chart.chartglyph.ConditionAttr">
  139. <ConditionAttr name="">
  140. <AttrList>
  141. <Attr class="com.fr.plugin.chart.base.AttrTooltip">
  142. <AttrTooltip>
  143. <Attr enable="true" duration="4" followMouse="false" showMutiSeries="false" isCustom="false"/>
  144. <TextAttr>
  145. <Attr alignText="0" predefinedStyle="false"/>
  146. </TextAttr>
  147. <AttrToolTipContent>
  148. <TextAttr>
  149. <Attr alignText="0" predefinedStyle="false"/>
  150. </TextAttr>
  151. <richText class="com.fr.plugin.chart.base.AttrTooltipRichText">
  152. <AttrTooltipRichText>
  153. <Attr content="" isAuto="true" initParamsContent=""/>
  154. </AttrTooltipRichText>
  155. </richText>
  156. <richTextValue class="com.fr.plugin.chart.base.format.AttrTooltipValueFormat">
  157. <AttrTooltipValueFormat>
  158. <Attr enable="true"/>
  159. </AttrTooltipValueFormat>
  160. </richTextValue>
  161. <richTextPercent class="com.fr.plugin.chart.base.format.AttrTooltipPercentFormat">
  162. <AttrTooltipPercentFormat>
  163. <Attr enable="false"/>
  164. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  165. <![CDATA[#.##%]]></Format>
  166. </AttrTooltipPercentFormat>
  167. </richTextPercent>
  168. <richTextCategory class="com.fr.plugin.chart.base.format.AttrTooltipCategoryFormat">
  169. <AttrToolTipCategoryFormat>
  170. <Attr enable="true"/>
  171. </AttrToolTipCategoryFormat>
  172. </richTextCategory>
  173. <richTextSeries class="com.fr.plugin.chart.base.format.AttrTooltipSeriesFormat">
  174. <AttrTooltipSeriesFormat>
  175. <Attr enable="true"/>
  176. </AttrTooltipSeriesFormat>
  177. </richTextSeries>
  178. <richTextChangedPercent class="com.fr.plugin.chart.base.format.AttrTooltipChangedPercentFormat">
  179. <AttrTooltipChangedPercentFormat>
  180. <Attr enable="false"/>
  181. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  182. <![CDATA[#.##%]]></Format>
  183. </AttrTooltipChangedPercentFormat>
  184. </richTextChangedPercent>
  185. <richTextChangedValue class="com.fr.plugin.chart.base.format.AttrTooltipChangedValueFormat">
  186. <AttrTooltipChangedValueFormat>
  187. <Attr enable="false"/>
  188. </AttrTooltipChangedValueFormat>
  189. </richTextChangedValue>
  190. <TableFieldCollection/>
  191. <Attr isCommon="true" isCustom="false" isRichText="false" richTextAlign="left" showAllSeries="false"/>
  192. <value class="com.fr.plugin.chart.base.format.AttrTooltipValueFormat">
  193. <AttrTooltipValueFormat>
  194. <Attr enable="true"/>
  195. </AttrTooltipValueFormat>
  196. </value>
  197. <percent class="com.fr.plugin.chart.base.format.AttrTooltipPercentFormat">
  198. <AttrTooltipPercentFormat>
  199. <Attr enable="false"/>
  200. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  201. <![CDATA[#.##%]]></Format>
  202. </AttrTooltipPercentFormat>
  203. </percent>
  204. <category class="com.fr.plugin.chart.base.format.AttrTooltipCategoryFormat">
  205. <AttrToolTipCategoryFormat>
  206. <Attr enable="true"/>
  207. </AttrToolTipCategoryFormat>
  208. </category>
  209. <series class="com.fr.plugin.chart.base.format.AttrTooltipSeriesFormat">
  210. <AttrTooltipSeriesFormat>
  211. <Attr enable="true"/>
  212. </AttrTooltipSeriesFormat>
  213. </series>
  214. <changedPercent class="com.fr.plugin.chart.base.format.AttrTooltipChangedPercentFormat">
  215. <AttrTooltipChangedPercentFormat>
  216. <Attr enable="false"/>
  217. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  218. <![CDATA[#.##%]]></Format>
  219. </AttrTooltipChangedPercentFormat>
  220. </changedPercent>
  221. <changedValue class="com.fr.plugin.chart.base.format.AttrTooltipChangedValueFormat">
  222. <AttrTooltipChangedValueFormat>
  223. <Attr enable="false"/>
  224. </AttrTooltipChangedValueFormat>
  225. </changedValue>
  226. <HtmlLabel customText="" useHtml="false" isCustomWidth="false" isCustomHeight="false" width="50" height="50"/>
  227. </AttrToolTipContent>
  228. <GI>
  229. <AttrBackground>
  230. <Background name="ColorBackground" color="-16777216"/>
  231. <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="true" autoBackground="false" predefinedStyle="false"/>
  232. </AttrBackground>
  233. <AttrBorder>
  234. <Attr lineStyle="0" isRoundBorder="false" roundRadius="2"/>
  235. <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
  236. </AttrBorder>
  237. <AttrAlpha>
  238. <Attr alpha="0.5"/>
  239. </AttrAlpha>
  240. </GI>
  241. </AttrTooltip>
  242. </Attr>
  243. <Attr class="com.fr.chart.base.AttrBorder">
  244. <AttrBorder>
  245. <Attr lineStyle="1" isRoundBorder="false" roundRadius="0"/>
  246. <newColor borderColor="-1" autoColor="false" predefinedStyle="false"/>
  247. </AttrBorder>
  248. </Attr>
  249. <Attr class="com.fr.chart.base.AttrAlpha">
  250. <AttrAlpha>
  251. <Attr alpha="1.0"/>
  252. </AttrAlpha>
  253. </Attr>
  254. </AttrList>
  255. </ConditionAttr>
  256. </DefaultAttr>
  257. </ConditionCollection>
  258. <Legend4VanChart>
  259. <Legend>
  260. <GI>
  261. <AttrBackground>
  262. <Background name="NullBackground"/>
  263. <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
  264. </AttrBackground>
  265. <AttrBorder>
  266. <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
  267. <newColor borderColor="-3355444" autoColor="false" predefinedStyle="false"/>
  268. </AttrBorder>
  269. <AttrAlpha>
  270. <Attr alpha="1.0"/>
  271. </AttrAlpha>
  272. </GI>
  273. <Attr position="4" visible="true" predefinedStyle="false"/>
  274. <FRFont name="Microsoft YaHei" style="0" size="88" foreground="-10066330"/>
  275. </Legend>
  276. <Attr4VanChart floating="false" x="0.0" y="0.0" layout="aligned" customSize="false" maxHeight="30.0" isHighlight="true"/>
  277. </Legend4VanChart>
  278. <DataSheet>
  279. <GI>
  280. <AttrBackground>
  281. <Background name="NullBackground"/>
  282. <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
  283. </AttrBackground>
  284. <AttrBorder>
  285. <Attr lineStyle="1" isRoundBorder="false" roundRadius="0"/>
  286. <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
  287. </AttrBorder>
  288. <AttrAlpha>
  289. <Attr alpha="1.0"/>
  290. </AttrAlpha>
  291. </GI>
  292. <Attr isVisible="false" predefinedStyle="false"/>
  293. <FRFont name="SimSun" style="0" size="72"/>
  294. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  295. <![CDATA[#.##]]></Format>
  296. </DataSheet>
  297. <DataProcessor class="com.fr.base.chart.chartdata.model.NormalDataModel"/>
  298. <newPlotFillStyle>
  299. <AttrFillStyle>
  300. <AFStyle colorStyle="0"/>
  301. <FillStyleName fillStyleName=""/>
  302. <isCustomFillStyle isCustomFillStyle="false"/>
  303. <PredefinedStyle predefinedStyle="false"/>
  304. </AttrFillStyle>
  305. </newPlotFillStyle>
  306. <VanChartPlotAttr isAxisRotation="false" categoryNum="1"/>
  307. <GradientStyle>
  308. <Attr gradientType="gradual" startColor="-12146441" endColor="-9378161"/>
  309. </GradientStyle>
  310. <VanChartRectanglePlotAttr vanChartPlotType="normal" isDefaultIntervalBackground="true"/>
  311. <XAxisList>
  312. <VanChartAxis class="com.fr.plugin.chart.attr.axis.VanChartAxis">
  313. <Title>
  314. <GI>
  315. <AttrBackground>
  316. <Background name="NullBackground"/>
  317. <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
  318. </AttrBackground>
  319. <AttrBorder>
  320. <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
  321. <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
  322. </AttrBorder>
  323. <AttrAlpha>
  324. <Attr alpha="1.0"/>
  325. </AttrAlpha>
  326. </GI>
  327. <O>
  328. <![CDATA[COUNTRY]]></O>
  329. <TextAttr>
  330. <Attr alignText="0" predefinedStyle="false">
  331. <FRFont name="Verdana" style="0" size="88" foreground="-10066330"/>
  332. </Attr>
  333. </TextAttr>
  334. <TitleVisible value="true" position="4"/>
  335. </Title>
  336. <newAxisAttr isShowAxisLabel="true"/>
  337. <AxisLineStyle AxisStyle="1" MainGridStyle="1"/>
  338. <newLineColor lineColor="-5197648" predefinedStyle="false"/>
  339. <AxisPosition value="3"/>
  340. <TickLine201106 type="2" secType="0"/>
  341. <ArrowShow arrowShow="false"/>
  342. <TextAttr>
  343. <Attr rotation="-25" alignText="0" predefinedStyle="false">
  344. <FRFont name="Verdana" style="0" size="88" foreground="-10066330"/>
  345. </Attr>
  346. </TextAttr>
  347. <AxisLabelCount value="=1"/>
  348. <AxisRange/>
  349. <AxisUnit201106 isCustomMainUnit="false" isCustomSecUnit="false" mainUnit="=0" secUnit="=0"/>
  350. <ZoomAxisAttr isZoom="false"/>
  351. <axisReversed axisReversed="false"/>
  352. <VanChartAxisAttr mainTickLine="2" secTickLine="0" axisName="X轴" titleUseHtml="false" labelDisplay="interval" autoLabelGap="true" limitSize="false" maxHeight="15.0" commonValueFormat="true" isRotation="false" isShowAxisTitle="true" gridLineType="NONE"/>
  353. <HtmlLabel customText="function(){ return this; }" useHtml="false" isCustomWidth="false" isCustomHeight="false" width="50" height="50"/>
  354. <alertList/>
  355. <customBackgroundList/>
  356. </VanChartAxis>
  357. </XAxisList>
  358. <YAxisList>
  359. <VanChartAxis class="com.fr.plugin.chart.attr.axis.VanChartValueAxis">
  360. <Title>
  361. <GI>
  362. <AttrBackground>
  363. <Background name="NullBackground"/>
  364. <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
  365. </AttrBackground>
  366. <AttrBorder>
  367. <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
  368. <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
  369. </AttrBorder>
  370. <AttrAlpha>
  371. <Attr alpha="1.0"/>
  372. </AttrAlpha>
  373. </GI>
  374. <O t="XMLable" class="com.fr.base.Formula">
  375. <Attributes>
  376. <![CDATA[=$unit_name1]]></Attributes>
  377. </O>
  378. <TextAttr>
  379. <Attr rotation="-90" alignText="0" predefinedStyle="false">
  380. <FRFont name="Verdana" style="0" size="88" foreground="-10066330"/>
  381. </Attr>
  382. </TextAttr>
  383. <TitleVisible value="true" position="1"/>
  384. </Title>
  385. <newAxisAttr isShowAxisLabel="true"/>
  386. <AxisLineStyle AxisStyle="0" MainGridStyle="1"/>
  387. <newLineColor mainGridColor="-3881788" mainGridPredefinedStyle="false" lineColor="-5197648" predefinedStyle="false"/>
  388. <AxisPosition value="2"/>
  389. <TickLine201106 type="2" secType="0"/>
  390. <ArrowShow arrowShow="false"/>
  391. <TextAttr>
  392. <Attr alignText="0" predefinedStyle="false">
  393. <FRFont name="Verdana" style="0" size="88" foreground="-10066330"/>
  394. </Attr>
  395. </TextAttr>
  396. <AxisLabelCount value="=1"/>
  397. <AxisRange/>
  398. <AxisUnit201106 isCustomMainUnit="false" isCustomSecUnit="false" mainUnit="=0" secUnit="=0"/>
  399. <ZoomAxisAttr isZoom="false"/>
  400. <axisReversed axisReversed="false"/>
  401. <VanChartAxisAttr mainTickLine="0" secTickLine="0" axisName="Y轴" titleUseHtml="false" labelDisplay="interval" autoLabelGap="true" limitSize="false" maxHeight="15.0" commonValueFormat="true" isRotation="false" isShowAxisTitle="true" gridLineType="solid"/>
  402. <HtmlLabel customText="function(){ return this; }" useHtml="false" isCustomWidth="false" isCustomHeight="false" width="50" height="50"/>
  403. <alertList/>
  404. <customBackgroundList/>
  405. <VanChartValueAxisAttr isLog="false" valueStyle="false" baseLog="=10"/>
  406. <ds>
  407. <RadarYAxisTableDefinition>
  408. <Top topCate="-1" topValue="-1" isDiscardOtherCate="false" isDiscardOtherSeries="false" isDiscardNullCate="false" isDiscardNullSeries="false"/>
  409. <attr/>
  410. </RadarYAxisTableDefinition>
  411. </ds>
  412. </VanChartAxis>
  413. </YAxisList>
  414. <stackAndAxisCondition>
  415. <ConditionCollection>
  416. <DefaultAttr class="com.fr.chart.chartglyph.ConditionAttr">
  417. <ConditionAttr name=""/>
  418. </DefaultAttr>
  419. </ConditionCollection>
  420. </stackAndAxisCondition>
  421. <VanChartColumnPlotAttr seriesOverlapPercent="20.0" categoryIntervalPercent="20.0" fixedWidth="false" columnWidth="15" filledWithImage="false" isBar="false"/>
  422. </Plot>
  423. <ChartDefinition>
  424. <OneValueCDDefinition seriesName="INDEX_CN_NAME" valueName="DATA_VALUE" function="com.fr.data.util.function.SumFunction">
  425. <Top topCate="-1" topValue="-1" isDiscardOtherCate="false" isDiscardOtherSeries="false" isDiscardNullCate="false" isDiscardNullSeries="false"/>
  426. <TableData class="com.fr.data.impl.NameTableData">
  427. <Name>
  428. <![CDATA[top]]></Name>
  429. </TableData>
  430. <CategoryName value="COUNTRY_CN_NAME"/>
  431. </OneValueCDDefinition>
  432. </ChartDefinition>
  433. </Chart>
  434. <UUID uuid="032e81a7-84ae-4cd5-9c9b-81b19f1f08b1"/>
  435. <tools hidden="true" sort="true" export="true" fullScreen="true"/>
  436. <VanChartZoom>
  437. <zoomAttr zoomVisible="false" zoomGesture="true" zoomResize="true" zoomType="xy" controlType="zoom" categoryNum="8" scaling="0.3"/>
  438. <from>
  439. <![CDATA[]]></from>
  440. <to>
  441. <![CDATA[]]></to>
  442. </VanChartZoom>
  443. <refreshMoreLabel>
  444. <attr moreLabel="false" autoTooltip="true"/>
  445. <AttrTooltip>
  446. <Attr enable="true" duration="4" followMouse="false" showMutiSeries="false" isCustom="false"/>
  447. <TextAttr>
  448. <Attr alignText="0" predefinedStyle="false"/>
  449. </TextAttr>
  450. <AttrToolTipContent>
  451. <TextAttr>
  452. <Attr alignText="0" predefinedStyle="false"/>
  453. </TextAttr>
  454. <richText class="com.fr.plugin.chart.base.AttrTooltipRichText">
  455. <AttrTooltipRichText>
  456. <Attr content="" isAuto="true" initParamsContent=""/>
  457. <params>
  458. <![CDATA[{}]]></params>
  459. </AttrTooltipRichText>
  460. </richText>
  461. <richTextValue class="com.fr.plugin.chart.base.format.AttrTooltipValueFormat">
  462. <AttrTooltipValueFormat>
  463. <Attr enable="true"/>
  464. </AttrTooltipValueFormat>
  465. </richTextValue>
  466. <richTextPercent class="com.fr.plugin.chart.base.format.AttrTooltipPercentFormat">
  467. <AttrTooltipPercentFormat>
  468. <Attr enable="false"/>
  469. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  470. <![CDATA[#.##%]]></Format>
  471. </AttrTooltipPercentFormat>
  472. </richTextPercent>
  473. <richTextCategory class="com.fr.plugin.chart.base.format.AttrTooltipCategoryFormat">
  474. <AttrToolTipCategoryFormat>
  475. <Attr enable="false"/>
  476. </AttrToolTipCategoryFormat>
  477. </richTextCategory>
  478. <richTextSeries class="com.fr.plugin.chart.base.format.AttrTooltipSeriesFormat">
  479. <AttrTooltipSeriesFormat>
  480. <Attr enable="false"/>
  481. </AttrTooltipSeriesFormat>
  482. </richTextSeries>
  483. <richTextChangedPercent class="com.fr.plugin.chart.base.format.AttrTooltipChangedPercentFormat">
  484. <AttrTooltipChangedPercentFormat>
  485. <Attr enable="false"/>
  486. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  487. <![CDATA[#.##%]]></Format>
  488. </AttrTooltipChangedPercentFormat>
  489. </richTextChangedPercent>
  490. <richTextChangedValue class="com.fr.plugin.chart.base.format.AttrTooltipChangedValueFormat">
  491. <AttrTooltipChangedValueFormat>
  492. <Attr enable="false"/>
  493. </AttrTooltipChangedValueFormat>
  494. </richTextChangedValue>
  495. <TableFieldCollection/>
  496. <Attr isCommon="true" isCustom="false" isRichText="false" richTextAlign="left" showAllSeries="false"/>
  497. <value class="com.fr.plugin.chart.base.format.AttrTooltipValueFormat">
  498. <AttrTooltipValueFormat>
  499. <Attr enable="true"/>
  500. </AttrTooltipValueFormat>
  501. </value>
  502. <percent class="com.fr.plugin.chart.base.format.AttrTooltipPercentFormat">
  503. <AttrTooltipPercentFormat>
  504. <Attr enable="false"/>
  505. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  506. <![CDATA[#.##%]]></Format>
  507. </AttrTooltipPercentFormat>
  508. </percent>
  509. <category class="com.fr.plugin.chart.base.format.AttrTooltipCategoryFormat">
  510. <AttrToolTipCategoryFormat>
  511. <Attr enable="true"/>
  512. </AttrToolTipCategoryFormat>
  513. </category>
  514. <series class="com.fr.plugin.chart.base.format.AttrTooltipSeriesFormat">
  515. <AttrTooltipSeriesFormat>
  516. <Attr enable="true"/>
  517. </AttrTooltipSeriesFormat>
  518. </series>
  519. <changedPercent class="com.fr.plugin.chart.base.format.AttrTooltipChangedPercentFormat">
  520. <AttrTooltipChangedPercentFormat>
  521. <Attr enable="false"/>
  522. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  523. <![CDATA[#.##%]]></Format>
  524. </AttrTooltipChangedPercentFormat>
  525. </changedPercent>
  526. <changedValue class="com.fr.plugin.chart.base.format.AttrTooltipChangedValueFormat">
  527. <AttrTooltipChangedValueFormat>
  528. <Attr enable="true"/>
  529. </AttrTooltipChangedValueFormat>
  530. </changedValue>
  531. <HtmlLabel customText="" useHtml="false" isCustomWidth="false" isCustomHeight="false" width="50" height="50"/>
  532. </AttrToolTipContent>
  533. <GI>
  534. <AttrBackground>
  535. <Background name="ColorBackground" color="-1"/>
  536. <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
  537. </AttrBackground>
  538. <AttrBorder>
  539. <Attr lineStyle="1" isRoundBorder="false" roundRadius="4"/>
  540. <newColor borderColor="-15395563" autoColor="false" predefinedStyle="false"/>
  541. </AttrBorder>
  542. <AttrAlpha>
  543. <Attr alpha="0.8"/>
  544. </AttrAlpha>
  545. </GI>
  546. </AttrTooltip>
  547. </refreshMoreLabel>
  548. <ThemeAttr>
  549. <Attr darkTheme="false" predefinedStyle="false"/>
  550. </ThemeAttr>
  551. </Chart>
  552. </O>
  553. <PrivilegeControl/>
  554. <Expand/>
  555. </C>
  556. <C c="0" r="1" cs="3" s="0">
  557. <O t="XMLable" class="com.fr.base.Formula">
  558. <Attributes>
  559. <![CDATA[="PS:The data comes from international organizations such as the world bank.(DATA SOURCE:" + (if(find("wb", $table_name1) > 0, "WORLD BANK", "") || if(find("iea", $table_name1) > 0, "IEA", "") || if(find("eia", $table_name1) > 0, "EIA)", "") || if(find("bp", $table_name1) > 0, "BP", "")) + ")"]]></Attributes>
  560. </O>
  561. <PrivilegeControl/>
  562. <Expand/>
  563. </C>
  564. <C c="0" r="3" s="1">
  565. <O t="BiasTextPainter">
  566. <IsBackSlash value="false"/>
  567. <![CDATA[COUNTRY|INDEX]]></O>
  568. <PrivilegeControl/>
  569. <Expand/>
  570. </C>
  571. <C c="1" r="3" s="1">
  572. <O t="DSColumn">
  573. <Attributes dsName="top" columnName="COUNTRY_CN_NAME"/>
  574. <Condition class="com.fr.data.condition.ListCondition"/>
  575. <Complex/>
  576. <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
  577. <Result>
  578. <![CDATA[$$$]]></Result>
  579. <Parameters/>
  580. </O>
  581. <PrivilegeControl/>
  582. <Expand dir="1"/>
  583. </C>
  584. <C c="3" r="3" s="2">
  585. <PrivilegeControl/>
  586. <Expand/>
  587. </C>
  588. <C c="0" r="4" s="1">
  589. <O t="XMLable" class="com.fr.base.Formula">
  590. <Attributes>
  591. <![CDATA[="YEAR:"+$time +"AND INDEX:" + $index_name + "AND INDEX'S UNIT:" + $unit_name1 + ")"]]></Attributes>
  592. </O>
  593. <PrivilegeControl/>
  594. <Expand/>
  595. </C>
  596. <C c="1" r="4" s="3">
  597. <O t="DSColumn">
  598. <Attributes dsName="top" columnName="DATA_VALUE"/>
  599. <Condition class="com.fr.data.condition.ListCondition"/>
  600. <Complex/>
  601. <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
  602. <Result>
  603. <![CDATA[$$$]]></Result>
  604. <Parameters/>
  605. </O>
  606. <PrivilegeControl/>
  607. <Expand dir="1"/>
  608. </C>
  609. <C c="3" r="4" s="2">
  610. <PrivilegeControl/>
  611. <Expand/>
  612. </C>
  613. <C c="3" r="5" s="2">
  614. <PrivilegeControl/>
  615. <Expand/>
  616. </C>
  617. </CellElementList>
  618. <ReportAttrSet>
  619. <ReportSettings headerHeight="0" footerHeight="0">
  620. <PaperSetting orientation="1">
  621. <PaperSize width="60480000" height="85536000"/>
  622. <Margin top="986400" left="2743200" bottom="986400" right="2743200"/>
  623. </PaperSetting>
  624. <Background name="ColorBackground" color="-1"/>
  625. </ReportSettings>
  626. <Header reportPageType="0">
  627. <Background name="NullBackground"/>
  628. <LeftList/>
  629. <CenterList/>
  630. <RightList/>
  631. </Header>
  632. <Footer reportPageType="0">
  633. <Background name="NullBackground"/>
  634. <LeftList/>
  635. <CenterList/>
  636. <RightList/>
  637. </Footer>
  638. </ReportAttrSet>
  639. <PrivilegeControl/>
  640. </Report>
  641. <ReportParameterAttr>
  642. <Attributes showWindow="true" delayPlaying="true" windowPosition="1" align="0" useParamsTemplate="true" currentIndex="0"/>
  643. <PWTitle>
  644. <![CDATA[参数]]></PWTitle>
  645. <Parameter>
  646. <Attributes name="index_name"/>
  647. <O>
  648. <![CDATA[发电总量]]></O>
  649. </Parameter>
  650. <Parameter>
  651. <Attributes name="time"/>
  652. <O>
  653. <![CDATA[2013]]></O>
  654. </Parameter>
  655. <Parameter>
  656. <Attributes name="table_name1"/>
  657. <O>
  658. <![CDATA[gei_app_data_iea]]></O>
  659. </Parameter>
  660. <Parameter>
  661. <Attributes name="unit_name1"/>
  662. <O>
  663. <![CDATA[百分比]]></O>
  664. </Parameter>
  665. <Parameter>
  666. <Attributes name="top_number"/>
  667. <O>
  668. <![CDATA[10]]></O>
  669. </Parameter>
  670. <Parameter>
  671. <Attributes name="index_id"/>
  672. <O>
  673. <![CDATA[246 ]]></O>
  674. </Parameter>
  675. </ReportParameterAttr>
  676. <StyleList>
  677. <Style imageLayout="1">
  678. <FRFont name="SimSun" style="0" size="72" foreground="-4144960"/>
  679. <Background name="NullBackground"/>
  680. <Border/>
  681. </Style>
  682. <Style horizontal_alignment="0" imageLayout="1">
  683. <FRFont name="SimSun" style="0" size="72"/>
  684. <Background name="ColorBackground" color="-3342337"/>
  685. <Border>
  686. <Top style="1" color="-16777216"/>
  687. <Bottom style="1" color="-16777216"/>
  688. <Left style="1" color="-16777216"/>
  689. <Right style="1" color="-16777216"/>
  690. </Border>
  691. </Style>
  692. <Style horizontal_alignment="0" imageLayout="1">
  693. <FRFont name="SimSun" style="0" size="72"/>
  694. <Background name="NullBackground"/>
  695. <Border/>
  696. </Style>
  697. <Style horizontal_alignment="0" imageLayout="1">
  698. <FRFont name="SimSun" style="0" size="72"/>
  699. <Background name="NullBackground"/>
  700. <Border>
  701. <Top style="1"/>
  702. <Bottom style="1"/>
  703. <Left style="1"/>
  704. <Right style="1"/>
  705. </Border>
  706. </Style>
  707. </StyleList>
  708. <DesignerVersion DesignerVersion="KAA"/>
  709. <PreviewType PreviewType="0"/>
  710. <TemplateCloudInfoAttrMark class="com.fr.plugin.cloud.analytics.attr.TemplateInfoAttrMark" pluginID="com.fr.plugin.cloud.analytics.v10" plugin-version="2.3.4.20211109">
  711. <TemplateCloudInfoAttrMark createTime="1630373918220"/>
  712. </TemplateCloudInfoAttrMark>
  713. <TemplateIdAttMark class="com.fr.base.iofile.attr.TemplateIdAttrMark">
  714. <TemplateIdAttMark TemplateId="3e44562d-8138-4429-a3a6-e7a90dbd7fd3"/>
  715. </TemplateIdAttMark>
  716. </WorkBook>