I have a CSV file with data I want in a spreadsheet - mostly to display a chart based on it. I also want the chart to be updated every time the file is rewritten by a console application. What I tried already:
- Open it in Calc, then rewrite it on disk. Impossible due to Calc locking the file.
- Played with shared spreadsheets in Calc. Did not help much.
- Tried to set it up through LO Base. LO Base does not lock the database source but refuses to update its table view anyway. The Refresh/Reload button does nothing.