Description: When you create or edit a formula, "Name box" will remain switched to "Last Used Functions list". Steps to Reproduce: 1. Open new calc. 2. Insert "=1" in Cell [A1]. 3. The "Name box" switches to the "Last Used Functions list". 4. Select Cell [A2]. Actual Results: 5. "Name box" is still "Last Used Functions list". Expected Results: 5. The "Name box" returns to its normal display. If a named range is defined, it is displayed. Reproducible: Always User Profile Reset: No Additional Info: If you define a new named range, the "Name box" returns to the normal display, but if you edit the formula, the "Name box" remains in the "Last Used Functions list". Not reproducible with Version: 25.2.3.2 (X86_64) / LibreOffice Community Build ID: bbb074479178df812d175f709636b368952c2ce3 CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: en-US (ja_JP); UI: en-US Calc: CL threaded Reproducible with Version: 25.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 6190fe56f72008e0b6d0e502bf94099e72b9d202 CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: en-US (ja_JP); UI: en-US Calc: CL threaded
Created attachment 200902 [details] Screenshot with 25.8 Reproducible Version: 25.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 6190fe56f72008e0b6d0e502bf94099e72b9d202 CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Bisected with linux-64-25.8 Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: a8bffc1c6a9296294625e75e3ddfb42931d91586 CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: ja-JP (ja_JP.UTF-8); UI: en-US Calc: threaded author Rashesh commit a8bffc1c6a9296294625e75e3ddfb42931d91586 sc: fix: unnecessary updates to ScPosWnd when named range are empty - follow up 115776004c875b3a8a861d070129187c893b136a Change-Id: I57072d1999e703975a43dc50077698d4b28df461 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/175869
Thank your for the report. Let me check :)
Fix https://gerrit.libreoffice.org/c/core/+/185747
Rashesh committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/2167fa8aa5592e04a929cde2cd86a07bad49efde tdf#166674: sc: fix "Name box" remain switched to "Last Used Function List" It will be available in 25.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.