Bug 126750 - Macro not working .xlsm
Summary: Macro not working .xlsm
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2 all versions
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: 2019-08-08 10:25 UTC (History)
3 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