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

bordma...@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |UNCONFIRMED
     Ever confirmed|1                           |0

--- Comment #5 from bordma...@gmail.com ---
Thanks for the interest.

No, I never knew it existed or turned off recalculate. Recalculation on file
load, to my surprise, is set to never recalculate for both Excel 97 and ODF
files (this is my home PC, I think I may have worked at home on that project). 
In my line of work, I do large spreadsheets with all sorts of formulae from
acquisition costs to discount levels, so turning off recalculate would be
suicidal !
2 causes jump to mind:
- the recovery process saved the file with some default settings (sometimes it
happens, I also work with 10 calc files open, each several sheets deep).
- from an update

I'll check Monday on the PC at work.

As for how I copied the data, I used a file from a previous project, deleted
and wrote the new data. Not sure I dragged top down in the formulae cell ranges
or used them as they were..

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to