In LO 184.108.40.206 Build ID: 350m1(Build:2) on ubuntu 10.04, I am trying to build a formula including a reference to a named range on a sheet in another .ods file. The named range is scoped to the sheet rather than to the workbook. What syntax will let me use the name in my formula? For example, I expect it would look something like this:
Is there some way to have LO recognise/suggest the range name and/or replace a reference to an explicit cell range with the corresponding reference to the named range?