Old sxc calc file does not recognize formulas anymore [closed]

asked 2014-02-13 12:25:29 +0200

alci gravatar image

updated 2015-09-12 17:00:41 +0200

Alex Kemp gravatar image

Hi,

I'm facing a problem when opening a sxc file, where formulas are not working. Instead they are show as textual value, eg. ooow:=SUM([.W102:.AH102])

This question is probably related to http://ask.libreoffice.org/en/question/8957/calc-cells-not-calculating-at-all/ but the solution given (adding office:class="spreadsheet"> in the content.xml file does not work.

Looking at the cell in content.xml, I see this:

<table:table-cell table:style-name="ce1029" table:value-type="string" calcext:value-type="string"
   <text:p>ooow:=SUM([.W102:.AH102])</text:p>
</table:table-cell>

I'm using LO Version: 4.2.0.4 (Ubuntu).

How can I fix my file(s) ?

(also found an open bug report here: https://bugs.freedesktop.org/show_bug.cgi?id=69489 )

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-19 10:36:26.770854

Comments

1

It seems that the file was opened and saved with an intermediary version, which had the bug. Older version of the file can be opened just fine with 4.2.0.4

alci gravatar imagealci ( 2014-02-13 14:36:33 +0200 )edit