Bug 140671 - Cannot display or edit bad existing formula in table cell
Summary: Cannot display or edit bad existing formula in table cell
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
7.0.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Writer-Tables-Formulas
  Show dependency treegraph
 
Reported: 2021-02-25 21:12 UTC by Ulrich Windl
Modified: 2022-02-27 07:17 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Ulrich Windl 2021-02-25 21:12:21 UTC
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">
Comment 1 Ulrich Windl 2021-02-25 21:20:26 UTC
Another thing I had noticed is that copying formula "mean <B2:K2>" gives wrong results, but copying formula "mean(<B2:K2>)" gives the correct results.
Comment 2 Dieter 2021-03-12 07:28:15 UTC
(In reply to Ulrich Windl from comment #1)
> Another thing I had noticed is that copying formula "mean <B2:K2>" gives
> wrong results, but copying formula "mean(<B2:K2>)" gives the correct results.

Ulrich, thank you for reporting the bugs, but please don't mix two issues in one report. Please open a new report for the second problem.
Comment 3 Dieter 2022-02-27 05:51:38 UTC
Hello Ulrich, a new major release of LibreOffice is available since this bug was reported. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.