Ivanov Aleksey, this is: - a clearcut upstream issue as per: http://help.libreoffice.org/Calc/AutoCalculate
"All cells are recalculated after a sheet cell has been modified." Modifying a sheet cell in another document does not satisfy this criteria. However, your welcome to send this to the developers of the software by following the instructions at http://wiki.documentfoundation.org/BugReport . If you have done so, please tell us the number of the upstream bug (or the link), so we can add a bugwatch that will inform us about its status. - Resolving as Won't Fix in LibreOffice Packaging. This does not mean the issue will not be cared about, but if it is cared about (even by Ubuntu/Canonical contributors), it is done upstream at LibreOffice. libreoffice (Ubuntu) => Won't Fix Wishlist ** Changed in: libreoffice (Ubuntu) Importance: Undecided => Wishlist ** Changed in: libreoffice (Ubuntu) Status: New => Won't Fix -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/877324 Title: External references not updating with Autocalculate enabled Status in “libreoffice” package in Ubuntu: Won't Fix Bug description: 1) lsb_release -rd Description: Ubuntu 11.10 Release: 11.10 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.4.4-0ubuntu1 Candidate: 1:3.4.4-0ubuntu1 Version table: *** 1:3.4.4-0ubuntu1 0 500 http://us.archive.ubuntu.com/ubuntu/ oneiric-updates/main i386 Packages 100 /var/lib/dpkg/status 1:3.4.3-3ubuntu2 0 500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages 3) What is expected to happen in Calc via the Terminal: cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/877324/+attachment/2556733/+files/files.tar && file-roller -h files.tar && cd files && localc --nologo 1.ods 2.ods with AutoCalculate enabled, is if one changes the cell A1 in 1.ods, 2.ods is automatically updated. 4) What happens instead is it is not. WORKAROUND: Ctrl+Alt+F9. Reproducible in: lsb_release -rd Description: Ubuntu precise (development branch) Release: 12.04 apt-cache policy libreoffice-writer libreoffice-writer: Installed: 1:3.5.0-1ubuntu2 Candidate: 1:3.5.0-1ubuntu2 Version table: *** 1:3.5.0-1ubuntu2 0 500 http://archive.ubuntu.com/ubuntu/ precise/main i386 Packages 100 /var/lib/dpkg/status ProblemType: Bug DistroRelease: Ubuntu 11.10 Package: libreoffice-common 1:3.4.3-3ubuntu2 ProcVersionSignature: Ubuntu 3.0.0-12.20-generic 3.0.4 Uname: Linux 3.0.0-12-generic i686 NonfreeKernelModules: wl ApportVersion: 1.23-0ubuntu3 Architecture: i386 Date: Tue Oct 18 14:31:53 2011 PackageArchitecture: all ProcEnviron: LC_CTYPE=ru_RU.UTF-8 PATH=(custom, user) LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: libreoffice UpgradeStatus: Upgraded to oneiric on 2011-10-15 (3 days ago) mtime.conffile..etc.libreoffice.soffice.sh: 2009-10-23T11:00:53 mtime.conffile..etc.libreoffice.sofficerc: 2010-10-01T02:35:43 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/877324/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
