https://bugs.freedesktop.org/show_bug.cgi?id=70902
--- Comment #11 from [email protected] --- The Function that I am writing is too convoluted at this point, and causing too many problems and crashes, so I have repeated the problem using a simpler code example that computes the volume of a cylinder, and has the same Err:520 problems. I wrote the Function first and then tried to use it in a simple spreadsheet named CylinderVolumeSpreadsheet.odt (attached). Also attached are Screenshots that show some of the problems as follows: Screenshot-00-CylVol.png - shows the "Err520" problem on a newly opened spreadsheet. The only action after opening LibreOffice Calc was to click Insert (menu) => Function. Screenshot-01-CylVol.png - shows a "Read Error", but if I click "OK", then the whole Calc program crashes (closes) unexpectedly. I want to try changing "pi" to "pie", but can't do it with the crashes. Screenshot-02-CylVol.png - Shows the Function Wizard window which does not work to insert my function, but in this case, Result field does not show "Err:520" despite the fact that there is a problem. Screenshot-03-CylVol.png - I'm now deeper into the problem, still can't insert my function, but now the "Err:520" is showing in the Result field of the Function Wizard. Incidently, trying to enter the function into cell C1 does not work and results in "#NAME" in the cell. Calc has various responses when entering the function into a cell directly by typing it, but not of these are helpful in determining what or where the problem is. Screenshot-04-CylVol.png - See item 10. in the procudure that follows. Here is a skeleton outline of the procedure I followed to write the macro and use it in a spreadsheet. 1. Open LibreOffice Calc from the Debian Xfce GUI 2. Click Tools => Macros => LibreOffice Basic => Edit 3. Wrote the function: (also shown by Screenshot-01-CylVol.png) Function CylVol(r, h) Let pi=3.14159 CylVol = pi * r * r * h End Function 4. Saved it. 5. Click on spreadsheet to make it active and create a simple 3-column spreadsheet. Saved it. 6. Attempt to insert my function in cell C2 using the Function Wizard (Insert (menu) => Function) 7. My User Defined function was not found in the Function Wizard list of functions, and had the Err:520 8. Tried entering function in cell C2 as "=CylVol(A2, B2)", but got "#NAME" 9. Save as CylinderVolumeSpreadsheet.odt This is the attachment. 10. Close Calc, Open Calc, open CylinderVolumeSpreadsheet.odt. At this point there is beep caused by some error, the macro window editor pops ups, along with an error message. When I try to close the error window to see the spreadsheet, then more beeps and the main spreadsheet closes. Now I can't close the remaining macro editor window because it thinks it is needed by the spreadsheet, but it has closed. I'm too far into various errors and inoperative windows now, and can't do much of anything else. Nevertheless, the common denominators are the "Err:520" and not being able to insert my function since the errors messages and crashes make it impossible to do anything. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
