Bug 34989 - Calc formulas with INDIRECT not honoring AutoCalculate
Summary: Calc formulas with INDIRECT not honoring AutoCalculate
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.1 release
Hardware: x86 (IA32) Linux (All)
: lowest trivial
Assignee: Kohei Yoshida
URL:
Whiteboard: target:3.4 target:3.3.2
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-03 15:02 UTC by Chris Peñalver
Modified: 2011-03-03 16:21 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Formulas with Indirect not recalculated.ods (7.63 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-03-03 15:02 UTC, Chris Peñalver 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Chris Peñalver 2011-03-03 15:02:28 UTC 
Created attachment 44095 [details]
Formulas with Indirect not recalculated.ods

Downstream bug may be found at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/617264

1) lsb_release -rd
Description: Ubuntu 10.10
Release: 10.10

2) apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.1-1ubuntu3~maverick1
  Candidate: 1:3.3.1-1ubuntu3~maverick1
  Version table:
 *** 1:3.3.1-1ubuntu3~maverick1 0
        500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages
        100 /var/lib/dpkg/status

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.
Comment 1 Kohei Yoshida 2011-03-03 16:21:01 UTC 
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.