Created attachment 86015 [details] Spreadsheet to be opened Open the attached spreadsheet file R.sxc. The cells containing formulas (in particular, D3) do not appear as formulas. E.g., D3 appears as "ooow:=[.D2]-[.B3]". Another peculiarity: Following the instructions in the bottom entry on http://ask.libreoffice.org/en/question/8957/calc-cells-not-calculating-at-all/, I edited the .sxc file by adding the attribute office:class="spreadsheet" to the office:document-content element in the content.xml file and re-zipped the .sxc file. Libreoffice could then open the file and display the formulas correctly. I then saved it as an .sxc file under a new name. But I could not then open the newly created .sxc file -- the formulas appeared in the same peculiar way as described above. Examining the contained content.xml file, it did not contain the office:class attribute. Another peculiarity: I opened an .sxc file created by a considerably older version of OpenOffice. Libreoffice displayed the formulas correctly. Examining the contained content.xml file, it contained the office:class attribute. The version of Libreoffice I am using to open the .sxc file: libreoffice-calc-4.1.1.2-4.fc19.x86_64 (and associated RPMs as fetched by yum) The version of Libreoffice used to create the .sxc file: libreoffice-calc-3.4.6.2-1.fc16.i686 The Linux version (Fedora 19): Linux hobgoblin.ariadne.com 3.10.11-200.fc19.x86_64 #1 SMP Mon Sep 9 13:03:01 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
Is this attached file a file that you opened and then saved and then reopened? I think we need a file that actually hasn't been saved on a new release of libreoffice Attached you'll find a simple sheet that I created in LibreOffice 3.5alpha0 and it opens fine (just a single formula =1+1 in cell A1 marking as NEEDINFO. Please attach a document that has not been resaved. With the other method you used (XML edits) did you try saving as a ods instead? Once you provide another sheet and answer the question mark as UNCONFIRMED and we'll investigate Thanks!
Created attachment 89294 [details] Working sxc file with formula
*** This bug has been marked as a duplicate of bug 74979 ***