Bug 145922 - Basic error Dimension specifications do not match when opening file
Summary: Basic error Dimension specifications do not match when opening file
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-11-28 03:33 UTC by Daniel Deberque
Modified: 2023-09-07 13:17 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
fichier de gestion d'animations golf (29.27 MB, application/vnd.ms-excel.sheet.macroEnabled.12)
2021-11-28 03:47 UTC, Daniel Deberque 		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 Daniel Deberque 2021-11-28 03:33:12 UTC 
Description:
Crash if I open the file
fichier enregistrés en octobre 2019

Steps to Reproduce:
1.open file
2.
3.

Actual Results:
message : Erreur de syntaxe BASIC
Speification de dimensions incohérentes

Expected Results:
ouverture du fichier


Reproducible: Always


User Profile Reset: No



Additional Info:
ouverture bloquée
Comment 1 Daniel Deberque 2021-11-28 03:47:12 UTC 
Created attachment 176542 [details]
fichier de gestion d'animations golf
Comment 2 Nii 2021-11-28 09:39:54 UTC 
Hi, I could get the file to open in both 

Version: 7.2.2.2 (x64) / LibreOffice Community
Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: fi-FI (fi_FI); UI: fi-FI
Calc: CL 

and 

Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: ec76fff198323122bedc63ffdfd896c2543102c6
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: fi-FI (fi_FI); UI: fi-FI
Calc: CL 

although it warned me both times that the file is too big to open all the information (sorry about the possibly bad translation, my libreoffice is in another language)
Comment 3 m_a_riosv 2021-11-28 16:26:45 UTC 
The warning it's about exceeding 16K columns, but accepting it open without any crash.
Version: 7.2.3.2 (x64) / LibreOffice Community
Build ID: d166454616c1632304285822f9c83ce2e660fd92
CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL
Comment 4 Mike Kaganski 2021-11-29 09:46:37 UTC 
IIUC, the error in question here is not the one about too many columns, but - the one when you allow macros, and then the macro 'Sub Tableau_Serie(Type_Serie)' in 'Module 1' errors on line 165:

> BASIC syntax error.
> Dimension specifications do not match.

(In reply to Daniel Deberque from comment #0)
> Steps to Reproduce:
> 1.open file
> 2.
> 3.

So indeed, the steps from comment 0 are not enough; #2 and #3 should be 'Accept "The data could not be loaded completely because the maximum number of columns per sheet was exceeded" warning', and 'Enable macros when asked'.

Repro using Version: 7.2.3.2 (x64) / LibreOffice Community
Build ID: d166454616c1632304285822f9c83ce2e660fd92
CPU threads: 12; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded

and current master.