https://bugs.documentfoundation.org/show_bug.cgi?id=145994
--- Comment #5 from Andreas Säger <ville...@t-online.de> --- (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 <Space> 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.