Bug 161323 - excel file has visual bugs with form controls, character spacing and vlookup in form controls errors
Summary: excel file has visual bugs with form controls, character spacing and vlookup ...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-05-29 16:55 UTC by johnks
Modified: 2024-06-14 03:18 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
excel form control (68.31 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2024-05-29 16:56 UTC, johnks
Details

Note You need to log in before you can comment on or make changes to this bug.
Description johnks 2024-05-29 16:55:58 UTC
Description:
attached is file downloaded from https://www.exceldemy.com/learn-excel/form-control/

https://www.exceldemy.com/wp-content/uploads/2023/07/Excel-Form-Control.xlsm

the file opens and works as expected in excel but in calc it has multiple issues including

1. form controls are either missing or incorrect from excel.
2. vlookup does not work in any form control in calc but works in excel
3. character spacing looks bad in calc but excel it works fine

Steps to Reproduce:
1. navigate to https://www.exceldemy.com/learn-excel/form-control/ and donwload the file
2. check form controls are either inveterd, or missing or wrong in calc
3. check if any data is shown in the filter or controls 
4. in "Checkbox" and "groupbox" sheet, selecting profit does nothing in calc. only loss works. in excel both work.
5. scrollbar is wrong,  option sheet is not working, list is not working, spin is wrong and is not working, combo box is also not working

Actual Results:
not working as it should 

Expected Results:
it should work


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 24.2.0.3 (X86_64) / LibreOffice Community
Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1
CPU threads: 12; OS: Windows 10.0 Build 17763; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
Comment 1 johnks 2024-05-29 16:56:15 UTC
Created attachment 194431 [details]
excel form control
Comment 2 Buovjaga 2024-06-13 08:07:37 UTC
If the file has multiple issues, a separate report should be created for each issue.