https://bugs.documentfoundation.org/show_bug.cgi?id=142063
Bug ID: 142063
Summary: Writer and Calc macro problems with update to LO
7.1.2.2
Product: LibreOffice
Version: 7.1.2.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: lg7896-li...@usa.net
Description:
I'm in the position of [this
OP](https://ask.libreoffice.org/en/question/207552/how-can-i-import-a-macro-bas-file-into-calc/?answer=307533#post-id-307533).
The answer included the statement **"Installing a new version of LO should
have no effect on macros."** Three notes.
1) I've updated before, and the statement above has been true. Very good to be
able to rely on that.
2) I just updated to 7.1.2.2 (x64), Win 10, and I lost ALL my macros and
assigned keystrokes. Luckily I had a *.bas file from Nov 2020. **The process in
that answer worked.** But I had to reassign my keystrokes, and all changes
since then are lo, And if I hadn't exported to bas in Nov I'd have to go back
even further. I'd much rather avoid this.
3) So far, I can't save **one macro** that sets a date **to Ctrl-Shft-T in
Writer** (to start a journal entry) and save **a different macro** that puts a
date in a cell **to Ctrl-Shft-T in Calc**. I used to be able to do this, and
it was good since conceptually they do the same thing (date an entry). Now
after setting one in Writer (Writer radio button is set), when I switch to Calc
the same macro appears even though the Calc radio button is set. If I choose
the macro I designed for Calc, the Writer one is replaced in Writer.
I can use different keystrokes for Calc/Writer and be sure to manually back up
all my macros before updating. But (a) #2 above isn't great, and (b) my old
functionality in #3 above used to work, which seems intentional because of the
radio buttons.
Steps to Reproduce:
1. create 2 user macros in an earlier version and assign one to CTRL-SHFT-T in
writer and the other to CTRL-SHFT-T in Calc.
2. save the macros in a *.bas file.
3. Update to 7.1.2.2
4. All macros and keystroke assignments were gone for me
5. Import the macros created in #1.
6. Assign macro A to CTRL-CHFT-T in Calc. Radio button for Calc should be
showing. (I didn't see one for Writer.)
7. Assign macro B to CTRL-CHFT-T in Writer. Radio button for Writer should be
showing. (I didn't see one for Calc.)
8. In Calc, check the keystroke assignment -- it should show macro B.
Actual Results:
Different macros can't be assigned to the same keystroke combination in Calc
and Writer.
Expected Results:
? I used to be able to update without losing macros and key assignments. I used
to be able to assign different macros to the same keystroke combination in Calc
and Writer.
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
7.1.2.2 (x64)
build
https://git.libreoffice.org/core/+log/8a45595d069ef5570103caea1b71cc9d82b2aae4
cpu threads 12
O/S win 10 bulid 19041
interface UI render SkiaVulkan; VCL; win
locale: en-US; UI en-US
Below: "When noticing strange behavior in LibreOffice the first thing to do is
to reset the user profile. To do so, 2 methods are available."
Please put those steps somewhere Earlier in this reporting process.
I'm a user, not a programmer. I've already lost 1 1/2 hours to researching and
finding a workaround for these problems. This included searching the web for
how to import *.bas, since the topic doesn't seem to be in the online help
system.
I don't have that kind of time. Rather than installing something for opengl (if
I need to) and rebooting my system for the profile and entering all this
information again, I'm going to submit without it. Sorry, but I have other
things I need to do.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
