Created attachment 44095 [details]
Formulas with Indirect not recalculated.ods
Downstream bug may be found at:
1) lsb_release -rd
Description: Ubuntu 10.10
2) apt-cache policy libreoffice-calc
*** 1:3.3.1-1ubuntu3~maverick1 0
500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages
3) What is expected to happen via the Terminal:
cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/617264/+attachment/1487753/+files/Formulas%20with%20Indirect%20not%20recalculated.ods && localc -nologo Formulas\ with\ Indirect\ not\ recalculated.ods
Click Tools -> Cell Contents -> AutoCalculate is checked
If one puts a 1 in cell A1 then cell A3:
=IF(A1="","A1 is empty",INDIRECT("'Sheet1'.B1"))
automatically reflects the change.
4) What happens is it does not.
This one has alrady been fixed on master as part of the fix for Bug 31939. The fix will appear in 3.4 and 3.3.2.