Bug 126750 - Macro not working .xlsm
Summary: Macro not working .xlsm
Status: RESOLVED DUPLICATE of bug 118246
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
 
Reported: 2019-08-07 15:04 UTC by nicolas.maltais
Modified: 2021-10-02 14:18 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
test file (969.21 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2019-08-07 15:57 UTC, raal
Details

Note You need to log in before you can comment on or make changes to this bug.
Description nicolas.maltais 2019-08-07 15:04:56 UTC
Description:
Macro for image insertion give's me error 423 on line : 38
I guess file is created on Microsoft office and it's working on it.

Link to the file:
https://www.mamh.gouv.qc.ca/fileadmin/publications/infrastructures/strategie_quebecoise_eau_potable/rapport_verification_precision_debitmetres.xlsm

Steps to Reproduce:
1.Open the file ''rapport_verification_precisiondebitmetres.xlsm''
2.Go to TAB: ''Rapport de vérification''
3.Fill the case '' Line 11, case ''O'' with number ''1''
4. Line 142: clic on ''Image 1''


Actual Results:
Observe the opening of the VBAProject - Libreoffice basic Error:
-Basic error 423 GetOpenFilename on line 38

Expected Results:
Be able to insert picture on the file


Reproducible: Always


User Profile Reset: No



Additional Info:
Open error windows in libre office basic.

Version: 6.2.5.2 (x64)
Build ID: 1ec314fa52f458adc18c4f025c545a4e8b22c159
Threads CPU : 4; OS : Windows 10.0; UI Render : GL; VCL: win; 
Locale : fr-CA (fr_CA); Langue IHM : fr-FR
Calc: threaded
Comment 1 raal 2019-08-07 15:57:18 UTC
Created attachment 153204 [details]
test file
Comment 2 Roman Kuznetsov 2019-08-07 19:53:32 UTC
confirm in

Версия: 6.2.5.2
ID сборки: 1:6.2.5-0ubuntu1
Потоков ЦП: 4; ОС:Linux 5.2; Отрисовка ИП: по умолчанию; VCL: gtk3; 
Локаль: ru-RU (ru_RU.UTF-8); Язык UI: ru-RU
Calc: threaded

and in 6.4 build from 30 June 2019
Comment 3 Xisco Faulí 2019-08-08 10:23:35 UTC
Also reproduced in

Version: 5.3.0.0.alpha1+
Build ID: 3aec456ba8a0d1f9aef2fc1735d1861fe9d3a98c
CPU Threads: 4; OS Version: Linux 4.15; UI Render: default; VCL: gtk3; Layout Engine: new; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group
Comment 4 Xisco Faulí 2019-08-08 10:25:37 UTC
No error in

Version: 4.3.0.0.alpha1+
Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e

but nothing happens either... Adding bibisectRequest to see when the error started
Comment 5 Aron Budea 2020-07-25 23:19:38 UTC
I bibisected this to the following commit using repo bibisect-44max... but it surely isn't the correct one (but this _is_ the result).

https://cgit.freedesktop.org/libreoffice/core/commit/?id=0d602133d627c1837eb64895855c2a7ed0144de6
author		Miklos Vajna <vmiklos@collabora.co.uk>	2014-06-16 18:45:05 +0200
committer	Miklos Vajna <vmiklos@collabora.co.uk>	2014-06-17 01:16:20 +0200

svx: fix VML export of rectangles imported from drawingML
Comment 6 raal 2021-10-02 14:18:52 UTC
“GetOpenFilename” method not supported yet, set as duplicate.

*** This bug has been marked as a duplicate of bug 118246 ***