https://bugs.documentfoundation.org/show_bug.cgi?id=149146
Bug ID: 149146
Summary: Spurious Err:522
Product: LibreOffice
Version: 7.3.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I am recreating an Excel spreadsheet in LibreOffice by building it from File ->
New -> Spreadsheet, aka the ground, up.
I paste in my current version of the Basic code from an external file. One sub
creates a template sheet. My new spreadsheet has 7 copies of the template
sheet, all identical except for the raw data entered in designated columns.
I have started getting spurious Err:522 in the most recent tab, on document
open.
Recalculate Hard resolves the issue, so there's a workaround.
It is 100% repeatable.
I saw recently somewhere on the internet a suggestion that turning off
multi-threaded calculation resolves this issue. It does not resolve the issue
for me.
There is no circular reference. A) I’m a programmer. B) I used Trace Precendent
and it doesn’t indicate any circular references, only the existing linear ones.
C) This sheet is a template, one of 7 identical sheet in the workbook, and only
the last one (on the tab bar, but is also the most recently created) has this
issue. If it was truly circular, they’d all have it. D) Recalculate can’t
resolve a circular reference, so that wouldn’t work if it was real (iterative
calculation is off).
It’s pretty clear to me that, on open, there is a recalculation cycle that just
craps out part way through.
Which raises another question: these values were already calculated before
being saved, why are they being recalculated on open? I took pains to avoid
volatile functions.
I searched bugzilla but didn't find an existing bug that is exactly my issue,
but did find a number of bugs going back years with Err:522 errors referenced.
I ran 10 open cycles on the affected spreadsheet. The first cell containing
Err:522 changes from open to open:
P35
P31
P29
P32
no error!
P25
P37
P38
P29
P30
All P cells have the same formula.
Steps to Reproduce:
Unforunately I can't give a copy of the file that has the problem due to the
sensitive nature of the data within.
It is currently happening 99% of the time.
Actual Results:
Spurious Err:522 in various cells, inconsistently.
Expected Results:
A) Already calculated and saved values don't recalculate on document open for
no reason.
B) Calculations that aren't circular don't produce Err:522 Circular Reference
errors
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 7.3.3.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (C.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.3~rc2-0ubuntu0.18.04.1~lo1
Calc: threaded
glxinfo | grep OpenGL
OpenGL vendor string: X.Org
OpenGL renderer string: AMD TAHITI (DRM 2.50.0, 5.4.0-110-generic, LLVM 10.0.0)
OpenGL core profile version string: 4.5 (Core Profile) Mesa 20.0.8
OpenGL core profile shading language version string: 4.50
OpenGL core profile context flags: (none)
OpenGL core profile profile mask: core profile
OpenGL core profile extensions:
OpenGL version string: 4.5 (Compatibility Profile) Mesa 20.0.8
OpenGL shading language version string: 4.50
OpenGL context flags: (none)
OpenGL profile mask: compatibility profile
OpenGL extensions:
OpenGL ES profile version string: OpenGL ES 3.2 Mesa 20.0.8
OpenGL ES profile shading language version string: OpenGL ES GLSL ES 3.20
OpenGL ES profile extensions:
--
You are receiving this mail because:
You are the assignee for the bug.
