https://bugs.freedesktop.org/show_bug.cgi?id=75492

          Priority: high
            Bug ID: 75492
          Keywords: regression
          Assignee: libreoffice-bugs@lists.freedesktop.org
           Summary: FILEOPEN ODT Silent corruption of formulas in TABLE
          Severity: critical
    Classification: Unclassified
                OS: All
          Reporter: mikekagan...@hotmail.com
          Hardware: Other
            Status: UNCONFIRMED
           Version: 4.2.0.0.beta1
         Component: Writer
           Product: LibreOffice

Created attachment 94712
  --> https://bugs.freedesktop.org/attachment.cgi?id=94712&action=edit
Bug doc

When opening attached ODT with LO 4.2.0.0.beta1 and higher (including 4.2.1.1),
all the tables look normal. But interacting with some of the tables, or e.g.
printing document, corrupts their contents - the cells contents becomes **
Expression is faulty **.
The cells that exhibit this problem contain formulas that refer to other
tables, as well as some variables. Actually, the formulas are corrupted on
opening, but the cells initially show cached data, so the problem is only
evident on recalculation.

To see the problem, open the attached document, scroll down to page 11 and
hover over column B (or D) of Table32. You may notice that the formulas are
already corrupt (contain something like "=qо*<Table26.?>*(1+k1)/1000" - note
the question mark instead of cell address). Until clicked, the table looks
normal. Clicking inside the table immidiately makes most cells contain "**
Expression is faulty **".
Opening the same document with LO 4.1.5.3 and older shows that the cells
contain correct formulas like "=qо*<Table26.D2>*(1+k1)/1000".
If this file is opened with 4.2.x, then simply saved, then the corruption
becomes permanent, i.e. opening such saved ODT with 4.1.x and lower gives
corrupted formulas.

Tested with 4.2.0.0.beta1 - 4.2.1.1 under Win7x64 and 4.2.1.1 under Ubuntu
13.10 64-bit.
Not reproducible under 4.1.5.3 and lower -> regression.

This is a critical bug, because:
1. It affects the native ODT format;
2. It corrupts data;
3. The corruption may happen unnoticed, if one opens the document, makes some
modifications outside of problematic table, then saves document; the problem
could only be noticed after reopening the already corrupted file;
4. It is a regression.

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

Reply via email to