https://bugs.freedesktop.org/show_bug.cgi?id=79588
Priority: medium
Bug ID: 79588
Assignee: [email protected]
Summary: Macros called from within formulas doesn't survive
save, close and reopen of the calc-document.
Severity: blocker
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.2.3.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 100358
--> https://bugs.freedesktop.org/attachment.cgi?id=100358&action=edit
Used to calculate money of accounts for different month
Hi all,
reading the existing bugs doesn't confirms me, that my error behaviour belongs
to one of them.
I use Ubuntu 14.04 release with a LXDE-Desktop on a i386 notebook with 8GB ram.
Don't know whether this helps.
I created own macros and stored them within the .ots file within a new library
within a new module.
I assigned some to buttons of a symbol bar, some to graphical objects and some
I needed to call from within formulas stored within a cell.
Every macro ran and did its job.
I saved and closed the document.
Opening the document to continue my work the following behaviour was present.
Macros assigned to buttons of symbol bars and graphical objects are called and
worked well.
Macros used within formulas seem to be unknown there.
1) Was the macro built with some capital letters, its name within the formula
is now completely written in lower case letters.
2) Depending on the formula of the cell, sometimes it returned sometimes
#NAME!.
3) None of the macros used within formulas seem to be called.
The name and code of the macros itself within the code module look unchanged
and Ok like before.
Result - My sheet doesn't work anymore after saving, closing and opening again.
Workaround1 (but not practical for many formulas):
1) I have to edit something within the macro module and save it again.
2) Then I need to correct the call of the macro within the formula.
Then the stuff works again for this session.
Workaround2 (not always possible):
I try to use no macro if possible.
Hope you can help me,
Bernhard
--
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
