Description: every time i use the function wizard, i run into 2 issues: - when i try to select a range, it only enters a fraction of that range into the input field. like, when i select A18:B25, something like B22:B25 appears in the input field in the function wizard and i have to correct it manually. very annoying. - every time the function wizard window minimizes (when i select a range) and then maximizes again, it ends up too narrow for its contents, which means some info on the right side (like the result of the formula) is hidden and i have to widen the window manually. also very annoying. i selected 25.8.3.2 as the version because that is the version i have. i don't know if these problems also exist in other versions. Steps to Reproduce: 1. create a new spreadsheet and select a cell. 2. go into the function wizard and select VLOOKUP 3. click on the input field named "array" 4. back in the spreadsheet window, select a range of cells 5. check if the entry in the input field matches the selected range. Actual Results: the entry in the input field represents a fraction of the actual selected range. Expected Results: the selected range should match the entry in the input field. Reproducible: Always User Profile Reset: No Additional Info:
I cannot confirm it. The range I select is correctly entered in the field in the function wizard. Tested with Version: 25.8.3.2 (X86_64) Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e CPU threads: 32; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: de-DE (de_DE); UI: en-US Calc: threaded Please go to Help > About and click on the `Version Information` button. That puts an information like the one above into the clipboard. Then enter this information in the bug report.
Also, please test with Menu>Help>Restart in Safe Mode.
(In reply to hmiersch from comment #0) > - when i try to select a range, it only enters a fraction of that range No. I can't reproduce. > - every time the function wizard window minimizes (when i select a range) > and then maximizes again, it ends up too narrow for its contents Yes. I can reproduce. Tested with: Version: 24.8.7.2 (X86_64) / LibreOffice Community Build ID: 480(Build:2) CPU threads: 4; OS: Linux 6.4; UI render: default; VCL: gtk3 Locale: es-MX (en_US.UTF-8); UI: en-US Calc: threaded