[Libreoffice-bugs] [Bug 152134] assign user macro to Tools menu fails on V7.4.2.3.x64 (Windows11) works on Windows8.1 V6.1 (same sheet)

2022-12-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=152134

--- Comment #12 from wzpd...@gmail.com ---
Created attachment 183989
  --> https://bugs.documentfoundation.org/attachment.cgi?id=183989&action=edit
FAILING CALC ODS FILE

Reopened:
Assign function worked on LO v7 using simple sample file but still fails on
v7.4.3 using more complex sheet attached. Data removed from pages but macro
function ccan be tested.
1. Go to Assign Function > menu Tools/Customize
2. Find "Target" Tools-EXECUTE submenu
3. Select Categories Macros/TRYTHISONE/Module2/TEST  (not TestA)
4. Insert to Submenu EXECUTE
5. Select "OK"

System fails and forces recovery. Macro not Assigned.
All the Tools User-macros and Submenu EXECUTE have been added with 
LO v6 since not possible using v7.

Bug still persists.
Have reinstalled v6. Will remain on V6 until bug is resolved.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 152134] assign user macro to Tools menu fails on V7.4.2.3.x64 (Windows11) works on Windows8.1 V6.1 (same sheet)

2022-12-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=152134

wzpd...@gmail.com changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|FIXED   |---
 Ever confirmed|0   |1

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 152134] assign user macro to Tools menu fails on V7.4.2.3.x64 (Windows11) works on Windows8.1 V6.1 (same sheet)

2022-12-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=152134

wzpd...@gmail.com changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |FIXED

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 152134] assign user macro to Tools menu fails on V7.4.2.3.x64 (Windows11) works on Windows8.1 V6.1 (same sheet)

2022-12-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=152134

--- Comment #11 from wzpd...@gmail.com ---
Created attachment 183987
  --> https://bugs.documentfoundation.org/attachment.cgi?id=183987&action=edit
sample macro assignment test sheet

Have installed LO v7.4.3 and run macro assignment test using the sample sheet
provided. Assignment now works with this version of LO on Windows 11 2H22.
Thanks.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 152134] assign user macro to Tools menu fails on V7.4.2.3.x64 (Windows11) works on Windows8.1 V6.1 (same sheet)

2022-11-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=152134

wzpd...@gmail.com changed:

   What|Removed |Added

 Ever confirmed|1   |0
 Status|NEEDINFO|UNCONFIRMED

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 152134] assign user macro to Tools menu fails on V7.4.2.3.x64 (Windows11) works on Windows8.1 V6.1 (same sheet)

2022-11-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=152134

--- Comment #10 from wzpd...@gmail.com ---
Yes aware Customize can be accessed via Tools/Customize. Same code and error is
at close though. 
Would note running Win 11 not 10 so may be difference there.
Have tried Safe mode with this system with same result.
Might take a while but I will try 7.4.3 to see if I can reproduce via any of
the three paths mentioned including Safe mode.
Will report results.
Thanks

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 152134] assign user macro to Tools menu fails on V7.4.2.3.x64 (Windows11) works on Windows8.1 V6.1 (same sheet)

2022-11-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=152134

--- Comment #9 from Stéphane Guillou (stragu) 
 ---
I could not reproduce the issue with:

Version: 7.4.3.2 (x64) / LibreOffice Community
Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded

nor:

Version: 7.4.3.2 / LibreOffice Community
Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: de-DE (en_AU.UTF-8); UI: en-US
Calc: threaded

Do you know that you can access the Customize menu directly from "Tools >
Customize"?
Do you also have the same issue when adding the macro to the menu using "Tools
> Customize directly"?

Please also try:
- Installing version 7.4.3, and see if issue persists
- See if you still see the issue in Safe Mode (Help > Restart in Safe Mode)

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 152134] assign user macro to Tools menu fails on V7.4.2.3.x64 (Windows11) works on Windows8.1 V6.1 (same sheet)

2022-11-29 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=152134

--- Comment #8 from wzpd...@gmail.com ---
SheetX and TaskA are ficticous generics easily created from blank LO. The bug
was found using confidential data that cannot be shared. 
There is sparce to no "help" for this function in LO Help function. Might be a
good work item for someone to generate some helpful text.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 152134] assign user macro to Tools menu fails on V7.4.2.3.x64 (Windows11) works on Windows8.1 V6.1 (same sheet)

2022-11-29 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=152134

Stéphane Guillou (stragu)  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 Blocks||107659
 Ever confirmed|0   |1

--- Comment #7 from Stéphane Guillou (stragu) 
 ---
Did you forget to attach sheetX.ods? If so, you can use the "Add an attachment"
button above.
Or are you not sharing it because of sensitive data?


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=107659
[Bug 107659] [META] Macro bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 152134] assign user macro to Tools menu fails on V7.4.2.3.x64 (Windows11) works on Windows8.1 V6.1 (same sheet)

2022-11-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=152134

QA Administrators  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 152134] assign user macro to Tools menu fails on V7.4.2.3.x64 (Windows11) works on Windows8.1 V6.1 (same sheet)

2022-11-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=152134

--- Comment #6 from QA Administrators  ---
[Automated Action] NeedInfo-To-Unconfirmed

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 152134] assign user macro to Tools menu fails on V7.4.2.3.x64 (Windows11) works on Windows8.1 V6.1 (same sheet)

2022-11-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=152134

--- Comment #5 from wzpd...@gmail.com ---
Thanks for the response.
Steps taken:

Open libreoffice sheetX.ods
Go to Tools menu
Go to Macros
Go to Organize Macros
Go to LibreOffice Basic
Open sheetX.ods choice
Open Standard
Select/open Module3
Select TestA macro in Module3
Select Assign from right side menu
(Lo then presents Customize menu)
Right side: Select Target .. Tools
Go to left side and select 
Category .. Macros
Open sheetX.ods choice from macro list
Select Module3, select TestA macro
Use "Add Item" arrow (right pointing toward Function section)
TestA macro appears in Tools list.
Move TestA down in Tools list to appropiate position.
Click OK option at bottom. (** see note at end re behavior change using v7 at
this point **)
Then Close.

For version 6 this returns to the open spreadsheet (sheetX.ods)

The Tools menu now displays TestA option and that option now executes the macro
TestA when selected. Spreadsheet can be closed normally and subsequently
reopened with the TestA macro option still in Tools menu and functional.

(** at the point marked above by the note, when using v7 the sheet
automatically aborts .. closes ? .. and the attempt to reopen results in
"Recovery" option menu. 
Recovery results successfully but the Tools option list is back to "before the
Assign attempt", the macro is still available in the module 3 and can be run
using Tools/Macros/Run Macro function. **)

The Assign process is the fail. Works as described for V6, fails as described
is using V7.

I have fallen back to V6 to use this function.

An aside is when the sheetX is modified using v6 and LO is upgraded to v7 the
Tools list contains the macro assigned using v6 and can be run normally from
the Tools menu. So the fail is in v7 Assign process code.

All attempts in this example are run on current Windows 11 home system, version
22H2.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 152134] assign user macro to Tools menu fails on V7.4.2.3.x64 (Windows11) works on Windows8.1 V6.1 (same sheet)

2022-11-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=152134

Stéphane Guillou (stragu)  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO
 CC||stephane.guillou@libreoffic
   ||e.org
Summary|assign user macro to Tools  |assign user macro to Tools
   |menu fails on V7.4.2.3.x64  |menu fails on V7.4.2.3.x64
   |(Windows11) works on|(Windows11) works on
   |Windows8.1 V4..(same sheet) |Windows8.1 V6.1 (same
   ||sheet)

--- Comment #4 from Stéphane Guillou (stragu) 
 ---
Could you please provide:

- A precise series of steps to reproduce the issue
- If possible, an example document that makes it easier to reproduce the issue
- The information copied from "Help > About LibreOffice"

Thank you!

-- 
You are receiving this mail because:
You are the assignee for the bug.