Since I updated to 4.4.5.2 (on OS x 10.10.5) Calc can’t seem to cope with saving and reopening .xml spreadsheets with very basic formulas.
ie. I entered =B3-B2, and the calculation worked, but when I reopened the file, it had become: of:]=[.B3]-[.B2] which of course was not the answer I was looking for.
It works in .ods but I need .xml compatibility. Should I report this as a bug?