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:
@studog Would sharing the file private being an option?
Yes. I've removed the personal information and left the raw data, and the problem is still occurring. How do I submit it? Email it to you?
(In reply to studog from comment #2) > Yes. I've removed the personal information and left the raw data, and the > problem is still occurring. > > How do I submit it? Email it to you? Just attach it here using "Add an attachment" link above
Hello, How can I eliminate confidential data from a sample document? https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
(In reply to Roman Kuznetsov from comment #3) > (In reply to studog from comment #2) > > Yes. I've removed the personal information and left the raw data, and the > > problem is still occurring. > > > > How do I submit it? Email it to you? > > Just attach it here using "Add an attachment" link above You've misunderstood my meaning. I have removed my various personal information, but left the real raw data intact, which is critical for reproducing the bug. I *still* do not want to submit the spreadsheet publicly, because it still contains real data. However, I will submit it to someone directly, if they agree not to distribute it publicly themselves.
(In reply to studog from comment #5) > (In reply to Roman Kuznetsov from comment #3) > > (In reply to studog from comment #2) > > > Yes. I've removed the personal information and left the raw data, and the > > > problem is still occurring. > > > > > > How do I submit it? Email it to you? > > > > Just attach it here using "Add an attachment" link above > > You've misunderstood my meaning. > > I have removed my various personal information, but left the real raw data > intact, which is critical for reproducing the bug. I *still* do not want to > submit the spreadsheet publicly, because it still contains real data. > However, I will submit it to someone directly, if they agree not to > distribute it publicly themselves. That's not going to work. You need to create a minimal reproducer that you can share in public. If you are unable to do it, this has to be closed.
Dear studog, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear studog, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp
I've moved to a new PC, and a new OS, and a new LibreOffice. Linux Mint 22 Version: 24.2.5.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: en-US (C.UTF-8); UI: en-US Ubuntu package version: 4:24.2.5-0ubuntu0.24.04.2 Calc: threaded I haven't seen this issue recently, but it was occurring with decreasing frequency correlated with newer versions, for quite a while. I'm not confident the issue is fixed, but it's no longer a bother. I'll update it I see it again.
Thanks, let's set to worksforme for now.