https://bugs.documentfoundation.org/show_bug.cgi?id=145994
--- Comment #9 from Joshua Coppersmith <[email protected]> --- This can even be direct entry of a file:/// reference into a cell, as a CSE or as a normal cell value. In any case the #NAME? appears on reload: =‘file:///c:/users/me/documents/reference_values.ods’#fruit results in #NAME? on reload, or at least on reload then a proper recalculate. What is more, if you edit a cell with the file:/// reference then it will update. Even the old add-a-space-then-enter trick works to update. [Adding & T(RAND()*0) to the reference does not seems to help updating, as expected since hard-calculate doesn't help.] Even more, if you 'tickle' any named range with a file:/// reference not only will it update, but so will any cells with direct file:/// references. It does not go the other way around. Editing a direct entry will not cause named range references to update. -- You are receiving this mail because: You are the assignee for the bug.
