Created attachment 184930 [details] 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
Created attachment 184931 [details] The example file before saving as ods
Created attachment 184932 [details] The example file after save and reload
That's because ODFF doesn't define Table Structured References formulas. We (I) will need to submit that to the OASIS ODF TC.