https://bugs.freedesktop.org/show_bug.cgi?id=83848
Priority: medium
Bug ID: 83848
Assignee: [email protected]
Summary: UI: Data Validity Cell range broken with Excel R1C1 or
A1 formula syntax
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.1.6.2 release
Component: Spreadsheet
Product: LibreOffice
Problem description: formula syntax Excel R1C1 or A1 can not be used with
Validity UI when choosing "Cell range"
Steps to reproduce:
1. Set Excel R1C1 or Excel A1 formula syntax with Tools > Options > LibreOffice
Calc > Formula
2. Open Validity UI: Data > Validity
3. Select "Cell range"
4. Choose "Source" with the shrink button
Observed result:
Reference syntax of Source follows Calc A1. Click OK result in two choices
build from part of the wrongly interpreted reference: "$sheet1$a$1" and
"#NAME?"
Expected result:
Reference syntax should follow formula syntax chosen in options. Click OK
should give the choice of the selected cells.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
