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.

Reply via email to