Description: I create anew calc sheet and some cells updateswhile other don't. User can't rely on the cell results, some updaets and some do not. If some cell update this could lead to think every cell value is correct, when is is not. Data->Calculate->Autocalculate is checked Tools->Options->Libreoffice Calc->Formula->Recalculation on File Load both set to Always recalculate. F9 manual calculation works and updates all cells but Autocalculate is not working on A3 and A4. Steps to Reproduce: 1. Create new spreadsheet 2. Enter cell value A1=1 3. A2 = A1*20000 4. A3 = 0.42* SQRT(A2) 5. A4 = 0.016 * A2 6. Change values in A1, A2 updates but A3 and A4 do not Actual Results: User can-t rely on the cell results, some updaets and some do not. Seen some cell update could lead to think every cell value is correct, when is is not. Expected Results: To autocalculate all cells and get consistent results. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.0.2.2 (x64) Build ID: 8349ace3c3162073abd90d81fd06dcfb6b36b994 CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: threaded
Created attachment 166770 [details] Calc example
Hello Federico, Thanks for reporting this issue. It looks like a duplicate of bug 137248 *** This bug has been marked as a duplicate of bug 137248 ***