title: Updating a previously opened LibreOffice spreasdsheet via Python script without closing LibreOffice
body: <p>I have a LibreOffice spreadsheet (data.ods) containing approximately 500 rows of comma separated values in 30 columns. The first row contains the column headers.</p>
  
  <p>Data.ods is updated periodically throughout the day by a script.  I then have several links to the cells in data.ods in another spreadsheet (main.ods).</p>
  
  <p>I am currently doing the following:</p>
  
  <p>1) Generate data.ods using a Python script.</p>
  
  <p>2) Open data.ods so that LibreOffice does a Text Import of the comma separated values to populate the rows.</p>
  
  <p>3) Open main.ods (which automatically updates the links).</p>
  
  <p>I am not able to simply leave main.ods open currently because even after closing data.ods, it appears that LibreOffice still has some sort of lock on the file and does not allow my script to edit data.ods until I close LibreOffice altogether (requiring me to close main.ods).</p>
  
  <p>I would like to to do the following:</p>
  
  <p>1) Have main.ods open.</p>
  
  <p>2) Generate data.ods via script.</p>
  
  <p>3) Import updated values into main.ods using Edit...Links...Update Values.</p>
  
  <p>4) Leave main.ods open.</p>
  
  <p>5) Generate new data.ods via script.</p>
  
  <p>6) Import updated values into main.ods using Edit...Links...Update Values.</p>
  
  <p>7) Repeat as necessary.</p>