In the next tab, you should specify your workbook options as per your requirements (real-time charting).įig.4. 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. Write data to an XLS file without ExcelĪll parser items are now ready for export using the "Direct OpenOffice/LibreOffice Connection" plugin.Export data and update charts in Excel in real-time.Send data to Excel through the DDE interface. You can work in OpenOffice Calc or LibreOffice Calc, specifically create charts in Calc.įor this tutorial, all items were prepared in the previous part. Direct OpenOffice/LibreOffice Connection.Advanced PBX 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 Comments
Leave a Reply. |