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 Christopher M. Penalver
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, Christopher M. Penalver
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Christopher M. Penalver 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.