Apache OpenOffice (AOO) Bugzilla – Issue 22475
Background macro stops data entry in another sheet.
Last modified: 2017-05-20 11:13:54 UTC
While working on a project, I was runing a spreadsheet macro to do some curve fitting. While this was running I thought I would enter data into another spreadsheet but found that this was impossible. As I entered a number, it would suddenly be as if I hit a key to stop editing. This occurs even if the spreadsheet running the macro is minimized. I have tried this multiple times and I can recreate the problem every time. I am not sure if the graph in the spreadsheet with the macro is doing this but if it is, it could be a problem related to speed and thread processing. I feel that if the spreadsheet is in the background, it shouldn't affect other OOo functions. I also noticed that I could not close a Writer window if the macro was running.
Created attachment 11268 [details] Issue spreadsheet with the macro for testing.
Instructions to recreate the problem. Open the spreadsheet with the macro. - On the FitOO sheet, click the Initialize button. - Go to the Raw_data sheet and copy columns A-C data. - Go to the Datas sheet and paste the data into A2. - Open a new spreadsheet. - Go to the FitOO sheet and click the Calculate button. - While the macro is running, try to enter data in the new spreadsheet. Also, open a writer document and try to close it while the macro is running. This issue may be one item that is affecting OOo speed due to background processing.
Hi Niklas, I think it's your construction site. Please comment. Frank
I was able to partially reproduce the bug. The new spreadsheet or writer failed to close during macro operation. However, i was able to enter and edit data in both spread sheet and writer. I think that the problem is the lack of warning message for illegal operations. In another words, close is not allowed during macro operation to allow a successful macro termination, and this causes the slow behavior of the computer. I think it would help the user to get a message asking them to wait till terminated instead of luck of response.
The problem is reproducible in Ooo1.1.0 under Linux 2.4.26 i686 Intel Celeron 766MHz 128MB RAM as reported. I tried to work on other applications and they worked fine(e.g save, insert new files ...). However, I couldn't close them. I also tried to replicate the bug in Ooo1.1.3, Ooo1.1.4 on Window XP build 2600. Intel Pentium 3 processor 996MHz, 512MB of RAM and on Window 2000 x86 Family 6 Model 5 Stepping 2 AT/AT compatible 196,148 KB RAM. When I opened the new spreadsheet while I was running the spreadsheet macro the cells were always in edit mode(enter one number and then enter second number which is replaced the previous one). The defect was the same as reported. However, the difference was that I could close any new opened applications. If it is problem of Openoffice software, I think it should be fixed in new version because the software should let users running 2 spreadsheet at the same time for a multitasking system.
I feel that this issue can be closed if people can upgrade to OOo 1.1.4 I just tried it in 1.1.4 and I could enter all the data I wanted with no problems. I also must report that the macro runs much faster in 1.1.4 than in 1.1.1. It also runs alot faster in 2.0 beta.
It has been over a year since I felt that this bug could be closed as it is fixed in the latest releases.
Reset assigne to the default "issues@openoffice.apache.org".