Bug 160941 - recursive iteration does not include all depended cells in each step
Summary: recursive iteration does not include all depended cells in each step
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-05-05 09:56 UTC by Regina Henschel
Modified: 2024-05-05 14:07 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
recursion depends on position (18.30 KB, application/vnd.oasis.opendocument.calc)
2024-05-05 09:56 UTC, Regina Henschel 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Regina Henschel 2024-05-05 09:56:45 UTC 
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.
Comment 1 m_a_riosv 2024-05-05 14:03:21 UTC 
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
Comment 2 m_a_riosv 2024-05-05 14:07:18 UTC 
Same behavior with Aoo 4.1.5.