Description: Option VBASupport 1 Option Compatible Option explicit I have my VBA in several Makromodules (sheets) . Some Variables are defined as global so that i can reach them from another sheet. If I want to test a new part of program. Only the variables in this sheet are initialized newly... ... and I get unexpected errors with totally idiotic error messages . if mark this step with a stop and run again then it works without error message i have have to restart the new part several times till it works without error messages ( I do not change anything in the program ) I think this has to do with initialisation of variables from other modules Actual Results: Basic Laufzeitfehler "13" Expected Results: no error Reproducible: Sometimes User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: de Module: BasicIDE [Information guessed from browser] OS: Linux (All) OS is 64bit: yes
Created attachment 170111 [details] impossible error message first run error was thrown in the line above the marked one then i did a rerun and it ran over that line without an error and stopped in the next line. ... and as you see in the observer field this message can't be correct
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 170562 [details] this file is under development it took time to depersonalize it when trying to repair errors and i run the this part for the first time it stucks with eroor message and if i run it for a second time it starts to work
Dear Harald Langheinrich, This bug has been in ASSIGNED status for more than 3 months without any activity. Resetting it to NEW. Please assign it back to yourself if you're still working on this.
This was accidentally set to assigned, let's wait until someone else can confirm the bug.
(In reply to Harald Langheinrich from comment #3) > Created attachment 170562 [details] > this file is under development it took time to depersonalize it Hi... Have you been able to solve this issue? I am trying to reproduce this bug, but I can't find which macro triggers the problem. Can you please provide a set of steps that cause the error so that I can reproduce it with the provided sample file?
Is this relevant: I clicked Rechnungs-Liste Zeigen Rechnung-Liste exportierern and got BASIC runtime error. '12' Variable not defined. Additional information: Auftrag_PfadDateiName Arch Linux 64-bit, X11 Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 74501c5da13634632259f738d59b0273e2417147 CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 13 February 2023
@Harald, how to reproduce the bug with your file? Thank you
Dear Harald Langheinrich, 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 Harald Langheinrich, 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