[Libreoffice-bugs] [Bug 109301] New: Formula bar and insert formula field behave differently when in a table, to when not in a table

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 109301
           Summary: Formula bar and insert formula field behave
                    differently when in a table, to when not in a table
           Product: LibreOffice
           Version: 5.3.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Writer
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at troy.rollo.name

When inserting a Formula Field (Insert...Field...More
Fields...Variables...Insert Formula), Writer behaves differently depending on
whether the current insertion point is or is not inside the table. When in a
table, Writer treats the action as inserting a table formula. Outside a table,
they insert a formula field.

See the "TYP_FORMELFLD" case in SwFieldMgr::InsertField in fldmgr.cxx

These two formula types is different. As an example, in the Formula field,
variables are available - not so in the table formulas. If the field is
inserted outside the table, it can be copied into the table, where it works
correctly. However if the field is inserted directly into the table, it is
likely to be invalid because it is using the wrong formula type.

Additionally, table formulas that are not the only content in their cells
appear not to generate any results. Because of this, when inserting a formula
field in a table cell, other than as the only thing in the table, it appears
that nothing has happened at all.

The current behaviour is confusing and inconsistent.

Suggested behaviour:

1. Inserting the field from the Insert field dialog should always insert the
field, even if in a table.
2. If it is preferred to keep the current (different) behaviour with the
formula bar, the UI should make it clear what is going on.

I have not looked at whether the syntax for the two formula types is compatible
at a high level, so that the table ones could be merged into the formula field.

-- 
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/20170724/3de89533/attachment.html>