https://bugs.freedesktop.org/show_bug.cgi?id=69489
Priority: medium
Bug ID: 69489
Assignee: [email protected]
Summary: FILEOPEN Spreadsheet in sxc format does not open
correctly: Formulas do not appear as such
Severity: major
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
Created attachment 86015
--> https://bugs.freedesktop.org/attachment.cgi?id=86015&action=edit
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
--
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
