https://wiki.documentfoundation.org/Faq/Calc/113
- Create a new LibreOffice Calc document.
- Click on a cell in the table (A1 for example)
- Go to Sheet ▸ Link to external data.
- After a few seconds (sometimes a bit longer) a new window appears:
- Check the Detect special numbers box.
- Click OK.