When I export a report to xlsx and open it with libre office cals the result of dbr.sum = 0.
dbr.sum and libre office(2 posts) (2 voices)
By default LibreOffice does not evaluate the formulas. Go to LibreOffice Preferences → LibreOffice Calc → Formula and select "Always recalculate" from "Recalculation on file load" / "Excel 2007 and newer".
We have also set the exported XLSX document to save precalculated values so that if you have many users using LibreOffice, no need to change the LibreOffice preferences.
You must log in to post.