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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
