<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Field > Insert > More Fields > Insert Formula behave differently when in a table, to when not in a table" href="https://bugs.documentfoundation.org/show_bug.cgi?id=109301#c7">Comment # 7</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Field > Insert > More Fields > Insert Formula behave differently when in a table, to when not in a table" href="https://bugs.documentfoundation.org/show_bug.cgi?id=109301">bug 109301</a> from <a class="email" href="mailto:rb.henschel@t-online.de" title="Regina Henschel <rb.henschel@t-online.de>"> Regina Henschel</a> <pre>(In reply to Heiko Tietze from <a href="show_bug.cgi?id=109301#c6">comment #6</a>) > Is there any good reason to make this distinction? I mean why not 'ignore' > the table:formula and just use text:expression in the table as well. (1) I think, the central idea is in the note in section "9.1.1 General", "Note: There is only one model for tables, although tables, such as for spreadsheets, may have additional capabilities when compared to tables in text documents." That means, that cell attributes, formula included, are treaded the same in Writer and Calc. Historically LibreOffice uses different syntax for formulas in Writer and Calc, but that is not a demand of the specification. (2) If you use a <text:expression> element, then it is child of a <text:p> element in the content of a cell. That adds two levels nesting to access the formula. (3) Each cell has a type, defined by the office:value-type attribute and a value, defined by one of the office:value, office:boolean-value, office:string-value,... attributes. Only in case of office:value-type="string" and missing office:string-value attribute the cell content itself is the "value" of the cell. The <text:expression> element is child of a <text:p> element in the content of a cell. The content of the cell can only be "value" of the cell, if the cell is of type string. But if it is a string, you cannot calculate with the value, at least not with the Writer formula syntax, which does not know any string-functions. If you provided an automatic conversion, you would get all the problems of text->number conversion and its language dependency known from Calc. (4) The office:value is faulty in <text:expression> in current implementation. Its value is always 0 but should be the result of the formula.=> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Always office:value="0" for field variable "Formula", which is <text:expression> in file format" href="show_bug.cgi?id=111674">bug 111674</a></pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>