https://bugs.documentfoundation.org/show_bug.cgi?id=168618
Bug ID: 168618
Summary: Serious error when changing validity rules in Calc.
Refer to version 25.8.1.1
Product: LibreOffice
Version: 25.8.1.1 release
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Having a validaten Rule with a cell area as criterion (others not tested) and
try to change just the area for example from $work.$A$5:$A$10 to
$work.$A$5:$A$20 calc goes crazy. For example if you have more than one table,
you can't change tables. No reaction. For a double click, the "change table
name" window apears, but thats all. Even close Calc didn't work. I had to close
with taskman.
(sorry for my bad english, I'm german :) )
Steps to Reproduce:
1. open empty calc, add a second table and go back to the first one
2. enter A1:A3 three lines of simple words for the validation rule base
3. goto A10, from the menu open data, validation rule, accept cell area, source
A1:A3 and OK
4: try to change to the second table - not possible
Actual Results:
You can't change to the second table
You can't close Calc (except with TaskManager)
But you can save the table!
Expected Results:
normal working spreadsheet
Reproducible: Always
User Profile Reset: No
Additional Info:
With the recovered table (reloaded calc) you can try to change the validation
rule again (for example from A1:A3 to A1:A5). Being back in the table the error
resume, you can't switch to the second table or close Calc.
--
You are receiving this mail because:
You are the assignee for the bug.
