Bug 137493 - [Regression] Cells with multiple dependency chains are not updated
Summary: [Regression] Cells with multiple dependency chains are not updated
Status: RESOLVED DUPLICATE of bug 137248
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-10-15 07:17 UTC by Albert Astals Cid
Modified: 2020-10-17 18:15 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
the file that has the problem (9.02 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-10-15 07:17 UTC, Albert Astals Cid
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Albert Astals Cid 2020-10-15 07:17:34 UTC
Description:
This used to work until the last update. It's kind of hard to explain so i'm attaching a file to reproduce it.

Steps to Reproduce:
1. Open the file
2. Add an 8 in A17


Actual Results:
- E6 changes to -128
- E8 stays at 0

Expected Results:
- E6 changes to -128
- E8 changes to -8


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Saving actually updates E8 to -8

Version: 7.0.2.2
Build ID: 00(Build:2)
CPU threads: 8; OS: Linux 5.8; UI render: default; VCL: kf5
Locale: ca-ES (ca_ES.UTF-8); Interfície: ca-ES
7.0.2-1
Calc: threaded
Comment 1 Albert Astals Cid 2020-10-15 07:17:53 UTC
Created attachment 166375 [details]
the file that has the problem
Comment 2 Ming Hua 2020-10-15 07:55:46 UTC
Most likely the same issue as in bug 137248, which has been fixed in master, and will be fixed in 7-0 branch soon.

Please test a daily build (https://dev-builds.libreoffice.org/daily/master/) or 7.0.3 release scheduled mid-November.
Comment 3 Albert Astals Cid 2020-10-15 09:29:29 UTC
So i gave you a 5 seconds way to reproduce it and instead of you trying to reproduce it yourself i have to install a daily build from some weird to install format?

I'll pass
Comment 4 [REDACTED] 2020-10-15 12:29:10 UTC
(In reply to Albert Astals Cid from comment #3)
> So i gave you a 5 seconds way to reproduce it and instead of you trying to
> reproduce it yourself i have to install a daily build from some weird to
> install format?
> 
> I'll pass

Last comment from Min Hua doesn't state that he couldn't reproduce (or anyone else couldn't) but that your report is accepted and most probably has been reported already by some other people. The link and advice given, just provides a way how you could check if the fix, that has been provided by resolution of https://bugs.documentfoundation.org/show_bug.cgi?id=137248 also works for your. But you decided to pass ...
Comment 5 m_a_riosv 2020-10-15 17:33:00 UTC
(In reply to Albert Astals Cid from comment #3)
> So i gave you a 5 seconds way to reproduce it and instead of you trying to
> reproduce it yourself i have to install a daily build from some weird to
> install format?
> 
> I'll pass

If you don't like don't do it. But we are volunteers in our free time, so some for your side could be expected.

Works for me.
Version: 7.1.0.0.alpha0+ (x64)
Build ID: c064766901722082df0d759c95434c1460fcdba5
CPU threads: 4; OS: Windows 10.0 Build 20180; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL
Comment 6 Albert Astals Cid 2020-10-15 21:03:36 UTC
(In reply to Uwe Auer from comment #4)
> (In reply to Albert Astals Cid from comment #3)
> > So i gave you a 5 seconds way to reproduce it and instead of you trying to
> > reproduce it yourself i have to install a daily build from some weird to
> > install format?
> > 
> > I'll pass
> 
> Last comment from Min Hua doesn't state that he couldn't reproduce (or
> anyone else couldn't) but that your report is accepted and most probably has
> been reported already by some other people. The link and advice given, just
> provides a way how you could check if the fix, that has been provided by
> resolution of https://bugs.documentfoundation.org/show_bug.cgi?id=137248
> also works for your. But you decided to pass ...

That's not how i read his/her comment.

The bug was set to "needsinfo" which in every other bug tracker i've used means "you need to give us this info, we'll wait until you do so before continuing to investigate this bug".

Anyhow thanks for confirming it seems to be resolved :)
Comment 7 Ming Hua 2020-10-16 01:25:30 UTC
(In reply to Albert Astals Cid from comment #6)
> (In reply to Uwe Auer from comment #4)
> > (In reply to Albert Astals Cid from comment #3)
> > > So i gave you a 5 seconds way to reproduce it and instead of you trying to
> > > reproduce it yourself i have to install a daily build from some weird to
> > > install format?
> > > 
> > > I'll pass
> > 
> > Last comment from Min Hua doesn't state that he couldn't reproduce (or
> > anyone else couldn't) but that your report is accepted and most probably has
> > been reported already by some other people. The link and advice given, just
> > provides a way how you could check if the fix, that has been provided by
> > resolution of https://bugs.documentfoundation.org/show_bug.cgi?id=137248
> > also works for your. But you decided to pass ...
> 
> That's not how i read his/her comment.
> 
> The bug was set to "needsinfo" which in every other bug tracker i've used
> means "you need to give us this info, we'll wait until you do so before
> continuing to investigate this bug".
Sorry for making you feel this way.  Yes I could test on 7.0.1/7.0.2/master using your sample document and decide if it's a duplicate without your further input, but I don't have a recent daily build installed and it would definitely not be "5 seconds" work.

As Uwe Auer said we are all volunteers helping LO in our free time.  I don't want to give you a negative impression about LO community, but hope you can understand that we have limited time and sometimes expect bug reporters to do a bit of extra work.
Comment 8 Aron Budea 2020-10-17 18:15:11 UTC
This indeed must be a dupe of bug 137248, let's set as duplicate.

*** This bug has been marked as a duplicate of bug 137248 ***