Created attachment 193973 [details] recursion depends on position Open attached document. Make sure that "Iterative References" is enabled in Tools > Options > Calc > Calculate. The two sheets differ only in where the formulas are placed relative to each other. In one sheet the iteration works, in the other not. That should not happen. Export the file to .xlsx and try it in Excel. Such dependency does not exist in Excel.
Reproducible. Version: 24.2.3.2 (X86_64) / LibreOffice Community Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: default; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded and Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: f4ef5435df5560e6b6b061ce4053c71e2819bf51 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Same behavior with Aoo 4.1.5.