https://bugs.documentfoundation.org/show_bug.cgi?id=174436
Lichen Cao <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 CC| |[email protected] Status|UNCONFIRMED |NEW --- Comment #1 from Lichen Cao <[email protected]> --- Reproducible with the attached file, before editing the named range, Ctrl+/ on B2 selects B2:B11. After opening Manage Names, adding a character to the unrelated name range and deleting it (unrelatedRange -> unrelatedRangew -> unrelatedRange), then clicking OK, Ctrl+/ on B2 only selects B2:B6, the #N/A cells are no longer part of the array. Reproduced in: Version: 26.8.2.2 (X86_64) Build ID: 9dea406ab7695df6325b11b0e19fdca8db4b7276 CPU threads: 12; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded Version: 27.2.0.0.alpha0+ (X86_64) Build ID: e42678e74a8b43e143a395e3fe08a9e2a923f0f9 CPU threads: 12; OS: Windows 11 X86_64 (build 26100); 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.
