I am using Windows XP Professional Service Pack 3, LibreOffice 126.96.36.199 Calc, Hyperterminal, and Arduino Uno to log temperature data. All programs appear to be functioning correctly independently, however when I use Calc to access data from a Hyperterminal text file that regularly updates, it’s almost like XP does not allow Calc to access the file. Calc can “see” the text file created by Hyperterminal and set up comma separated columns for data, but when I try to actually use it, the OK is grayed out, no columns are seen, and and of course nothing happens.
I am currently using Windows 7 Ultimate Service Pack 1 and Windows 10 Home respectively on two other computers with LibreOffice 188.8.131.52 Calc and CoolTerm for Windows, and everything works correctly to log data into LibreOffice Calc. I used LibreOffce version 184.108.40.206 because higher versions do not load on Windows XP, and went back to Hyperterminal because of issues with CoolTerm and Windows XP.
Does anyone know if there’s a security setting or something like it in Windows XP that prevents LibreOffice Calc from actually using the “Link to External Data” feature to an updating text file? It does not appear to make any difference if the text file is open or closed. I’ve tried using and after the browsing to the file name, but get the same result – grayed out “OK”, and no data into Calc.
I am strongly considering removing Windows XP, installing Linux Ubuntu, and associated Linux versions of LibreOffice, Arduino IDE, and a terminal program.
Thanks in advance for your help.