https://bugs.documentfoundation.org/show_bug.cgi?id=168492
Bug ID: 168492
Summary: When applying "Cell range" as data validity on a
column, I cannot change sheets nor close document nor
the app
Product: LibreOffice
Version: 25.8.1.1 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Using Data->Validity with a cell range gives illogical results and makes the
application behave badly.
Steps to Reproduce:
1. Create a first sheet
2. Create a second sheet (named "Breeds") with a list of categories to choose
from (say dog breeds)
3. On the first sheet, create an array with 3 columns ['Name', 'Age', 'Breed']
4. Select the 'Breed' column and click Data->Validity... in the menu
5. In the newly opened popup, in the Criteria tab, select Allow: Cell range
6. Check Show selection list
7. [PROBLEM] To select source, try using the selection tool (It doesn't work
for me)
8. Type $Breeds.A1:A120
9. Validate with OK
10. [PROBLEM] Select individual cells of the columm and go back to
Data->Validity... Observe how the source range is offset according to the
cell's row
11. [PROBLEM] Try to navigate to the "Breeds" sheet (clicking has no effect for
me)
12. Try closing the application (nothing happens and I have to use the Task
Manager to kill it)
Actual Results:
Data validity is based on cell range is not usable as is (or needs to be set
for each individual cell of the sheet, which does scale poorly with data size)
Application becomes unrealiable : cannot swap sheets, cannot close it properly
Expected Results:
Regarding data validity, I except the same cell range to be applied to each
cell of the selected column
Regarding the reliability, I expect the application to behave normally after
such operations
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 25.8.1.1 (X86_64)
Build ID: 54047653041915e595ad4e45cccea684809c77b5
CPU threads: 12; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster;
VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
