Question from the German forum Calc - verknüpfung zu externer Datei
Does anybody know if DDE-Links can reference sheet specific range names as in =DDE("soffice";/path/file.ods";"Sheet1.MyRange") or =DDE("soffice";/path/file.ods";"Sheet1!MyRange")? Is it a bug or a missing feature?
No. ScServerObject::ScServerObject ctor uses lcl_FillRangeFromName to convert the item to range name; and it only uses document-global ranges collection (returned by ScDocument::GetRangeName), not sheet-local counterpart, which would need to parse the sheet name from the item first.
This is tdf#64131.
2 Likes