[Libreoffice-bugs] [Bug 145994] references to named ranges in external files do not update on document open
https://bugs.documentfoundation.org/show_bug.cgi?id=145994 BogdanB changed: What|Removed |Added Blocks||109178 CC||buzea.bog...@libreoffice.or ||g Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=109178 [Bug 109178] [META] Named Cell Ranges and Formula Expressions bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145994] references to named ranges in external files do not update on document open
https://bugs.documentfoundation.org/show_bug.cgi?id=145994 Eike Rathke changed: What|Removed |Added Severity|normal |enhancement Hardware|x86-64 (AMD64) |All OS|Windows (All) |All Version|7.2.2.2 release |unspecified --- Comment #10 from Eike Rathke --- The reason is that for external references the sheet names and used cell data are cached and stored in the target document, but not names nor what names would resolve to (remember it could be cell ranges or any kind of formula expressions that without the source document may not make sense at all). This kind of deep loading happens only when the formula expression input is resolved, not on reload or recalculation. For simple named ranges (and defined database ranges) the external names and their ranges would have to be additionally stored in the target document. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145994] references to named ranges in external files do not update on document open
https://bugs.documentfoundation.org/show_bug.cgi?id=145994 --- Comment #9 from Joshua Coppersmith --- 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.
[Libreoffice-bugs] [Bug 145994] references to named ranges in external files do not update on document open
https://bugs.documentfoundation.org/show_bug.cgi?id=145994
--- Comment #8 from Eike Rathke ---
This can be shortened to
=SUM('file:///...'#rangename)
which already results in a #NAME? error when reloading and being hit by the
Allow Updating InfoBar.
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145994] references to named ranges in external files do not update on document open
https://bugs.documentfoundation.org/show_bug.cgi?id=145994 --- Comment #7 from Andreas Säger --- Created attachment 176655 --> https://bugs.documentfoundation.org/attachment.cgi?id=176655=edit target sheet with rows count of external "Named" -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145994] references to named ranges in external files do not update on document open
https://bugs.documentfoundation.org/show_bug.cgi?id=145994 --- Comment #6 from Andreas Säger --- Created attachment 176654 --> https://bugs.documentfoundation.org/attachment.cgi?id=176654=edit source sheet with 4 rows in "Named" -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145994] references to named ranges in external files do not update on document open
https://bugs.documentfoundation.org/show_bug.cgi?id=145994
--- Comment #5 from Andreas Säger ---
(In reply to Andreas Säger from comment #4)
> It worked like this since OOo1. This is an enhancement request (and a can of
> worms, IMHO).
I think my above statement is wrong. It has been implemented somehow but
faulty.
I'll upload a more simple test case with a range named "Named" in the source
file and the forumla =ROWS('file:///path/source.ods'#Named) in the target file.
The uploaded row count is 4.
1) Open the source, insert a new row in "Named", save and close.
2) Open the target. The formula reports a row count of zero which is a strange
return value. ROWS never returns zero.
3) Allow updating external references, hit Ctrl+Shift+F9 for hard
recalculation. Still zero.
4) Hit F2 Enter for a dummy edit and the formula returns 4 which is the
old result. We would expect 5.
5) Open the source document and repeat step 4). Now the result is correct.
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145994] references to named ranges in external files do not update on document open
https://bugs.documentfoundation.org/show_bug.cgi?id=145994 --- Comment #4 from Andreas Säger --- It worked like this since OOo1. This is an enhancement request (and a can of worms, IMHO). -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145994] references to named ranges in external files do not update on document open
https://bugs.documentfoundation.org/show_bug.cgi?id=145994 Gabor Kelemen (allotropia) changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #3 from Gabor Kelemen (allotropia) --- Confirming issue in Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: b2c56ac95b15b675b9fabed889e7f9709bdc793f CPU threads: 13; OS: Windows 10.0 Build 19042; UI render: default; VCL: win Locale: en-US (hu_HU); UI: en-US Calc: threaded After downloading the two example files one needs to update the range location in the Manage Names dialog of the calculations.ods to have the functions updated. After save and reload only clicking in the Manage Names dialogs Range or formula expression field and closing the dialog updates the formula. The Allow updating button on the infobar does nothing, neither the Recalculate or Recalculate hard commands, or opening & closing the Edit Links dialog. The behavior seems to be like this since 5.1, in older versions not even this method has worked: so this not a regression. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145994] references to named ranges in external files do not update on document open
https://bugs.documentfoundation.org/show_bug.cgi?id=145994 --- Comment #2 from stderr --- Created attachment 176635 --> https://bugs.documentfoundation.org/attachment.cgi?id=176635=edit file with data referenced by calculations.ods -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145994] references to named ranges in external files do not update on document open
https://bugs.documentfoundation.org/show_bug.cgi?id=145994 --- Comment #1 from stderr --- Created attachment 176634 --> https://bugs.documentfoundation.org/attachment.cgi?id=176634=edit file with vlookup commands referencing external data -- You are receiving this mail because: You are the assignee for the bug.
