https://bugs.documentfoundation.org/show_bug.cgi?id=153221
Bug ID: 153221
Summary: FILESAVE ODS Cell Validation source as structured
reference is saved as absolute cell reference
Product: LibreOffice
Version: 5.1.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 108988, 115775
Created attachment 184930
--> https://bugs.documentfoundation.org/attachment.cgi?id=184930&action=edit
Example file from Calc
This is split out from bug 139499 for the ods case.
Attached file had a cell validation criteria as structured reference set in A9:
ExampleRange[Left]
When saved as ods (see attached file) this is converted to an absolute cell
range as $Sheet1.$A$3:$A$6 which matches the range of ExampleRange[Left] but
the dynamic nature of the validation reference is lost.
1. Open attached file
2. Select A9 and go to Data - Validity
3. Observe the Criteria -> Source is set as $Sheet1.$A$3:$A$6
4. Change this to ExampleRange[Left] (or ExampleRange[Right] )
5. Observe that the dropdown list offers the values from A3:A6
6. Save the file as ODS & reload
7. Select A9 and go to Data - Validity
-> Now the Source field is back to $Sheet1.$A$3:$A$6 instead of
ExampleRange[Left] (or $Sheet1.$B$3:$B$6 instead of ExampleRange[Right] )
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 0bb90afaeb193181d7b98b79e962549d8a1dd85a
CPU threads: 14; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: de-DE (hu_HU); UI: en-US
Calc: threaded
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=108988
[Bug 108988] [META] Validity-related bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=115775
[Bug 115775] [META] Data range and consolidate bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug.
