Laserfiche WebLink
Spreadsheet Integration TSTool Doc umentation <br />Spreadsheet Integration - 8 <br />TSTool Graph Feature <br />Compared to Excel <br />Rationale for Implementation <br />in TSTool <br />P otential enhancement <br />TSTool lines look a bit <br />b locky <br />TSTool has no limitations on the <br />number of data points that can be <br />graphed. However, h andling <br />m issing data as gaps in lines , <br />sometimes results in blocky <br />transitions through sharp angles. <br />Improve the TSTool drawing <br />algorithm to take advantage of <br />improved Java drawing internals (use <br />less moveto/lineto a nd instead draw <br />more polylines). Also implement a <br />line property to draw lines by <br />connecting points (the current <br />default) and as step -function to show <br />continuous value for interv al. <br />TSTool bar ch arts do not <br />look as nice as Excel <br />TSTool bar charts are designed to <br />handle large number of data points <br />and the drawing logic sometimes <br />r esults in non -optimal space <br />between bars. <br />Spend more time looking at bar <br />representation, in particular case <br />when bars are left off the ends of the <br />graph. <br />TSTool legend default is <br />too complicated <br />The TSTool legen d provides more <br />information tha n simple grap hs in <br />Excel or other tools. The user can <br />configure simpler legends with <br />graph properties. <br />Evaluate whether default legend <br />should be simpler, and allow user to <br />specify a global default. <br />TSTool does not draw data <br />in middle of interval (e.g., <br />should place point in <br />middle of month, not at <br />start) <br />TSTool graphing tools can display <br />large numbers of data points and <br />are intended more for scientific <br />visualization than business data <br />visualization. <br />Implement a graph option for <br />whether to plot data points at the <br />start, middle, or end of the data <br />interval. T h is has been done to <br />control bar positions but has not been <br />implemented for point or line g raphs. <br />TSTool does not by default <br />format numbers as <br />MM/DD/YYYY <br />The MM/DD/YYYY format is <br />typical for dates in the USA. <br />However, this format does not sort <br />well and the ISO standard YYYY - <br />MM -DD format is used in TSTool <br />t o promote consistency. <br />P rovide optional graph properties to <br />override default date/time format. <br />TSTool does not by default <br />format numbers with <br />commas to separate <br />tho usands. <br />This was not implemented due to <br />resource limitations and because <br />the default of no separator is <br />appropriate in any locale. <br />Provide optional properties to display <br />separators. <br />TSTool does not offer pie <br />charts and some other Excel <br />charts <br />TSTool was initially developed for <br />time series visualization. More <br />recent enhancements have enabled <br />features to process tables and <br />statistics and s uch information <br />may be desirable to display in l ess <br />data -intensive graphs such as pie <br />charts. <br />Add pie charts and other graph types <br />as part of table visualization <br />enhancements. <br /> <br /> <br />136