Laserfiche WebLink
TSTool Documentation Spreadsheet Integration <br /> Spreadsheet Integration - 7 <br />paste special into a new worksheet , c opying the values (or copy formatting first and then copy <br />values). The values can then be read and used in the test. This is not ideal for reading Excel files <br />for operational processing but may be a reasonable work -around for defining software tests. <br />• Some Excel integration approaches such as using a datastore or IronPython may result in Excel <br />software (or u nderlying “headless” library processes) processes running that may impose <br />restrictions s uch as lock i ng files. If issues arise the work -around may be to read Excel files <br />directly with ReadTableFromExcel() and similar commands. <br /> <br />10.7 M aking TSTool Graph Output Look Like Excel Charts <br /> <br />T STool has been developed primarily as a tool that autom ates and streamlines data processing. Features <br />to v isualize time series have been implemented in Java whereas Microsoft Excel i s developed in <br />Microsoft technologies. I t has not been a focus to implement all TSTool visualization features to match <br />Excel ; h owever, it is recognized that many users are familiar with Excel charting and would like to <br />p rodu ce similar charts in TSTool. T h e followin g table lists areas where TSTool does not match Excel, <br />the rationale for the difference, and options for improvements that can be implemented in the future . <br /> <br />TSTool and Excel Time Series G raph Comparison <br /> <br />TSTool Graph Feature <br />Compared to Excel <br />Rationale for Implementation <br />in TSTool <br />P otential enhancement <br />TSTool default graphs are <br />s imple, with no titles <br />The default graphs that are <br />displayed h ave relatively basic <br />formatting because TSTool <br />processes data from many sources. <br />F o r example, it is not implemented <br />in the current software to use blue <br />to draw all time series of data type <br />“streamflow ”. Time series <br />properties for titles are also <br />difficult to implement in generic <br />way. <br />Allow default graph properties to be <br />configured so that TSTool defaults <br />are more appropriate for a particular <br />syste m. <br /> <br />Users can edit many graph properties <br />by right -clicking on graph area and <br />use the ProcessTSProduct() <br />command. <br />TSTool has limited fonts The c ore fonts supported in Java <br />are offered. It can be an issue if <br />non -standard fonts are used <br />because they are not offere d on all <br />computers. <br />Expand fonts based on latest Java <br />capabilities and use standard default <br />if font is not available. <br />TSTool X -axis graph labels <br />cannot be rotated <br />The label features were <br />implemented with an older version <br />o f Java that did not support rotated <br />text. Also, the TSTool auto - <br />labeling features for date/times <br />p rovide intelligent horizontal <br />labeling. <br />Enable label rotation as an option <br />using latest Java capabilities. <br />TSTool Y -axis graph labels <br />cannot be rotated <br />S ee above . Vertical Y -axis l abels <br />would be beneficial , e s pecially for <br />long Y -axis labels. The curr ent <br />work -around is to show the Y -axis <br />label horizontally at the top of the <br />axis . <br />Enable label rotation as an option <br />using latest Java capabilities. <br />135