Description: Hi, I have a similair and maybe related problem with pre-generated files and sum or multiplication with percentage. When opening the file it doesnt show the calculation. Works when I use CTRL+SHFIT+F9 but if I close the file and then open it again it shows 0 again. Similiar behavior if one opens the sheet in microsoft office excel, as it opens it locked, but when going to edit mode it show correct sum\multiplication, and when reopening in ms excel it shows the correct numbers. Was going to put it togheter with bug: Bug 101694 - Formula displays wrong number but it seems he has problem with using CTRL+SHIFT+F9 Happens in ubuntu and tested it in a windows machine aswell: LINUX Version: 5.1.4.2 Build ID: 1:5.1.4-0ubuntu1 CPU Threads: 12; OS Version: Linux 4.4; UI Render: default; Locale: sma-SE (C) WINDOWS Version: 5.2.3.3 Build ID: d54a8868f08a7b39642414cf2c8ef2f228f780cf CPU Threads: 8; OS Version: Windows 6.2; UI Render: default; Locale: sv-SE (sv_SE); Calc: group Steps to Reproduce: 1. Generate a xlsx-file with phpoffice/phpexcel(latest) in ubuntu, so it is hard to do a pre-genereted file. Actual Results: When opening column G and H with formulas show 0. And cell C21 and C22 shows 0. Expected Results: When opening column G and H with formulas should show correct calculations. And cell C21 and C22 should shows correct calculations. Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.100 Safari/537.36
Created attachment 129400 [details] a pre-generated file Pre generetaed file
Hi Pablo, Select Tools > Options > LibreOffice Calc > Formula > Recalculation on File Load > Excel 2007 and newer choose : Always recalculate or Prompt user Do the same if you want it also for : ODF spreadsheet and OK. Have a nice day, Jacques
It seems strange that a recalculation needs to be done when you have not inserted anything into the cell beside a formula?, why does it show 0?, the 0 have to come from somewhere?, the 0 seems to be the default, why not calculate the formula instead if no cached result exists