https://bugs.documentfoundation.org/show_bug.cgi?id=97238

Eike Rathke <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |NEW
         Resolution|WORKSFORME                  |---
            Summary|miscalculation              |document not saved in fully
                   |                            |calculated state
     Ever confirmed|0                           |1

--- Comment #2 from Eike Rathke <[email protected]> ---
Ctrl+A isn't needed for hard recalc, Shift+Ctrl+F9 is sufficient. Recalc cures
the symptom, but it would be interesting to know how this document state sprang
into existence..

The document apparently was saved without being recalculated, however that may
have happened, it might be that AutoCalculate was off when modifying the
document and then switched on before saving but without actually having
recalculated. Was that the case? Did you delete/empty cells in the colored
columns while AutoCalculate was off?

Current versions don't recalculate documents when loading.

If you have more than this document in such state you may want to enable
Tools->Options->Calc->Formula "Recalculation on File Load" for ODF spreadsheet.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to