[Libreoffice-bugs] [Bug 140671] New: Cannot display or edit bad existing formula in table cell

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=140671

            Bug ID: 140671
           Summary: Cannot display or edit bad existing formula in table
                    cell
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Writer
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: Ulrich.Windl at rz.uni-regensburg.de

As it seems I can enter a formula like "min<K2:M2>" in a formula cell and the
expression is calculated.
Sometimes there are errors with the formulas, and I only get a message
displayed inside the table cell that goes like "** Fehlerhafter Ausdruck" (in
German, probably "Error in expression").
When I hover with the mouse over the error message I see something like
"min(<?:?>)", but I can neither display the formula permanently (like via
Control+F9), nor can I edit such existing formulas via F2; when I try to edit a
formula, I see an empty formula, meaning I have to re-enter the formula.
It seems the problem occurs *sometimes* if the formula has been copied from
another row. It also seems the problem does not occur if the formula was copied
from another column in the same row.
Usability is just terrible.

When viewing content.xml of such a document, a bad formula looks like this:
<table:table-cell table:style-name="Tabelle9.A1"
table:formula="ooow:MAX(<?:?>)" office:value-type="float"
office:value="1.7976931348623157E+308">

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210225/4aec7c46/attachment.htm>