[Libreoffice-bugs] [Bug 92551] Spurious circular reference errors - new in 4.4.4.3

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92551

--- Comment #14 from Xisco Faulí  ---
The content of attachment 117073 has been deleted

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92551] Spurious circular reference errors - new in 4.4.4.3

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92551

--- Comment #13 from m.a.riosv miguelange...@libreoffice.org ---
It's really difficult to know what happens in a so complex file, test if change
the value minimum change for iterative references option.

I have done several calculations with [F9] and with [Ctrl+Shift+F9] (hard
recalc), and I can't see circular errors. (minimum change 0.001), maybe some
other global option produces the error.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92551] Spurious circular reference errors - new in 4.4.4.3

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92551

--- Comment #12 from David Lynch david_ly...@blueyonder.co.uk ---
Thanks for your help. I agree that it should not be a bug.

I am still getting occasional cells with Err: 522 (in a different part of the
the spreadsheet).

I have reduced the number of iterations to 3 in 
Menu/Tools/LibreOffice calc/calculate - Iterative reference

When I set on the cell in error and do Menu/Tools/Detective/Trace error, as you
suggest, the error disappears and the expected value appears in the cell and I
get no error trace.

Am I doing something wrong?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92551] Spurious circular reference errors - new in 4.4.4.3

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92551

--- Comment #10 from David Lynch david_ly...@blueyonder.co.uk ---
Many thanks. You are right.

The offending code has been unchanged for months. I don't understand why:

 at first there were no Err:522 errors
 then, [CNTL][SHIFT][F9] removed them
 then, renaming the user profile removed them
 then, [CNTL][SHIFT][F9] moved the errors elsewhere
 then, now, it is impossible to remove them.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92551] Spurious circular reference errors - new in 4.4.4.3

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92551

m.a.riosv miguelange...@libreoffice.org changed:

   What|Removed |Added

 Status|REOPENED|RESOLVED
 Resolution|--- |NOTABUG

--- Comment #11 from m.a.riosv miguelange...@libreoffice.org ---
Hard recalc [Shif+Ctrl+F9] forces the whole recalculitation while
Autorecalculate or [F9] recalculate a cell when there are changes in their
precedents.

And also there are several fixed bugs with issues in situations where
Autocalculate didn't work properly. Maybe it can explain why now circular error
is always showed and not before.

I think for now we can't consider this as a bug, please if you are not agree,
reopen it.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92551] Spurious circular reference errors - new in 4.4.4.3

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92551

--- Comment #9 from m.a.riosv miguelange...@libreoffice.org ---
Sorry @David, I think there is a circular reference:

wds.CA (corrected_clue)
wds.BU
wds.G
wds.B
$w.$A$1:AB1
corrected_clue

What can help to find this issues is:

Menu/Tools/Detective/Trace error

If you need to use in that way then activate the option:
Menu/Tools/LibreOffice calc/calculate - Iterative reference
It can limits how many times to do recursive calculations.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92551] Spurious circular reference errors - new in 4.4.4.3

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92551

--- Comment #7 from David Lynch david_ly...@blueyonder.co.uk ---
This bug has got more and more frequent. For some time [CNTL][SHIFT][F9] got
rid of the Err: 522 cells. Then it moved the Err: 522 to a different set of
cells. Now nothing will remove the Err: 522 cells.

Renaming the user profile has no effect.

I have attached the spreadsheet.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92551] Spurious circular reference errors - new in 4.4.4.3

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92551

--- Comment #8 from David Lynch david_ly...@blueyonder.co.uk ---
Created attachment 117305
  -- https://bugs.documentfoundation.org/attachment.cgi?id=117305action=edit
Spreadsheet exhibiting bug

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92551] Spurious circular reference errors - new in 4.4.4.3

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92551

David Lynch david_ly...@blueyonder.co.uk changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|FIXED   |---
 Ever confirmed|0   |1

--- Comment #6 from David Lynch david_ly...@blueyonder.co.uk ---
This error has started to appear again. It disappeared for a few days when I
made myself a new user profile.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92551] Spurious circular reference errors - new in 4.4.4.3

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92551

--- Comment #5 from David Lynch david_ly...@blueyonder.co.uk ---
Created attachment 117073
  -- https://bugs.documentfoundation.org/attachment.cgi?id=117073action=edit
Corrupt user profile

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92551] Spurious circular reference errors - new in 4.4.4.3

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92551

m.a.riosv miguelange...@libreoffice.org changed:

   What|Removed |Added

 CC||miguelangelrv@libreoffice.o
   ||rg

--- Comment #1 from m.a.riosv miguelange...@libreoffice.org ---
Created attachment 117066
  -- https://bugs.documentfoundation.org/attachment.cgi?id=117066action=edit
Screenshot after change A1

Hi @David,

I can't reproduce with:
Win7x64Ultimate
Version: 4.4.4.3 Build ID: 2c39ebcf046445232b798108aa8a7e7

Attached screenshot after change A1.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92551] Spurious circular reference errors - new in 4.4.4.3

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92551

David Lynch david_ly...@blueyonder.co.uk changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 CC||david_ly...@blueyonder.co.u
   ||k
 Resolution|--- |FIXED

--- Comment #2 from David Lynch david_ly...@blueyonder.co.uk ---
Thanks for attempting to reproduce this.

Renaming my user profile solves the problem. I'm now trying to find out what in
my user profile is causing the error.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92551] Spurious circular reference errors - new in 4.4.4.3

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92551

m.a.riosv miguelange...@libreoffice.org changed:

   What|Removed |Added

 CC||jmadero@gmail.com

--- Comment #4 from m.a.riosv miguelange...@libreoffice.org ---
I have found several times that the issues are only with that file.

Please attach here, of course after deleting any personal information like user
data.

Added @Joel as CC, because recently he was looking for that corrupted user
profiles.

Please could change the status from FIXED to WORKSFORME, in reality nothing was
fixed.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92551] Spurious circular reference errors - new in 4.4.4.3

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92551

--- Comment #3 from David Lynch david_ly...@blueyonder.co.uk ---
The registrymodifications.xcu file causes the problem. I have kept it and can
post it here if it is of interest.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs