Hi, On Fri, 2011-08-19 at 00:38 -0700, 10o wrote:
In Ubuntu 11.04 I am using serveral spreadsheets that come from OpenOffice, which came with previous versions of Ubuntu. I recently noticed that formula cells are not always automatically adjusted according to changes in cells used in that formula. When I even notice inconstant behaviour, I have to "revisit" the adjusted cell an if I am lucky, the formula cell is recalculated as expected. I run several business administrative spreadsheets and this surely is a serious problem. -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-Calc-serious-problem-bug-in-formulas-when-adjusting-cells-used-tp3267392p3267392.html Sent from the Users mailing list archive at Nabble.com.
My initial guess is that autoupdate is turned off. Check when the spreadsheet is open that TOOLS>>CELL_CONTENTS>>AutoCalculate is checked. -- Jay Lozier jslozier@gmail.com -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted