LibreOffice Calc TCP to RTD

Tags: Calc Macro Spreadsheets

last edited: 2023-05-21

This is a Python based extension for LibreOffice Calc to make real-time data available in Calc spreadsheets via a TCP socket

Description

Getting data should be as simple as having this in a cell: =RTD("key")

Now, in a different cell, type =RTD("__start") and a TCP listener will be started waiting for incoming data.

Next, data needs to be sent using a socket to port 13000. If you wish to manually test it, open up a telnet in a terminal: telnet localhost 13000. In the telnet, write '<key|example_data>' and then press ENTER. The cell with the formula =RTD("key") (from section 1) will now show "example_data" instead of "None"

Homepage: https://github.com/gilgil/RTD-Extension

Repository: https://github.com/gilgil/RTD-Extension

Release List

Release: v1.0.0 – Initial release