https://bugs.documentfoundation.org/show_bug.cgi?id=154710
Bug ID: 154710
Summary: Error saving Calc
Product: LibreOffice
Version: 7.5.2.2 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: ne...@atlas.cz
Description:
Description :
While programming, I found that I could not save Calc. I failed to test the
error and without saving the code worked normally. It is that the LO does not
report the problem in any way. Only work cannot be saved. I ended up having to
drop the LO manually. I especially suspected Windows OS. I found a way to
partially bypass the problem. I saved the modified macro as an export of the
Basic module and after closing Calc I immediately loaded it and continued.
Solution:
In desperation, I installed the latest version of Apache OpenOffice 4.1.14 and
the error appeared after running. An error message popped up in the code for
the button inserted into the cell
Dim oObjAnchor as object
oShape.Size = oSize
oDrawPage.add(oShape)
oObjAnchor = oShape.Anchor
with oShape
.Anchor = oObjAnchor.getCellByPosition(17,5)
end with
The error was on the line with .Anchor = oObjAnchor.getCellByPosition(17,5).
Instead of a button, I used a hyperlink to run the macro - and the problem
ended in LO. But it is not the solution to the essence. I reported the problem
on the forum under the name "paratrooper macro" because the program does not
end by itself - I have to jump out of it myself.
Steps to Reproduce:
1. Download the basic module called Error saving Calc
2. Paste in a new workbook
3. Run the Main macro
4. Try to save the workbook with the generated Bubble Sort sheet
Actual Results:
After generating the sheet with the main macro, the content of the bubble sort
demonstration will appear with comments and the option to repeat the
demonstration with the button. This works fine, but the workbook cannot be
saved.
Expected Results:
Calc freezes when saving and LO must be restarted.
Reproducible: Always
User Profile Reset: No
Additional Info:
Calc should have saved normally.
--
You are receiving this mail because:
You are the assignee for the bug.
