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 tree / graph
 
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
View All Add an attachment (proposed patch, testcase, etc.)

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 ***