The format the coordinates are specified in should comply with the standard accepted in OpenOffice/LibreOffice Calc. Left top cell - here, you should specify the coordinates of the upper-left cell, starting from which data will be sent to OpenOffice/LibreOffice Calc.Therefore we've selected the "Vertically" method In this example, we need to send data to OpenOffice/LibreOffice Calc by columns. Therefore we've selected the "Move" method In this example, we need the last 30 values. Thus, the plugin uses the FIFO filling method. Suppose the number of cells available for the filling was exceeded, the plugin will move data upwards (if the plugin fills data by columns), or to the left (if the plugin fills data by rows), and new data will appear in an unoccupied cell. You may select a variable name from a drop-down box or type this name manually for variables defined or created in filter plugins Parser variable name, which you have created in the parser configuration. For this example, three variables with their corresponding descriptions have been added.Įach data export item has several properties: You can type any characters here, which will help you to remember a variable's content. Before adding an item, the program will ask you about an item description. On this page, you should bind a parser variable to the necessary column.Īny new items can be added by clicking the "Add item" button (Fig.7, pos. The last "Binding" page (fig.7) is significant. Therefore we've specified this number on the "Worksheet" page. We've created the workbook, where the worksheet is first. 3, you should specify your worksheet number in the workbook. In the next tab, with the help of the option at the pos. 3, allows you to save all the written data when the program exits.įig.5. The path and name of this file, which you created before (fig.3), you should specify in field #2. You should select the "Use a workbook from a file" option (fig.4 pos.1) that allows you to use an existing file and write data to this file. In the next tab, you should specify your workbook options as per your requirements (real-time charting).įig.4.
#OPENOFFICE CALC GRAPH DOWNLOAD#
The ODS file, which we've created you can download here and use it in your work. The figure above contains the following elements: We'll use the last 30 values on the diagram only.įig.3. We'll place FLOW1, VOLW1, and TEMP1 to columns, and the chart will use these values and automatically redraw every time. Each plot is based on data from columns A, B, or C. In this example, we've created a diagram with three plots. OpenOffice Calc will be started automatically on program start.īecause we want to draw a chart in a real-time environment, then we should prepare an OpenOffice ODS file before the next step. These options will allow you to start OpenOffice Calc and display it on your desktop. You need to select options in field #1 and field #2. Data export plugin for OpenOffice Calc.įig.2. On the screenshots and in the program interface as "OpenOffice Calc."įig.1. The configuration is very similar to the " Direct Excel Connection" plugin. 4) and clicking the "Setup" button on the "Data export" page (fig. Please, open the configuration window of the "Direct OpenOffice/LibreOffice Connection" plugin (fig.2) by selecting the module in a list (fig.
#OPENOFFICE CALC GRAPH UPDATE#
#OPENOFFICE CALC GRAPH TRIAL#
Advanced OPC Data Logger Professional, Enterprise, or a trial version.I can control the format of the incoming ASCII data. I want OpenOffice Calc to automatically receive and graph the ASCII data, sort of like an oscilloscope. The COM port will provide a stream of ASCII numeric characters to OpenOffice Calc. I want to connect an RS-2322 port to OpenOffice Calc or LibreOffice Calc.
0 kommentar(er)
