https://bugs.documentfoundation.org/show_bug.cgi?id=161323

            Bug ID: 161323
           Summary: excel file has visual bugs with form controls,
                    character spacing and vlookup in form controls errors
           Product: LibreOffice
           Version: 24.2.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

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

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to