Created attachment 189149 [details] problematic .docx file I have attached the .docx file that gave me fits (scores.docx) Apologies if I got the subcomponent designation incorrect. I was sent this file from someone who created it via Word (I am not sure what version). This document is essentially an embedded spreadsheet with a final calculation to the right. The spreadsheet was created within Word and not an embedded Excel sheet or some such. The issue: The calculated numbers recalculate upon mouse click or PDF export and are incorrect. How to replicate: 1. libreOffice scores.docx 2. export the PDF. The document will alter (numbers to the right will recalculate) and the PDF will reflect the error 3. exit out of libreoffice 4. reopen the file: libreoffice scores.docx 5. click on any of the numbers calculated to the right I'm not sure if it is because there is non-numeral data in the spreadsheet or not, but that may be it. That being said, the behavior is different than with Word, so I figured I would share this. I hope this helps make libreoffice better. Thanks. -t PS. I replicated the error with Zoho Office: Imports fine, but export to .odt results in a document with the same error. Does Zoho use libreoffice's engine for such conversions? I suspect they do.
Also opening with Word, there is not an embedded spreadsheet, it is a word table. In the last column, there are table formulas AVERAGE() With Menu/Tools/Update/Update all, the results are updated (LibreOffice). In word with select all and F9, also update those calculated fields. So seems for some reason the file was saved without update the calculated fields. Please, if you are not agreed, reopen it.
Reopening. Yes, it updates all on its own, or with your forced involvement. But the values reconfigure to incorrect values. For example, row 2 (Adrift, Todd Warner, ...): Opened in LibreOffice, the average for that row initially displays correctly as 9.7. Click any place in the document, and it auto-updates to a value of 10, which is incorrect. Something is being dropped from Word to LibreOffice.
The formula in row 2 is: =AVERAGE(<I3:I3>) -> 10 if I3 has 10 that it is not similar to row 3 =AVERAGE(<I4:F4>) and different form row 4 =AVERAGE(<I5:D5>), this seems should be the right formula. Writer gets the same values as Word at update. So there is not a bug.