Apache OpenOffice (AOO) Bugzilla – Issue 117243
chained external references don't work
Last modified: 2014-02-18 14:26:50 UTC
A reference to a cell in an external file displays as #!REF when the referenced cell itself either is or depends on further external reference(s). ("Depends on" meaning a formula that uses cells which are external references.)
getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used.
This bug still exists at the latest version of OpenOffice Calc (4.0.1). Could somebody confirm it please?