https://bugs.documentfoundation.org/show_bug.cgi?id=155082
Bug ID: 155082
Summary: Incorrect calculation of custom formula in "Data
Validity" when formula inputs are pasted from another
sheet.
Product: LibreOffice
Version: 7.5.2.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: binom3...@yandex.ru
Description:
I have .xlsx file with 2 sheets:"Sheet1" and "Sheet2". In "A1" cell of "Sheet1"
custom formula "Data Validity" is set. In "D1"-"D10" cells of "Sheet2" 10
values are written. Custom formula "Data Validity" for "A1" in "Sheet1" uses
values from "D1"-"D10" cells of Sheet2. This formula performs incorrect results
forbidding any values entry.
Steps to Reproduce:
1. Open the attached file "Bug2.xlsx"
2. Enter value "hello" in "A1" cell of "Sheet1". This entry will be forbidden.
It's the error. Value "hello" must be allowed to entry in "A1" cell.
Actual Results:
Entry of any values in "A1" cell of "Sheet1" is forbidden.
Expected Results:
Any values must be allowed to entry in "A1" cell of "Sheet1" excepting values
equal to "D1"-"D10" cells of "Sheet2" values.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.5.2.2 (X86_64) / LibreOffice Community
Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2
CPU threads: 12; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: ru-RU (ru_RU.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
