Bug 154100 - FORMCONTROLS: unable to migrate Excel Form to Calc
Summary: FORMCONTROLS: unable to migrate Excel Form to Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.5.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
 
Reported: 2023-03-09 18:59 UTC by Dav
Modified: 2023-03-18 13:27 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Excel source that can be migrated to Calc (Userform) (580.50 KB, application/vnd.ms-excel)
2023-03-10 07:28 UTC, Dav
Details
Excel file allowing to reproduce the userform migration problem to Calc (476.53 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2023-03-11 08:44 UTC, Dav
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Dav 2023-03-09 18:59:02 UTC
Greetings,

I have a very old Excel to migrate to Calc.
In the Excel file, there is a form with 4 tabs and many fields in each tab.
When I open this excel file with calc, the form is not properly handled and the tabs do not appear in design mode.
Any hint would be much appreciated.
Thanks a lot by now.
Have a nice and safe evening.
Eric
Comment 1 raal 2023-03-09 20:11:44 UTC
please attach the file. Thank you.
Comment 2 Dav 2023-03-10 07:28:18 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2023-03-11 03:24:57 UTC Comment hidden (obsolete)
Comment 4 Dav 2023-03-11 08:44:06 UTC
Created attachment 185904 [details]
Excel file allowing to reproduce the userform migration problem to Calc
Comment 5 Dav 2023-03-11 08:49:58 UTC
Greetings,

I realize that the first file I did upload is not good enough to reproduce the userform migration problem from Excel to Calc.
I therefore just uploaded "bug 154100 _v1.2.xlsm" that is coming from Excel 2019. The README_FIRST tab explains the problem when opening this Excel file with Calc.
I hope this helps.
Thanks a lot for your precious time and help.
Have a nice and safe day.
Dav
Comment 6 raal 2023-03-18 12:37:32 UTC
Confirm with Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 7a7eb4aa21ca0c83db825fe8d5a5278611b391d8
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

Userform's control are not visible in design mode, but I can see the controls when I click on the Control panel button
Comment 7 Dav 2023-03-18 13:27:26 UTC
(In reply to raal from comment #6)
> Confirm with Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
> Build ID: 7a7eb4aa21ca0c83db825fe8d5a5278611b391d8
> CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
> Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
> Calc: threaded
> 
> Userform's control are not visible in design mode, but I can see the
> controls when I click on the Control panel button

Greetings raal,

Thanks a lot. We are in sync so far :-)
May I please kindly ask you for a download link for Version: 7.6.0.0.alpha0+ (X86_64) ?
I do not find it in the list at: https://dev-builds.libreoffice.org/pre-releases/rpm/x86_64/

Thanks again for your precious help.
Have a nice and safe day.
Dav